Search Postgresql Archives

Re: Postgres does not accept socket connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



After a long battle with technology, kishore.sainath@xxxxxxxxx, 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux