Problem with postgres log file
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
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] StartTransactionCommandI 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
Hello!
I start postmaster with this options
/usr/local/pgsql/bin/postmaster -i -D/usr/local/pgsql >>/usr/local/pgsql/postgres.log 2>&1 &
I tried to start postmaster
postmaster -o "-F -o /var/log/postgres.log"
Unfortunaly I haven't seen any differents between log files.
From : Jens Felber [SMTP:jfe@gek-online.de]
Date : 27 О©╫О©╫О©╫О©╫О©╫О©╫О©╫ 1999 О©╫. 10:51
To : Natalya S. Makushina; pgsql-general@postgreSQL.org
Subject : Re: [GENERAL] Problem with postgres log file
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] StartTransactionCommandI 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
Import Notes
Resolved by subject fallback