Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
On Wed, May 27, 2020 at 8:56 AM postgann2020 s <postgann2020@xxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux