On Tue, Apr 29, 2014 at 5:44 PM, basti <basti@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
