| From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
|---|---|
| To: | "pgsql-novice-owner(at)postgresql(dot)org" <pgsql-novice-owner(at)postgresql(dot)org>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Cc: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
| Subject: | Running psql commands from a remote location & pg_hba.conf? |
| Date: | 2013-08-05 13:45:44 |
| Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC07602A@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have a monitor user that does a SSH from a remote location onto a database's host then runs commands of the form:
/usr/bin/psql -c "SELECT COUNT(*) FROM pg_stat_activity; ;" -U monitor -d db1 -q -A -t
The current pg_hba.conf is
# IPv4 local connections:
host all all 123.0.0.1/32 trust
which is far from ideal!
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?
Or is there a 'better' way of running psql commands from a remote location?
Thanks
Austen
Austen Birchall Senior Database Administrator, Met Office
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2013-08-05 15:30:44 | Re: Running psql commands from a remote location & pg_hba.conf? |
| Previous Message | Luca Ferrari | 2013-08-05 13:33:39 | Re: General 'big data' advice.... |