postgres TCP Connection [WAS Re: postgresql dblink not working in FC5]
kevin.kempter at dataintellect.com
kevin.kempter at dataintellect.com
Thu Apr 20 20:01:52 UTC 2006
On Thursday 20 April 2006 13:47, Mauricio Vergara Ereche wrote:
> 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
In postgres version 8:
"server configuration parameters virtual_host and tcpip_socket have been
replaced with a more general parameter listen_addresses. Also, the server now
listens on localhost by default, which eliminates the need for the -i
postmaster switch in many scenarios."
http://www.postgresql.org/docs/8.1/static/release-8-0.html
More information about the users
mailing list