Re: suggestion the process to sync the data from PROD DB to Staging environment

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: suggestion the process to sync the data from PROD DB to Staging environment
Дата
Msg-id CAKFQuwYHhm8RQ6xaxiek_evMUkC8acmv6rq0KyS=wMPMAdB5sQ@mail.gmail.com
обсуждение исходный текст
Ответ на suggestion the process to sync the data from PROD DB to Staging environment  (postgann2020 s <postgann2020@gmail.com>)
Ответы Re: suggestion the process to sync the data from PROD DB to Staging environment  (postgann2020 s <postgann2020@gmail.com>)
Re: suggestion the process to sync the data from PROD DB to Staging environment  (postgann2020 s <postgann2020@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Wed, May 27, 2020 at 8:56 AM postgann2020 s <postgann2020@gmail.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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: postgann2020 s
Дата:
Сообщение: Re: suggestion the process to sync the data from PROD DB to Staging environment
Следующее
От: postgann2020 s
Дата:
Сообщение: Re: suggestion the process to sync the data from PROD DB to Staging environment