Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres replication without pg_basebackup? postgres 13.3 - Mailing list pgsql-general

From Laurenz Albe
Subject Re: postgres replication without pg_basebackup? postgres 13.3
Date
Msg-id 682616b88f9e6bd7a745d74580833254879ce550.camel@cybertec.at
Whole thread Raw
In response to postgres replication without pg_basebackup? postgres 13.3  (Pilar de Teodoro <pilar.deteodoro@gmail.com>)
Responses Re: postgres replication without pg_basebackup? postgres 13.3  (Pilar de Teodoro <pilar.deteodoro@gmail.com>)
List pgsql-general
Tree view 
On Mon, 2022-11-07 at 11:02 +0100, Pilar de Teodoro wrote:
> We have a very large database of 37TB and we had to promote our standby to primary due to
> some disk failures. Now the issues are solved, we would like to make standby  the old primary
> from a copy of the new primary which is already in place.  Is it possible without using pg_basebackup?

That's exactly what "pg_rewind" is for.  It is a fast version of "pg_basebackup" for exactly
that case.

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

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault
Next
From: Mladen Gogala
Date:
Subject: Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault