Thread: periodic refresh of pre-production stages
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?
thx
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