Re: Can't connect remotely

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <mcravitz(at)att(dot)net>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can't connect remotely
Date: 2008-05-07 21:29:06
Message-ID: 4821D8D0.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> <mcravitz(at)att(dot)net> wrote:

> listen_addresses = 'localhost,marlon,loaner-mikec'
> # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
> # (change requires restart)

You probably want this set to '*'.

It is not the addresses to allow in, it is the addresses to listen on.
(You might have multiple network cards in the database server and
only want to accept database connections on one of them, for example.)

The pg_hba.conf file can be configured to allow specific addresses in,
so that may be OK as it stands.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Darren Reed 2008-05-07 23:28:49 postgres doesn't detect other end of the unix socket is gone...
Previous Message Barbara Stephenson 2008-05-07 19:38:42 Converting from 7.4.19 To 8.3.1 & want to use autovacuum