I just recently install PostgreSQL on our server via SSH. The installation went successful, until the time I tried to connect to it using pgAdmin on my Windows machine. I received this kind of error:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "xxx.xxx.xxx.xxx" and accepting TCP/IP connections on port 5432?
The docs suggest this can be fixed by setting the value of
listen_addresses = '*' in the
/etc/postgresql/9.1/main/postgresql.conf. I did that but still it won't let me.
What seems to be missing?