Re: postgres access log file

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@perrin.socsci.unc.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>