Re: postgres access log file

From: Andrew Perrin <clists(at)perrin(dot)socsci(dot)unc(dot)edu>
To: Nathalie Boulos <nathalieboulos(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postgres access log file
Date: 2003-02-28 15:01:18
Message-ID: Pine.LNX.4.21.0302281000070.32244-100000@perrin.socsci.unc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Use your postgresql.conf file to enable logged connections:

log_connections = on

----------------------------------------------------------------------
Andrew J Perrin - http://www.unc.edu/~aperrin
Assistant Professor of Sociology, U of North Carolina, Chapel Hill
clists(at)perrin(dot)socsci(dot)unc(dot)edu * andrew_perrin (at) unc.edu

On Fri, 28 Feb 2003, Nathalie Boulos wrote:

> Hello all,
>
> I was wondering if there is a log file where are logged connection to a
> postgresql database per user and per date.
>
> Or do i have to specify a table and insert rows in it each time a user logs
> in and out?
>
> Regards
>
> Nathalie
>
>
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sidar Lopez Cruz 2003-02-28 15:05:30 Cross-database references
Previous Message Tom Lane 2003-02-28 14:05:56 Re: ExclusiveLock and Python