Re: main.log file not being updated

#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(dot)klaver(at)gmail(dot)com>wrote:

> 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.
>>
>
> What do the following show?:
>
> 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(dot)klaver(at)gmail(dot)com
>