Postgresql connection on suse 10

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

Michal Hlavac <hlavki@hlavki.sk> writes:

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...

Edit the "listen_addresses" parameter in postgresql.conf, then
restart.

-Doug

Leonel Nunez wrote:

edit your postgresql.conf and set the listen_address variable
to your needs

thanks Leonel,

it is possible to setup subnet mask for postgresql through listen_address??

thanks, miso

Michal Hlavac <hlavki@hlavki.sk> schrieb:

Leonel Nunez wrote:

edit your postgresql.conf and set the listen_address variable
to your needs

thanks Leonel,

it is possible to setup subnet mask for postgresql through listen_address??

Yes, of course, in CIDR-Notation.

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�