Thread: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
From
"Abraham, Danny"
Date:
I assume that this magic does not exist.
Am I right ?
Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
From
"Abraham, Danny"
Date:
I assume that this magic does not exist. Am I right ? Thanks Danny
Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
From
Adrian Klaver
Date:
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. > Thanks > Danny > > > > -- Adrian Klaver adrian.klaver@aklaver.com
Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
From
Ron
Date:
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.
Re: Is there any tool that provides Physical Backup plus PITR for asingle database ( Not the whole PG instance ) ?
From
Grigory Smolkin
Date:
Hello!
pg_probackup can do that:
https://postgrespro.github.io/pg_probackup/#pbk-partial-restore
On 12/15/19 5:32 PM, Abraham, Danny wrote:
I assume that this magic does not exist.
Am I right ?
-- Grigory Smolkin Postgres Professional: http://www.postgrespro.com The Russian Postgres Company