standby on same server as primary

17 views
Skip to first unread message

jl

unread,
Mar 2, 2022, 5:44:19 PM3/2/22
to repmgr
Hi, is it possible to create a standby on the same server as the primary?  I am trying to create a local standby that can be paused and resumed. If a certain job fails, we would like to pg_dump from the paused standby and pg_restore into the primary.  once complete, would resume replication.  
1. is this even possible?
2. is this a crazy idea or just crazy enough to work?
3. any other suggestions on how to accomplish this?

Thanks
Reply all
Reply to author
Forward
0 new messages