From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres log file |
Date: | 2005-12-01 09:37:50 |
Message-ID: | 438EC46E.4070403@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
surabhi.ahuja wrote:
> 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 ..
Oh - I thought the message was being echoed to STDERR. You'll still want
to setup a directory to store the log-files in, otherwise they can't be
rotated. Create /var/log/postgresql and make sure it's owned by the
"postgres" user (or whoever the db runs as) and is only writable by that
user.
Anyway, as far as I can see, this message is only produced when there is
no database process for the logger to read from (see file
backend/postmaster/syslogger.c about line 360).
This implies the system itself is shutting down. Are you still having
problems with your custom startup script?
Two things I'd consider:
1. Install from a package (8.1 should be available for most platforms now).
2. Use the syslog daemon to record your logs.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | surabhi.ahuja | 2005-12-01 09:50:52 | Re: postgres log file |
Previous Message | Terry Lee Tucker | 2005-12-01 09:21:59 | Re: date/time function |