Re: Can't connect remotely - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Can't connect remotely
Date
Msg-id 4821D8D0.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Can't connect remotely  (mcravitz@att.net)
List pgsql-admin
>>> <mcravitz@att.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


pgsql-admin by date:

Previous
From: Barbara Stephenson
Date:
Subject: Converting from 7.4.19 To 8.3.1 & want to use autovacuum
Next
From: Darren Reed
Date:
Subject: postgres doesn't detect other end of the unix socket is gone...