| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | postgann2020 s <postgann2020(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: suggestion the process to sync the data from PROD DB to Staging environment |
| Date: | 2020-05-27 16:20:56 |
| Message-ID: | CAKFQuwYHhm8RQ6xaxiek_evMUkC8acmv6rq0KyS=wMPMAdB5sQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Wed, May 27, 2020 at 8:56 AM postgann2020 s <postgann2020(at)gmail(dot)com>
wrote:
> Could someone please suggest the process to *sync the data from PROD DB
> to the Staging environment* with minimal manual intervention or
> automatically.
>
Read up on the general purpose "bash" scripting language, the PostgreSQL
"pg_dump" and "pg_restore" commands, "ssh", and "cron".
"cron" and "bash" provide for the "automatically" requirement.
It is possible to assemble something functional with those tools. Whether
it will actually work in your specific situation is impossible to say since
you provide zero information about your environment.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-27 16:31:13 | Re: suggestion the process to sync the data from PROD DB to Staging environment |
| Previous Message | postgann2020 s | 2020-05-27 16:08:38 | Re: suggestion the process to sync the data from PROD DB to Staging environment |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | postgann2020 s | 2020-05-27 16:31:13 | Re: suggestion the process to sync the data from PROD DB to Staging environment |
| Previous Message | postgann2020 s | 2020-05-27 16:08:38 | Re: suggestion the process to sync the data from PROD DB to Staging environment |