RightScale “Restore a Database” is missing a step

Especially if you are interested in restoring a database server from a primary backup:

The instructions for “Restore a Database from a Primary Backup” in this runbook for PostgreSQL  –  Database Manager for PostgreSQL 9.1 (v13.5 LTS) – Runbook  –  resulted in continual failure no matter what I tried.

After coming across this post  –  How can I manually reattach and mount my Rightscale created database EBS volumes?  –  it occurred to me to try and Detach the automatically mounted 2 volumes BEFORE running “db::do_primary_restore_and_become_master”.

This proved successful, with all data restored correctly.

I cross-checked the MySQL runbooks and they had the same problem.

Leave a Reply

Your email address will not be published. Required fields are marked *