From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | basti <basti(at)unix-solution(dot)de> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: WAL Replication + PITR |
Date: | 2014-05-01 04:00:34 |
Message-ID: | CAB7nPqSTsq0YdBXo1agmC5fOhBC0VDi0v03U+FTd1DfXYOzviA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 29, 2014 at 5:44 PM, basti <basti(at)unix-solution(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-05-01 04:02:14 | Re: importing a messy text file |
Previous Message | David Noel | 2014-05-01 02:20:50 | Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows) |