Could not connect to server: Connection timed out (0 x0000274c/10060) Is the server running on the host "192.168.3.202" and has the TCP/IP connections on port 5432?
Everyone a great god, and how to settle the problems in the PGSQL

CodePudding user response:

PgAdmin is the client, the client wants to connect the service side need to be done on the server related configuration:
(1) to modify the database file pg_hba. Conf file, add the client machine IP inside, the sample is as follows:
# TYPE DATABASE USER ADDRESS METHOD
The host all all 192.168.13.51/32 trust
Restart the database effective
(2) the port to postgresql pgAdmin ceremony.do conf file configuration port corresponding values
(3) modify the postgresql. Conf configuration line like listen_addresses='*'
Restart the database effective
(4) the firewall problem

CodePudding user response:

This machine can be directly try localhost

CodePudding user response:

The second floor right!!!!!!!!!!!!!!!!!!!!!!!

CodePudding user response:

1/f, the steps you can try
Or in 2 floor under test

CodePudding user response:

Modify the configuration file postgresql. Conf
Line like listen_addresses='*' # what IP address (es) to listen on.
# Comma - separated list of addresses.
# Defaults to 'localhost', '*'=all
# (Change the requires restart)
Port=5432 # (change the requires restart)
Max_connections=100 # (change the requires restart)
Password_encryption=on

CodePudding user response:

Hello, are you still in, I would like to contact you to understand the postgresql

CodePudding user response:

O look at the port is in in direct PSQL can go in, even is to change the conf configuration remotely