On Thursday 03 November 2005 21:21, Michal Hlavac wrote:
hello,
I installed PostgreSQL 8.0.3 on Suse 10 (x86_64).
Firewall is down.
telnet localhost 5432 result:
xxxxx:/var # telnet localhost 5432 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'.
but telnet ip_address 5432 result:
xxxxx: # telnet 158.195.xx.xx 5432 Trying 158.195.xx.xx... telnet: connect to address 158.195.xx.xx: Connection refused
Why I cannot connect to ip address?????? I tried to add line to pg_hba.conf, then restart, but no change...
The default is to only talk to localhost, for security reasons that should be obvious. If you want to enable the external interface, edit /etc/sysconfig/postgresql and add "-h *" to the POSTGRES_OPTIONS variable and restart the postgres server. If you have multiple network cards, you can specify an ip address or hostname of the interface you want to use instead of *