pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
query/transaction history/logs 2+ messages / 2 participants [nested] [flat]
* query/transaction history/logs @ 2002-07-10 08:34 q <quadratini@sni.ph> 0 siblings, 1 reply; 2+ messages in thread From: q @ 2002-07-10 08:34 UTC (permalink / raw) To: pgsql-sql 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? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: query/transaction history/logs @ 2002-07-10 09:08 David BOURIAUD <david.bouriaud@ac-rouen.fr> parent: q <quadratini@sni.ph> 0 siblings, 0 replies; 2+ messages in thread From: David BOURIAUD @ 2002-07-10 09:08 UTC (permalink / raw) To: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-10 09:08 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-07-10 08:34 query/transaction history/logs q <quadratini@sni.ph> 2002-07-10 09:08 ` David BOURIAUD <david.bouriaud@ac-rouen.fr>
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