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
[EMAIL PROTECTED] * andrew_perr
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
___
Hi everyone, I'm new at postgres and I am trying to run a shell script
to create a db for a java app. All I can seem to get are one of the
three following errors no matter what I try.
User not in pg_shadow (when I just created the user as super and with
the ability to create databases).
Serial
hi,
noticed your problem ... have you tried from root as a test...
#su -l postgres
you should get a prompt of below if your postgres 'pgsql' is
on the job today...
postgres@$HOSTNAME pgsql$
that indicates that postgres is running and ready for a interface...
