From: | Greg Swisher <gregs(at)oakhillcorporation(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_standby logging issues |
Date: | 2010-12-08 00:19:02 |
Message-ID: | C9240EF6.2F59%gregs@oakhillcorporation.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am using pg_standby in the recovery_command of recover.conf, and with the
d option I am getting an entry every few seconds when it checks for the
trigger and WAL files.
If I leave out the d option, I seem to get nothing. What messages should I
see without the d option? ( I want to try to keep the logging down a
bit...)
It also seems that I am unable to rotate the log files while pg_standby is
running. If I rename the log file and immediately create it¹s replacement,
all the logging stops. I have to restart pg_ctl to get the pg_standby log
moving again.
What workarounds would you suggest for this case? Would you anticipate any
problem with scripting the logfile rotation and restart of pg_ctl on a
regular basis? Anything more elegant out there?
Thanks!!
Greg
From | Date | Subject | |
---|---|---|---|
Next Message | Brady Mathis | 2010-12-08 00:19:06 | Using PG with Windows EFS or TrueCrypt for encryption |
Previous Message | Tom Lane | 2010-12-07 22:36:59 | Re: PG84 and SSL on CentOS-5.5 was PG84 and SELinux |