Mailinglist Archive: opensuse (4570 mails)

[Anders Johansson <andjoh@xxxxxxxxxx>]

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 *