Re: Login/logout - Mailing list pgsql-hackers

From Juan Pablo Espino
Subject Re: Login/logout
Date
Msg-id 3e7daec1050618123368a7a4eb@mail.gmail.com
Whole thread Raw
In response to Re: Login/logout  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
Hi, thanks for the response.

On 6/18/05, Rod Taylor <pg@rbt.ca> wrote:
> On Sat, 2005-06-18 at 11:46 -0500, Juan Pablo Espino wrote:
> > Thanks for the quick response.  Yes I want to retrieve the
> > login/logout info, but I want to insert this info in a table that I
> > use as an audit table. Regards
>
> I suggest putting together a short script to scan the logs periodically
> and add the new entries to your table.
>

It sounds to me good in order to resolve my problem.  Nevertheless I
think that it would be very useful to have a function that does
something like "select login()" and gives back to the date and time of
login, or that we can retrieve that info from the system catalogs.
Regards,


Juan P. Espino


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Checkpointing problem with new buffer mgr.
Next
From: Greg Stark
Date:
Subject: Re: Utility database (Was: RE: Autovacuum in the backend)