Re: query/transaction history/logs
От | David BOURIAUD |
---|---|
Тема | Re: query/transaction history/logs |
Дата | |
Msg-id | 200207101107.47159.david.bouriaud@ac-rouen.fr обсуждение исходный текст |
Ответ на | query/transaction history/logs (q <quadratini@sni.ph>) |
Список | 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
В списке pgsql-sql по дате отправления: