| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: periodic refresh of pre-production stages |
| Date: | 2020-02-07 20:38:49 |
| Message-ID: | e48d9b97-b657-f1b5-e756-37f809089353@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Gendler | 2020-02-07 20:40:34 | Re: Fwd: sensible configuration of max_connections |
| Previous Message | Justin | 2020-02-07 19:14:37 | Re: Fwd: sensible configuration of max_connections |