Re: [Users] Help on an almost migrated ovirt-engine
On Tue, Jan 22, 2013 at 10:47 AM, Adrian Gibanel wrote:
I've finally come with:
* Origin:
pg_dump -U postgres engine | gzip > engine_db.gz
* Destination:
dropdb -U postgres engine
createdb -U postgres -O engine engine
zcat engine_db.gz | psql -U postgres engine
In another thread regarding all-in-one db problems I had (around
29/12/12), Doron came to tell
Backup to a file called mybackup may be created by:
- cd to /usr/share/ovirt-engine/dbscripts
- ./backup.sh -u postgres -f mybackup
..
Just in case you ever wish to use the backupfile, us this procedure:
- cd to /usr/share/ovirt-engine/dbscripts
- ./restore.sh -u postgres -f mybackup -r
and I successfully tested it on the same host.
I think it could be done the same with the second part on the new host...
Gianluca