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
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 *
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
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
On Thursday 03 November 2005 22:12, Michal Hlavac wrote:
but when I add "-h *" to POSTGRES_OPTIONS postgresql doesn't start.
Sorry, you should add it without the quotes. But I also found that you need to add a \ before the * for some reason. Anyway, the whole like should look like POSTGRES_OPTIONS="-h \*"
On Thursday 03 November 2005 22:21, Anders Johansson wrote:
On Thursday 03 November 2005 22:12, Michal Hlavac wrote:
but when I add "-h *" to POSTGRES_OPTIONS postgresql doesn't start.
Sorry, you should add it without the quotes. But I also found that you need to add a \ before the * for some reason. Anyway, the whole like should look like
POSTGRES_OPTIONS="-h \*"
And, considering your other mail, I should add that you then start it with rcpostgresql start
Anders Johansson wrote:
On Thursday 03 November 2005 22:21, Anders Johansson wrote:
but when I add "-h *" to POSTGRES_OPTIONS postgresql doesn't start. Sorry, you should add it without the quotes. But I also found that you need to add a \ before the * for some reason. Anyway, the whole like should look
On Thursday 03 November 2005 22:12, Michal Hlavac wrote: like
POSTGRES_OPTIONS="-h \*"
aarrrghh, I fool... ;) thanx...
participants (2)
-
Anders Johansson -
Michal Hlavac