Red Hat Bugzilla – Bug 1063208
RHEVM fails to restore with the error 'FATAL: Database is not empty'
Last modified: 2014-07-31 00:55:26 EDT
Title: Restoring a Backup to a Fresh Installation Describe the issue: Restoring the RHEVM configurations to a fresh installation is not working as described in the documentation. After following the steps mentioned in RHEVM Admin guide, restore fails with the error 'FATAL: Database is not empty' Suggestions for improvement: I think step 2.5 "CREATE LANGUAGE plpgsql;" is the cause. If I use the following script, it works properly. su - postgres -c "psql -d template1 -c \"create database [DATABASE NAME] owner [OWNER NAME] template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';\"" I think documentation should be fixed to show the exact steps to restore. Additional information:
Fixed in 28227.
Documentation Link ------------------------------ http://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_Enterprise_Virtualization/3.3/html-single/Administration_Guide/index.html#Restoring_a_Backup_to_a_Fresh_Installation What Changed ------------------------------ The following topic was revised as outlined below: Restoring a Backup to a Fresh Installation [ 28277-588708 ] A step instructing the user to run the 'create language' command was removed from Step 2. of the procedure, and the command for creating a new database was matched with that above, now including "template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';" NVR ------------------------------ Red_Hat_Enterprise_Virtualization-Administration_Guide-3.3-en-US-3.3-47 Moving to ON_QA.
Verified in the current release.