Обсуждение: PITR for one database in cluster

Поиск
Список
Период
Сортировка

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

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
disturbother 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