Thread: Problem with postgres log file

Problem with postgres log file

From

"Natalya S. Makushina"

Date:

27 August 1999, 01:36:55

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

Re: [GENERAL] Problem with postgres log file

From

Jens Felber

Date:

27 August 1999, 02:55:56

At 09:33 27.08.99 +0400, Natalya S. Makushina wrote:
>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


Hi ,

how do you start Postgres

I start it with the following options and can see more in my logfile:

--> postmaster -i -s -o "-F -o /var/log/posrgres.log" $

the parameters in "" are opteion of the backend.
-o /../../ tells the backend the path to the logfile
Note: the logfile must be writable for Postgres dba user!!!

by Jens