From: | "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | "Joey K(dot)" <pguser(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Switch off PITR |
Date: | 2008-12-04 01:20:10 |
Message-ID: | 3f0b79eb0812031720l7d54defbta565af955ad5e7d1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Dec 4, 2008 at 3:00 AM, Joey K. <pguser(at)gmail(dot)com> 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 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.
Unfortunately there is delay in the archiver actually reloading the
configuration
change. If there are 10 .ready files in pg_xlog/archive_status, you might have
to wait for the reloading until the archiver finish archiving 10 WAL files.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-12-04 04:49:00 | Re: Limit on number of databases in a Cluster ? |
Previous Message | Alvaro Herrera | 2008-12-04 00:24:23 | Re: How to echo statements in sourced file? |