Re: postgresql log file not getting update

how is that different from
/etc/init.d/postgres reload or for that matter select pg_reload_conf() ?

Which I execute both and they don't work either.

On Thu, Feb 28, 2013 at 12:43 PM, Chris <chris(at)eisonline(dot)co(dot)za> wrote:

>
>
> On Feb 28, 2013, at 19:01, Anson Abraham <anson(dot)abraham(at)gmail(dot)com> wrote:
>
> *Note when I change
> log_destination = 'syslog'
>
> it does log to the syslog file.
>
> When I changed to to log_destination = 'stderr' still nothing logged.
>
> commenting out doesn't do much either. I initially thought it would be a
> perms thing, but when I deleted the file and did a reload, postgres created
> the log file. So not sure what is going on exactly.
>
> Again, any help would be appreciated here to figure this out, where I
> don't need to restart the db.
> Thanks
>
> On Thu, Feb 28, 2013 at 11:19 AM, Anson Abraham <anson(dot)abraham(at)gmail(dot)com>wrote:
>
>> My postgresql-9.0-main.log file has suddenly stopped getting updated. I
>> do not know why it stopped all of a sudden. We made a slight modification
>> where changed in the postgresql.conf param:
>> From
>> log_connections = off
>> log_disconnections = off
>>
>> To
>>
>> log_connections = on
>> log_disconnections = on
>>
>> I'm on a debian environment w/ version 9.0.7. It's a single instance w/
>> no cluster on here. It was done w/a simple apt-get install back when, when
>> it was a fresh server (we'll call this db1)
>>
>> I have an identical setup for another server (db4), and when I made the
>> change to the same paramers in conf, it's updating the
>> postgresql-9.0-main.log file. I reverted the connections and discon from
>> on back to off, and did a postgresql reload as well as pg_reload_conf().
>> For both servers. db4 the log file is getting updated db1 nothing. I
>> thought the file was locked or some perms may have changed and I deleted
>> the postgresql-9.0-main.log file. It didn't create a new log file until i
>> did a postgresql reload. It created the new file, but still nothing getting
>> written to it.
>>
>> I know first thing people would say is to restart the instance, but
>> restarting is not an option for me in this case.
>>
>> I've changed
>> ucommented out this param
>> #log_destination = 'stderr'
>>
>> to be stderr, and even syslog and did a reload and nothing.
>>
>>
>> I know i should use log collector, but again, that also requires a
>> restart as well, unless a reload will work?
>>
>> The way I reload is /etc/init.d/postgresql reload
>>
>> The distro for Debian is squeeze. Again, it works on my other server,
>> this server it doesn't. Any one have any ideas, where I don't need to
>> restart the pg instance?
>>
>
> From the bin directory you can do: pg_ctl reload -D (followed by the data
> dierctory)
>
> Thanks in advance.
>> -Anson
>>
>
>