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