Re: Postgres does not accept socket connections

am 02.03.2006, um 4:37:02 -0800 mailte kishore(dot)sainath(at)gmail(dot)com folgendes:
> Hi All,
>
> I have the following problem.
>
> I am able to access a PostgreSQL database only as "localhost". If I try
> to open psql from a different machine with -h option, then I get the
> following error message.
>
> The database resides on a server running Fedora Core 4 and PostgreSQL
> 8.1.1 server.
> I am trying to access the database from another server running RedHat 9
> and PostgreSQL 7.3.2.
>
> Command
> psql -U postgres -h server-name database-name
>
> Error
> psql: could not connect to server: Connection refused
> Is the server running on host "server-name" and accepting
> TCP/IP connections on port 5432?

Check the postgresql.conf for the value "listen_addresses".
My guess: listen_address is at the moment 'localhost'. Change this to
the LAN-address or '*'.
Read also the pg_hba.conf - file!

http://www.postgresql.org/docs/current/static/client-authentication.html#AUTH-PG-HBA-CONF

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===