From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to enable Logon Trigger in postgres? |
Date: | 2018-08-20 11:00:10 |
Message-ID: | CAGDYbUPpniSJ5F5wKSF+awQHSoUWP+hahdu88Ju3Weehprs=Dw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
You can enable login connection related parameters in a postgresql.conf
file to get the user login/logout time.
Due to enabling the logging parameters the log file size will increase.
On Mon, Aug 20, 2018 at 3:11 PM, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
wrote:
> Hi all,
>
> I wanted to know whether we can store logon(user login/logout) information
> for a database. In specific I want to know at what time which user had
> logged in and what he performed on the database and the time which he
> logged
> off?
>
> Is it possible to get this level of information in Postgres?
>
> Will be very happy if we can get this piece of information from the
> postgres(inbuilt/any tool). Looking forward to hearing from you!
>
> Regards,
> Pavan
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.
> html
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | pavan95 | 2018-08-20 11:06:20 | Re: How to enable Logon Trigger in postgres? |
Previous Message | Achilleas Mantzios | 2018-08-20 10:58:07 | Re: logical Replication |