Re: postgres log file

the postgreslog has permission - 777, so anyone is able to write in it.
that s why it is atleast showing

> LOG: logger shutting down

but i want more logging to be done ..how can it be done ..

thanks,
regards
Surabhi

________________________________

From: Richard Huxton [mailto:dev(at)archonet(dot)com]
Sent: Tue 11/29/2005 5:40 PM
To: surabhi.ahuja
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] postgres log file

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********

surabhi.ahuja wrote:
> hi
> I start postmaster by giving the following command
>
> /usr/bin/pg_ctl -w -l postgreslog -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start
>
> however nothing gets looged in postgrelog.
>
> if i see postgreslog it shows me only this:
> LOG: logger shutting down
> LOG: logger shutting down

Does the PostgreSQL server process have permission to write to the file
"postgrelog" in whatever directory this is?

Normally you'd create a directory owned by user postgres (e.g.
/var/log/postgresql) and then log to a file in that directory.

--
Richard Huxton
Archonet Ltd