| From: | Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com> |
|---|---|
| To: | David Gauthier <davegauthierpg(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: passing linux user to PG server as a variable ? |
| Date: | 2020-08-18 01:02:48 |
| Message-ID: | eeb0a551-98b3-cf49-5e80-46fa95c9c547@2ndquadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2020/08/18 4:52, David Gauthier wrote:
> Thanks in advance for any replies/ideas !
You could hackily repurpose the "application_name" connection parameter:
$ whoami
ibarwick
$ psql -d "host=localhost dbname=postgres user=postgres application_name=$USER"
psql (14devel)
Type "help" for help.
postgres=# SELECT application_name FROM pg_stat_activity WHERE pid=pg_backend_pid();
application_name
------------------
ibarwick
(1 row)
Disclaimer: I have not applied any thought to any possible pitfalls and side
effects resulting from this approach.
Regards
Ian Barwick
--
Ian Barwick https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-08-18 01:03:11 | Re: passing linux user to PG server as a variable ? |
| Previous Message | David Gauthier | 2020-08-18 00:46:06 | Re: passing linux user to PG server as a variable ? |