#log_destination = 'stderr'
#logging_collector = off It was when it was restarted that this didn't start logging. To restart is an option, but one I'd like to avoid.
It's 9.0 on debian squeeze.
init.d/postgres start
It was writing before. Just stopped after the last restart or rather reload of the config file. Also when I did an LSOF of the file, nothing was locking it ... ie usually postgres would be the one, but not in this case.
On Thu, Jan 24, 2013 at 12:39 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
What do the following show?:On 01/24/2013 09:29 AM, Anson Abraham wrote:
my postgresql-9.0-main.log log file is 0 bytes. Postgres user has perms
to write to it. And and postgresql.conf file shows to log, but it's
not. Not sure why.
I have the defaults set in except for these changes:
log_connections = on
log_disconnections = on
log_duration = off
log_line_prefix = '%t %p %h %d '
log_lock_waits = on
log_statement = 'none'
any ideas? I used to write log entries, but now, not so much.
log_destination =
logging_collector
Have you restarted the server since making the changes?
How was Postgres installed and what platform/distrubution?
How is Postgres started?
Thanks.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
