Re: Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?
Date: 2019-12-16 02:21:44
Message-ID: 4db7a53f-ba36-c5e9-88af-9e427559516a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/15/19 10:32 AM, Adrian Klaver wrote:
> On 12/15/19 6:33 AM, Abraham, Danny wrote:
>> I assume that this magic does not exist.
>> Am I right ?
>
> Take a look at:
>
> https://pgbackrest.org/user-guide.html#restore/option-db-include
>
> and see it that meets your needs. I have never actually done it so I
> cannot add anything to the above.

Restoring one db using pgbackrest zeroes out all the other databases.

(The inability to do PITR of a single database is a serious flaw in
Postgres, but I don't think it can be solved.)

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-12-16 02:23:25 Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?
Previous Message Erik Aronesty 2019-12-15 22:17:15 Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?