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

From Zwettler Markus (OIZ)
Subject periodic refresh of pre-production stages
Date
Msg-id b4fb8913aef84a15b3f52aa6f0a6bc92@zuerich.ch
Whole thread Raw
Responses Re: periodic refresh of pre-production stages  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

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

 

 

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Fwd: sensible configuration of max_connections
Next
From: Kasun Kulathunga
Date:
Subject: Re: POLL: Adding transaction status to default psql prompt