From: | Anson Abraham <anson(dot)abraham(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | postgresql log file not getting update |
Date: | 2013-02-28 16:19:08 |
Message-ID: | CAC9g-HeNVULu-U_4Ctf53PqkLdZq8R-3asF8uU9aUgT1sBCQ8Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Thanks in advance.
-Anson
From | Date | Subject | |
---|---|---|---|
Next Message | Anson Abraham | 2013-02-28 17:01:08 | Re: postgresql log file not getting update |
Previous Message | Ronnie and Sandy | 2013-02-28 15:05:46 | Re: how long to wait on 9.2 bitrock installer? |