Re: Running psql commands from a remote location & pg_hba.conf?

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Running psql commands from a remote location & pg_hba.conf?
Date: 2013-08-05 15:30:44
Message-ID: CAKoxK+77ZAmn83FNv5=aO-JPVVHjJwihNDw-JGYiPn9mORkV0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Aug 5, 2013 at 3:45 PM, Birchall, Austen
<austen(dot)birchall(at)metoffice(dot)gov(dot)uk> wrote:
> Am I right to presume that I have to change pg_hba.conf to
>
> host db1 monitor 123.0.0.1/32 trust
> host db1 user1 123.0.0.1/32 ident
> host db1 user2 123.0.0.1/32 ident
>
> then continue this format with individual entries for all the users in db1?

Not sure this is what you are looking for, but why not defining a role
that contains all the users and then add a single entry related to
such role?
See http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html -> user

Luca

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Birchall, Austen 2013-08-05 15:46:03 Re: Running psql commands from a remote location & pg_hba.conf?
Previous Message Birchall, Austen 2013-08-05 13:45:44 Running psql commands from a remote location & pg_hba.conf?