Editing vRealize Automation appliance PostgreSQL database by hand

20150912 - 1About a month ago I accidentally deleted a SQL database as part of a migration to a new failover cluster.  The database in question was the IaaS database used by my vRealize Automation installation, and no backup was available.  Mistakes like that in a lab happen from time to time and are okay, as long as you can be the one to fix them. Continue reading