Re: Login/logout

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.

> On 6/18/05, Michael Fuhr <mike@fuhr.org> wrote:
> > On Sat, Jun 18, 2005 at 11:11:31AM -0500, Juan Pablo Espino wrote:
> > >
> > > I want to register in an audit table the date and time of the
> > > login/logout of a database user. I have been looking for some function
> > > in the code but I didn't find something like that.
> > 
> > Are you interested in logging to a table specifically, or are you
> > just trying to get the login/logout info?  If the latter, then you
> > can use log_connections and log_disconnections (the second of which
> > is available in 8.0 and later).
> > 
> > http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT
> > 
> > --
> > Michael Fuhr
> > http://www.fuhr.org/~mfuhr/
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 
--