replication phisical + logical

From: Giovanni Biscontini <biscontini(dot)g(at)es2000(dot)it>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: replication phisical + logical
Date: 2022-11-17 12:20:55
Message-ID: CAOM+UfW-i_gVKpG40=KTh6vof9xCmQ=Z-YPHEzE8yFYWT0joOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,
on postgresql 14.5 is possible an architecture where:
master1 is in physical replication with replica1 and replica2 and replica2
is in logical selective replication with master2?
Where on master2 I have db1 who's from logical replication from replica2
and db2 who lives of he's own life and must be enabled to writes.

The goal is to set up a preproduction server (master2) where db1 is feeded
(maybe at regular times) from a production replica.

I considered pgbackrest to derive master2 from a backup of master1 but even
if I restore selectively with
--db-include=db1
option than the whole master2 is restored: so db2 is removed as template0,
template1 and postgres system db are replaced from restore command.

Alternative suggestions' will be appreciated.
Thanks in advance and best regards,
Giovanni
--

*Dott. Giovanni Biscontini*

* [Divisone Software]*

WEB: https://www.es2000.it <http://www.es2000.it/>

____________________________________

Privacy e riservatezza: il presente messaggio, così come i relativi
allegati, contengono dati ed informazioni da considerarsi strettamente
riservate ed è indirizzato esclusivamente al destinatario sopra indicato,
il quale è l'unico autorizzato a trattarlo in osservanza delle norme del
Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo
messaggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a
terzi e di dare notizia al mittente dell’errato invio, distruggendone poi
l'eventuale copia cartacea e la copia in formato elettronico.

Il titolare dei dati potrà esercitare tutti i diritti di cui all'art.7 del
suddetto decreto tra cui quelli di accesso, rettifica, aggiornamento,
opposizione al trattamento e cancellazione

*Please, print this e-mail only if necessary*

Browse pgsql-general by date

  From Date Subject
Next Message shashidhar Reddy 2022-11-17 12:32:04 Re: unrecognized node type: 350
Previous Message Alvaro Herrera 2022-11-17 11:36:51 Re: MERGE output doubt