WAL Replication + PITR

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general