Unanswered: Creating DEV DB through streaming from Mirror Slave
New(ish) to the Postgresql world.
We have a master & slave setup for our production environment. I would like to be able to update our DEV server by streaming from the slave.
If I am thinking about this correctly, I can remove the data directory on the DEV server, set the conf file to archive. Then run pg_basebackup to get the initial load using the mirror slave as the source. Then swap my conf file back to the original and create a recovery file to start the DEV system with.
Can this be done or am I missing a step? Thanks for your help.