Re: PITR compatible backup with exclusion - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: PITR compatible backup with exclusion
Date
Msg-id CAFnxYwh8zQhGqs0h9u9kxWB5ucKPJWF5gc0k0Gnf7ey5W4LUXQ@mail.gmail.com
Whole thread Raw
In response to PITR compatible backup with exclusion  (Martin Bruset Solberg <martin.bruset.solberg@gmail.com>)
List pgsql-admin
On Mon, Jan 26, 2015 at 4:17 AM, Martin Bruset Solberg <martin.bruset.solberg@gmail.com> wrote:
So my question is, what are my options when I want to make a PITR compatible backup, and need to exclude a table/schema/tablespace of the database?

You might try using one of the trigger-based, asynchronous replication tools (like Bucardo) to replicate the things you want included in your PITR archive to another host, and then doing WAL archiving of that.

rls

--
:wq

pgsql-admin by date:

Previous
From: Luc DALLEMANE
Date:
Subject: LDAP authentication problem.
Next
From: Khangelani Gama
Date:
Subject: Postgres 9.2 - XML string functions ?