Hi Luca
And thanks once again for your assistance. Yes a role would work although I would have to remember to add any new users
toit as they are created.
I guess one of the questions I am asking is:
Is there a way to run psql scripts in a database fired off from a remote location without going down the trust
authentication'route' in pg_hba.conf?
Austen
On Mon, Aug 5, 2013 at 3:45 PM, Birchall, Austen 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
singleentry related to such role?
See http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html -> user
Luca
