Re: periodic refresh of pre-production stages - Mailing list pgsql-general

From Adrian Klaver
Subject Re: periodic refresh of pre-production stages
Date
Msg-id e48d9b97-b657-f1b5-e756-37f809089353@aklaver.com
Whole thread Raw
In response to periodic refresh of pre-production stages  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
List pgsql-general
On 2/7/20 8:48 AM, Zwettler Markus (OIZ) wrote:
> hi,
> 
> we have to refresh our DEV and UAT stages periodically with PRD data.
> 
> we will to do this by cloning the whole cluster using pg_basebackup or 
> restoring our filesystem backup (data + archive).
> 
> I saw that the database system identifier stays the same. is there any 
> complication on this?

Not that I am aware of. To learn more about it's purpose:

https://www.postgresql.org/docs/12/protocol-replication.html

> 
> thx
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Justin
Date:
Subject: Re: Fwd: sensible configuration of max_connections
Next
From: Sam Gendler
Date:
Subject: Re: Fwd: sensible configuration of max_connections