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@archonet.com]
Sent: Tue 11/29/2005 5:40 PM
To: surabhi.ahuja
Cc: pgsql-general@postgresql.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