Thread: pg_log filling up with false logs
Postgres 8.4 on OEL 6.3 Linux is having issues that the DBs are not available at intervals. I bumped up the debug level to 4 and all I see in the /var/lib/pgsql/data/pg_log are logs that say..
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
FATAL: the database system is shutting down
Although the DBs are not shutting down. Also pg_ctl command to stop, restart does not seem to have any effect.
Does anyone have any ideas?
Shree
On Mon, Nov 11, 2013 at 6:32 PM, Shree <shreerajkarulkar@yahoo.com> wrote:
Also pg_ctl command to stop, restart does not seem to have any effect.Does anyone have any ideas?
I can't speak to what issued the shutdown command, but have you tried "pg_ctl restart -m fast" to expedite the restart (if that is indeed what you are after) ?