Postgres Pro
Downloads
Home   >   mailing lists

Thread: WAL Replication + PITR

WAL Replication + PITR

From
basti
Date:
Hello,

is it possible to have WAL Replication and Point-in-Time Recovery like
follows:

DB-Master -- (WAL to Slave) --> DB-Slave
    |
    |-------> (PITR to an other Server)

Thanks for any help!

Basti

p.s. is there a tutorial somewhere how describe the steps todo when the
master is crashed?

Re: WAL Replication + PITR

From
Michael Paquier
Date:
On Tue, Apr 29, 2014 at 5:44 PM, basti <basti@unix-solution.de> wrote:
> is it possible to have WAL Replication and Point-in-Time Recovery like
> follows:
>
> DB-Master -- (WAL to Slave) --> DB-Slave
>     |
>     |-------> (PITR to an other Server)
Yes. Be sure to take periodic base backups of the master and an
archive of WAL files large enough to be able to recover up to the PITR
point you are looking for.

> p.s. is there a tutorial somewhere how describe the steps todo when the
> master is crashed?
There is some documentation describing failover procedure:
http://www.postgresql.org/docs/devel/static/warm-standby-failover.html

If you are looking for some ways to automate that with some HA
solutions, there is always some information here:
https://wiki.postgresql.org/wiki/High_Availability
Regards,
--
Michael