Re: Running psql commands from a remote location & pg_hba.conf? - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: Running psql commands from a remote location & pg_hba.conf?
Date
Msg-id CAKoxK+77ZAmn83FNv5=aO-JPVVHjJwihNDw-JGYiPn9mORkV0g@mail.gmail.com
Whole thread Raw
In response to Running psql commands from a remote location & pg_hba.conf?  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Responses Re: Running psql commands from a remote location & pg_hba.conf?
List pgsql-novice
On Mon, Aug 5, 2013 at 3:45 PM, Birchall, Austen
<austen.birchall@metoffice.gov.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


pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Running psql commands from a remote location & pg_hba.conf?
Next
From: "Birchall, Austen"
Date:
Subject: Re: Running psql commands from a remote location & pg_hba.conf?