Problem with postgres log file
| От | Natalya S. Makushina |
|---|---|
| Тема | Problem with postgres log file |
| Дата | |
| Msg-id | 01BEF06F.47EBBBA0@makushina.rtsoft.msk.ru обсуждение |
| Ответы |
Re: [GENERAL] Problem with postgres log file
|
| Список | pgsql-general |
Hello all!
How can i make line in log file like this?
#timestamp #pid #message
980127.17:52:14.173 [29271] StartTransactionCommand
I have read in documentation about file pg_options.
But I have got only these lines in the log file:
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SELECT "istorid","manager","manager_id" FROM "istor" WHERE "istorid" = 'History_100000001110' OR "istorid" =
'His
tory_100000001113' OR "istorid" = 'History_100000001113' OR "istorid" = 'History_100000001113' OR "istorid" =
'History_1
00000001113' OR "istorid" = 'History_100000001113' OR "istorid" = 'History_100000001113' OR "istorid" =
'History_1000000
01113' OR "istorid" = 'History_100000001113' OR "istorid" = 'History_100000001113'
ProcessQuery
CommitTransactionCommand
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
There are no any timestamp or any pid here.
What is a problem or my error?
Postgres 6.4.2 on Red Hat Linux.
Thank's
Natalya Makushina.
mak@rtsoft.msk.ru
В списке pgsql-general по дате отправления: