Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1063208

Summary: RHEVM fails to restore with the error 'FATAL: Database is not empty'
Product: Red Hat Enterprise Virtualization Manager Reporter: Ramesh N <rnachimu>
Component: DocumentationAssignee: Andrew Dahms <adahms>
Status: CLOSED CURRENTRELEASE QA Contact: Julie <juwu>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.3.0CC: acathrow, gklein, juwu, yeylon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Build Name: 13109, Administration Guide-3.3-1 Build Date: 07-02-2014 11:55:52 Topic ID: 28277-581923 [Latest]
Last Closed: 2014-07-31 04:55:26 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Ramesh N 2014-02-10 09:46:07 UTC 
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:
Comment 1 Andrew Dahms 2014-02-13 04:43:20 UTC 
Fixed in 28227.
Comment 2 Andrew Dahms 2014-02-17 03:14:31 UTC 
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.
Comment 3 Julie 2014-07-31 04:55:26 UTC 
Verified in the current release.