> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> com]On Behalf Of Jan Alonzo
> Sent: Wednesday, August 20, 2003 10:59 AM
> To: Philippine Linux Users Group Mailing List
> Subject: RE: [plug] PL/pgSQL
> > being "tail -f"-ed)
>
> Make it log queries in /var/log/messages or syslog. :)
>
> Cheers,
:winces: How do you implement it?
i'd hate to execute
psql <db> -c "select * from pg_stat_activity;" -o -
everytime i detect a "**StartTransaction** " in the postgres log file. It
would clog the system and would be too slow
(The transaction would be finished before the "select * from
pg_stat_activity" command is executed
I'm looking for a more efficient way. Anyone?
Hmm, I'm currently running the logs at debug level1, what does log level
debugl5 look like?
ramil
--
Philippine Linux Users' Group (PLUG) Mailing List
[EMAIL PROTECTED] (#PLUG @ irc.free.net.ph)
Official Website: http://plug.linux.org.ph
Searchable Archives: http://marc.free.net.ph
.
To leave, go to http://lists.q-linux.com/mailman/listinfo/plug
.
Are you a Linux newbie? To join the newbie list, go to
http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
