Thread: 8.4 replication questions

Forgive me if this is clear to everyone else, but regarding the new
replication options in 8.4:
Will existing PITR backup techniques work without modification?
Will existing techniques for warm standby with a custom script (not
using pg_standby) work without modification?
We will want to continue with an asynchronous approach involving WAL
file shipping; however it might be a usable enhancement for us if
there was a way to append to a WAL file copy as the production WAL
file filled, especially if there's a way to fire a script when it is
complete.  Will that be possible?
In particular, we need to copy WAL files from the database server to
two different locations, at least one of which can't be running
PostgreSQL software.
-Kevin

Hi,

On Tue, Dec 16, 2008 at 7:10 AM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Forgive me if this is clear to everyone else, but regarding the new
> replication options in 8.4:
>
> Will existing PITR backup techniques work without modification?

Yes.

>
> Will existing techniques for warm standby with a custom script (not
> using pg_standby) work without modification?

Yes.

If you don't set the option of replication, PITR and basic crash recovery
would work as heretofore. At least, I'm going to implement Synch Rep
such :)

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center