Mailinglist Archive: opensuse (4570 mails)

[Michal Hlavac <michal.hlavac@xxxxxxxxxx>]

Anders Johansson wrote:
> 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 *

thanks...

but when I add "-h *" to POSTGRES_OPTIONS postgresql doesn't start.

/var/log/postgresql:
postmaster: invalid argument: "data"
Try "postmaster --help" for more information.

I don't understand, because in /etc/init.d/postgresql is no data argument.

thanks, miso