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

If possible you can connect staging server as asynchronous slave node to one of the asynchronous node already in production Sent from my iPhone On 27-May-2020, at 9:26 PM, postgann2020 s wrote:  Hi Team, Thanks for your support. Could someone please suggest the process to sync the data

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

On Wed, May 27, 2020 at 9:31 AM postgann2020 s wrote: > 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 > Ok...not particularly helpful though I do see you are not keeping up with

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, PostgAnn. On Wed, May 27, 2020 at 9:51 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, May 27, 2020 at 8:56 AM postgann2020

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

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

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

Hi Luan, Thanks for your email. How frequently do you sync *hourly/daily/weekly*? > looking for a daily basis. Do you have other processes writing data into Staging env? > Yes, we have old PROD data. Thanks & Regards, Postgann. On Wed, May 27, 2020 at 9:33 PM Luan Huynh wrote: > Hi

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

Hi Postgann, How frequently do you sync *hourly/daily/weekly*? Do you have other processes writing data into Staging env? Regards, On Wed, May 27, 2020 at 5:56 PM postgann2020 s wrote: > Hi Team, > > Thanks for your support. > > Could someone please suggest the process to *sync the data from

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

Hi Team, Thanks for your support. Could someone please suggest the process to *sync the data from PROD DB to the Staging environment* with minimal manual intervention or automatically. Thanks & Regards, Postgann.