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

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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.
>
>