Re: [GENERAL] Switch off PITR

2008-12-04 Thread Robert Treat
On Wednesday 03 December 2008 14:22:28 Joshua D. Drake wrote: On Wed, 2008-12-03 at 13:16 -0500, Bill Moran wrote: In response to Joey K. [EMAIL PROTECTED]: How do I turn off PITR in the mean time? I commented archive_command and issued a pg_ctl reload and postgres is *still* archiving

[GENERAL] Switch off PITR

2008-12-03 Thread Joey K.
Hello all, I have been doing PITR backups for a while to a backup server via NFS. It's working great. I have to shutdown the backup server for hardware/OS upgrade. I expect this upgrade will last a week. How do I turn off PITR in the mean time? I commented archive_command and issued a pg_ctl

Re: [GENERAL] Switch off PITR

2008-12-03 Thread Bill Moran
In response to Joey K. [EMAIL PROTECTED]: How do I turn off PITR in the mean time? I commented archive_command and issued a pg_ctl reload and postgres is *still* archiving logs to the backup server. Pretty sure you're going to need a full restart -- reload won't cause that parameter to be

Re: [GENERAL] Switch off PITR

2008-12-03 Thread Joshua D. Drake
On Wed, 2008-12-03 at 13:16 -0500, Bill Moran wrote: In response to Joey K. [EMAIL PROTECTED]: How do I turn off PITR in the mean time? I commented archive_command and issued a pg_ctl reload and postgres is *still* archiving logs to the backup server. Pretty sure you're going to need

Re: [GENERAL] Switch off PITR

2008-12-03 Thread Fujii Masao
On Thu, Dec 4, 2008 at 3:00 AM, Joey K. [EMAIL PROTECTED] wrote: Hello all, I have been doing PITR backups for a while to a backup server via NFS. It's working great. I have to shutdown the backup server for hardware/OS upgrade. I expect this upgrade will last a week. How do I turn off