On Thursday 20 April 2006 14:01, kevin.kempter@xxxxxxxxxxxxxxxxx wrote: > 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 Just uncomment the "port = 5432" line, leave the "listen_addresses" commented out since the default is to listen to localhost and '*' (any host). Then make sure you have a 5432 entry in your /etc/services file like this: postgresql 5432/tcp # PostgreSQL Database and life should be good...
