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