Re: PostGreSQL remote access - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: PostGreSQL remote access
Date
Msg-id 20030624170109.GA14225@wolff.to
Whole thread Raw
In response to Re: PostGreSQL remote access  (David Rickard <David.Rickard@GTScompanies.com>)
List pgsql-novice
On Tue, Jun 24, 2003 at 09:59:02 -0700,
  David Rickard <David.Rickard@GTScompanies.com> wrote:
> Further information:
> These are the host lines from our pg_hba.conf file:
>
> host    all         all          127.0.0.1           255.255.255.255   trust
> host    all         all          0.0.0.0               0.0.0.0
>    trust
> host    testdb   postgres 208.179.178.94  255.255.255.0        trust

Can you try using:
host    testdb   postgres 208.179.178.0  255.255.255.0        trust

I don't know for sure, but it may be that the mask is only applied to
the connecting IP, and not the one in the config file.

If you really just want that one IP address (rather than allowing access
to all of 208.179.178.0/24), then you should use a mask of 255.255.255.255.

pgsql-novice by date:

Previous
From: David Rickard
Date:
Subject: Re: PostGreSQL remote access
Next
From: Nabil Sayegh
Date:
Subject: PG_FUNCTION_ARGS: typeof arg ?