Postgres does not accept socket connections

After a long battle with technology, kishore.sainath@gmail.com, an earthling, wrote:

I need the PostgreSQL server on the machine which contains the database
to accept socket connections.
Any help in this regard will be appreciated.

Look for the configuration file postgresql.conf.

It is doubtless set up to only accept local connections. That is the
default configuration, and represents a decent default security
measure.

Look in that file for a variable called "listen_addresses." You'll
doubtless find it commented out. The suggested value is "*", that is,
to accept connections coming to all IP interfaces. That's probably
what you want to change it to.

Restart the database (reloading config won't suffice, I don't think).

You should have remote access.

You may then get complaints that pg_hba.conf won't admit the
connections; that file is in the same directory. If you change it,
you need only reload PostgreSQL configuration; you don't need to
restart the database...
--
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/slony.html
REALITY is a policy phased out early in the Eisenhower administration.

am 02.03.2006, um 4:37:02 -0800 mailte kishore.sainath@gmail.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 ===

"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:

am 02.03.2006, um 4:37:02 -0800 mailte kishore.sainath@gmail.com folgendes:

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 '*'.

If listen_addresses is correct and you still get "Connection refused",
the other thing to look at is the kernel's packet filtering rules
(iptables). I believe the default configuration on FC4 will reject
external connections to 5432.

regards, tom lane