Re: PITR for one database in cluster

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Vijay Ganji <vijay(dot)db2dba(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: PITR for one database in cluster
Date: 2020-02-10 20:28:10
Message-ID: 8f78df8238b7d367b8fb8c869b2f9d3fc2d01813.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message barry kimelman 2020-02-17 16:11:10 Can't delete postgresql table record using Perl
Previous Message Vijay Ganji 2020-02-10 19:00:53 PITR for one database in cluster