Re: PITR compatible backup with exclusion

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Martin Bruset Solberg <martin(dot)bruset(dot)solberg(at)gmail(dot)com>
Cc: PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PITR compatible backup with exclusion
Date: 2015-01-26 20:10:41
Message-ID: CAFnxYwh8zQhGqs0h9u9kxWB5ucKPJWF5gc0k0Gnf7ey5W4LUXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jan 26, 2015 at 4:17 AM, Martin Bruset Solberg <
martin(dot)bruset(dot)solberg(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Khangelani Gama 2015-01-27 04:25:52 Postgres 9.2 - XML string functions ?
Previous Message Luc DALLEMANE 2015-01-26 16:38:00 LDAP authentication problem.