PostgreSQL connect from client PC

[Juraj]

Hi All,

I am testing a new app using PostgreSQL. Everything works OK on the local PC. If I want to connect from a client PC, I have a problem to connect to PostgreSQL Server. The server PC with Windows 7 Ultimate 64b., The client PC with Windows 10 Pro 64b. Can anyone help?

Juraj

[FFF]

I am testing a new app using PostgreSQL. Everything works OK on the local PC. If I want to connect from a client PC, I have a problem to connect to PostgreSQL Server. The server PC with Windows 7 Ultimate 64b., The client PC with Windows 10 Pro 64b. Can anyone help?

Probably not - too less information available.
Can you connect using psql or similiar tool to the db at the server at all? What did you write in the postgres.conf re allowed access sources?

[Juraj]

I insert to pg_hba.conf this line
host all all 192.168.0.127/24 md5

in postressql.conf
listen_addresses = '*'

I check connet from client PC with Postgres ODBC

[wriedmann]

Hi Juraj,
IMHO

Code: Select all

host all all 192.168.0.127/24 md5

should be

Code: Select all

host all all 192.168.0.1/24 md5

Do you have restarted the Postgres server process after the changes?
If your host is a Windows machine, you need also to open the firewall on the port 5432.
Wolfgang

[Juraj]

Hi Wolfgang,

I open the firewall on the port 5432 on client PC. When I open the firewall on the port 5432 on server PC, connection is OK.
Thank you very much!

Juraj

[wriedmann]

Hi Juraj,
normally the Windows Firewall is configured to permit all exiting connections (otherwise you would have to open every single port for every client machine).
Incoming connections are normally all blocked - if you have some service that needs to be reachable from other machines you have to add a rule by hand.
Normally the installation process could open the port, but IMHO it is better to not do that, and to let this work to the administrator.
Wolfgang