Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ? - Mailing list pgsql-general

From Ron
Subject Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
Date
Msg-id 4db7a53f-ba36-c5e9-88af-9e427559516a@gmail.com
Whole thread Raw
In response to Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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.



pgsql-general by date:

Previous
From: Erik Aronesty
Date:
Subject: Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?
Next
From: Ron
Date:
Subject: Re: Fast, stable, portable hash function producing 4-byte or 8-bytevalues?