Re: Login/logout

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Juan Pablo Espino <jp(dot)espino(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Login/logout
Date: 2005-06-18 16:29:35
Message-ID: 20050618162935.GA92242@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

  • Login/logout at 2005-06-18 16:11:31 from Juan Pablo Espino

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2005-06-18 16:32:48 Re: Post-mortem: final 2PC patch
Previous Message Tom Lane 2005-06-18 16:13:22 Re: Two-phase commit