am 02.03.2006, um 4:37:02 -0800 mailte [EMAIL PROTECTED] 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 === ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
