Hi I have a Synology NAS DS216j in my LAN and I am running a postgreSQL database on it.
I am try to find a way to connect and run my database from a computer outside my LAN so I can use it and update it. In order to do that I had to forward the port 5432 (postgres) and WebDav (5005) of my router to the NAS.
The port Postgresql (5432) and WebDav (5005 )is open on my public IP. The port Postgresql (5432) and WebDav (5005 )is open on the NAS.
From the remote host: I am able to see the database file (in LibreOffice Base), on the NAS if I connect with quickconnect or WebDav (in windows I installed the program: NetDrive).
I am able to connect to the database structure with PgAdminIII. but I am not able to Launch/Open the database. When I get prompt the user and password I just get this error saying:
The connection to the data source "NAS" could not be established. Couldnt establish database connection to ´sdbc:postgresql:postgresql://192.168.0.20:5432/dbname´ could not connect to the serve: Connection timed out (0x0000274c/10060). Is the server running on host 192.168.0.20 and accepting TCP/IP connection on port 5432?
I wonder why I am able to connect with PgAdminIII but not able to open the LibreOffice Base from WebDav.