postgres TCP Connection [WAS Re: postgresql dblink not working in FC5]

Mauricio Vergara Ereche mave at nic.cl
Thu Apr 20 19:47:20 UTC 2006


El Jueves, 20 de Abril de 2006 15:39, Gordon Messmer escribió:
[...]
> So... is postmaster listening on the TCP port?  It would need to be, if
> you're specifying 'hostaddr'.
>
> Use 'netstat -tlnp' to see if port 5432 is open.  If not, you'll need to
> configure Postgres to listen on a TCP socket.  You can either specify
> "PGOPTS=-i" in /etc/sysconfig/pgsql/postgresql, or "tcpip_socket = true"
> in /var/lib/pgsql/data/postgresql.conf

That last option gives me in /var/lib/pgsql/pgstartup.log this message

FATAL:  unrecognized configuration parameter "tcpip_socket"

It's misspelled or something?

-- 
Mauricio Vergara Ereche                   User #188365 counter.li.org
NIC Chile                                         mave [@] nic [.] cl
Agustinas 1357 Piso 4, Santiago CHILE                   +56 2 9407721
Codigo Postal: 834-0432                             http://www.nic.cl




More information about the users mailing list