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 по дате отправления:

Предыдущее
От: q
Дата:
Сообщение: query/transaction history/logs
Следующее
От: "Ian Cass"
Дата:
Сообщение: Help with function optimisation