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

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.