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] 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