Re: PostGreSQL remote access

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: David Rickard <David(dot)Rickard(at)GTScompanies(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, Judith Strawser <judiths(at)gtsgraphics(dot)com>
Subject: Re: PostGreSQL remote access
Date: 2003-06-24 17:01:09
Message-ID: 20030624170109.GA14225@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Jun 24, 2003 at 09:59:02 -0700,
David Rickard <David(dot)Rickard(at)GTScompanies(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-06-24 17:57:23 PG_FUNCTION_ARGS: typeof arg ?
Previous Message David Rickard 2003-06-24 16:59:02 Re: PostGreSQL remote access