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