This post is inspired by a 2013 post regarding the same topic. I also needed a little more information. So our configuration is:
1. Two datacenters. Don't need hot-hot configuration, this is purely for if the primary site goes down.
2. We already backup our DB and Attachments every night to the DR site.
3. Failover is understood to be a manual process (script-assisted is desirable!)
4. We do have the option of replicating our PostgreSQL DB up to the DR site (async, read-only at DR), but it's not required, especially if it adds significant complexity.
Questions:
1. How do I setup the "DR" installation? I've got the installer running and trying to sort out of I just setup the "Demo" DB and then reconfigure after that? It's a chicken/egg thing.
2. Can anyone describe the steps that I'd need to perform to get the "backed up" stuff running in "production" at our DR site?
Thanks for reading!