Why cannot I connect to PostgreSQL Server?
1. Make sure that there is a record for your client PC in pg_hba.conf file on PostgreSQL server. This file can be found in database cluster’s data directory. 2. If you connect to the remote server, then the TCP/IP connections should be allowed on the remote server. In this case you need to edit file postgresql.conf on the server: just add the name or TCP/IP of the client PC in the listen_addresses list. Or you can as well put * character; in this case the connection from any host will be allowed. You can get the same result if you run the server with -i option, which is the same as listen_addresses = ‘*’. 3. Make sure that you enter the correct login/password. 4. You use password authentication, but it is not supported in SQL Manager.
