Bug 1063208 - RHEVM fails to restore with the error 'FATAL: Database is not empty'
Summary: RHEVM fails to restore with the error 'FATAL: Database is not empty'
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: Documentation
Version: 3.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Andrew Dahms
QA Contact: Julie
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-02-10 09:46 UTC by Ramesh N
Modified: 2014-07-31 04:55 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
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
oVirt Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

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.


Note You need to log in before you can comment on or make changes to this bug.