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... thanks, miso ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
edit your postgresql.conf and set the listen_address variable to your needs
leonel ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match