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
Дата
Msg-id CANynezOK7dVS-Q8UjZQMRBSwuK_bbb63OJ6zMg9PTMD+FFUTtw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: suggestion the process to sync the data from PROD DB to Staging environment  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: suggestion the process to sync the data from PROD DB to Staging environment
Re: suggestion the process to sync the data from PROD DB to Staging environment
Список pgsql-admin
Дерево обсуждения
Thanks, David,

Please find the environment details.

Environment:
PROD:
OS: RHEL 7.1
Postgres: 9.5.15

Staging:
OS: RHEL 7.1
Postgres: 9.5.15

Thanks&Regards,
PostgAnn.

On Wed, May 27, 2020 at 9:51 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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 по дате отправления:

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