Re: automated refresh of dev from prod

2019-02-28 Thread Ben Chobot
On Feb 28, 2019, at 8:04 AM, Stephen Frost wrote: > > Greetings, > > * Julie Nishimura (juliez...@hotmail.com) wrote: >> Hello everybody, I am new to postgresql environment, but trying to get up to >> speed. >> Can you please share your experience on how you can automate refreshment of >> dev

Re: automated refresh of dev from prod

2019-02-28 Thread Stephen Frost
Greetings, * Julie Nishimura (juliez...@hotmail.com) wrote: > Hello everybody, I am new to postgresql environment, but trying to get up to > speed. > Can you please share your experience on how you can automate refreshment of > dev environment on regular basis (desirably weekly), taking for cons

Re: automated refresh of dev from prod

2019-02-27 Thread Ron
On 2/27/19 3:15 PM, Julie Nishimura wrote: Hello everybody, I am new to postgresql environment, but trying to get up to speed. Can you please share your experience on how you can automate refreshment of dev environment on regular basis (desirably weekly), taking for consideration some of prod d

RE: automated refresh of dev from prod

2019-02-27 Thread Scot Kreienkamp
My method is complex and not so good for newbies, but it is incredibly fast and should scale to almost any size database. Mine are not nearly as large though. I use two methods... the normal backup/restore for longer lived development environments, and for shorter lived environments I use postg