Postgres Pro
Downloads
Home   >   mailing lists

Re: How to enable Logon Trigger in postgres? - Mailing list pgsql-admin

From Greg Spiegelberg
Subject Re: How to enable Logon Trigger in postgres?
Date
Msg-id CAEtnbpXhk6N8_UozWpibwtfMuYHt7agvmexMBLYt7vUAXgkZ+g@mail.gmail.com
Whole thread Raw
In response to Re: How to enable Logon Trigger in postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: How to enable Logon Trigger in postgres?  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view
Use pgbouncer and leverage auth_query option. Can capture logins to table,  trigger if necessary.  No logout / disconnect equivalent tho. 
-Greg 

On Mon, Aug 20, 2018, 5:08 AM pavan95 <pavan.postgresdba@gmail.com> wrote:
Hi Shreyansh,

Is there any alternate approach without logging into log file??


Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: Evan Bauer
Date:
Subject: Re: Setting up SSL for postgre
Next
From: "Mark Williams"
Date:
Subject: RE: Setting up SSL for postgre