Re: Login/logout - Utility Database

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, Magnus Hagander <mha(at)sollentuna(dot)net>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Subject: Re: Login/logout - Utility Database
Date: 2005-06-18 23:26:47
Message-ID: 42B4ADB7.1040002@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

This is the kind of functionality I'd expect to go to the pg_system (or
however it is named) database if added in pgsql 9.x or so. Would you
like to have auditing stuff mixed up with user data (e.g. in terms of
backup)?

Regards,
Andreas

In response to

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-06-19 00:32:10 Re: buildfarm notifications
Previous Message Andreas Pflug 2005-06-18 23:23:04 Re: [PATCHES] default database creation with initdb