Mailinglist Archive: opensuse (4570 mails)

[Michal Hlavac <michal.hlavac@xxxxxxxxxx>]

Michal Hlavac wrote:
> 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

I try this:
#su postgres
#pg_ctl start -s -w -p /usr/bin/postmaster -D /var/lib/pgsql/data -o "-h *"
postmaster: invalid argument: "data"
Try "postmaster --help" for more information.

strange, miso