From: David BOURIAUD <david.bouriaud@ac-rouen.fr>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: query/transaction history/logs
Date: Wed, 10 Jul 2002 11:08:14 +0200
Message-ID: <200207101107.47159.david.bouriaud@ac-rouen.fr> (raw)
In-Reply-To: <3D2BF180.50101@sni.ph>
References: <3D2BF180.50101@sni.ph>
Le Mercredi 10 Juillet 2002 10:34, q a écrit :
> Is there anyway we can track queries entered?
> Is there a table that stores all the actions that a user entered? (history)
> Is there such a feature?
>
For both of your problems, see the way you can launch the postmaster.
For example, I use to launch it this way :
postmaster -i -d2 &> /var/log/postmaster.log &
Thus, you get all you want in the log file /var/log/postmaster.log
Now, you can get as much infos as you want according to the level of debug you
want (from 1 to 9 as far as I remember, the greater, the more speech you get
from the postmaster).
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have
for windows or gates ?
----------------------------------------------------------
ICQ#102562021
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.bouriaud@ac-rouen.fr
Subject: Re: query/transaction history/logs
In-Reply-To: <200207101107.47159.david.bouriaud@ac-rouen.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox