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