PITR for one database in cluster

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

PITR for one database in cluster

Vijay Ganji
Hi,

I am novice to Postgres and I come from db2 world
I want to do Online backup (with archiving) of single database in a cluster and use it for PITR. so i do not have to disturb other databases in the cluster.
I am reading everywhere it is not possible. 
I see the solution is to create database cluster for each database, is this the only solution.

--
Vijay Ganji

Reply | Threaded
Open this post in threaded view
|

Re: PITR for one database in cluster

Laurenz Albe
On Mon, 2020-02-10 at 13:00 -0600, Vijay Ganji wrote:
> I am novice to Postgres and I come from db2 world
> I want to do Online backup (with archiving) of single database in a cluster and use it for PITR. so i do not have to disturb other databases in the cluster.
> I am reading everywhere it is not possible.
> I see the solution is to create database cluster for each database, is this the only solution.

Yes, that is what you will have to do.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com