Problem with postgres log file

From: "Natalya S(dot) Makushina" <mak(at)rtsoft(dot)msk(dot)ru>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Problem with postgres log file
Date: 1999-08-27 05:33:54
Message-ID: 01BEF06F.47EBBBA0@makushina.rtsoft.msk.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rtsoft(dot)msk(dot)ru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jens Felber 1999-08-27 06:51:07 Re: [GENERAL] Problem with postgres log file
Previous Message Bruce Momjian 1999-08-27 05:10:47 Re: [GENERAL] postgresql sources compiling