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

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