Re: [Engine-devel] Backing up the DB
----- Original Message -----
From: "Douglas Landgraf" <dougsland(a)redhat.com>
To: "Adam Litke" <agl(a)us.ibm.com>
Cc: engine-devel(a)ovirt.org, "Douglas Landgraf" <dlandgra(a)redhat.com>
Sent: Monday, April 2, 2012 6:19:23 PM
Subject: Re: [Engine-devel] Backing up the DB
Hi,
On 04/02/2012 09:20 AM, Adam Litke wrote:
Hi all,
I have a working development environment for ovirt-engine and I want
to verify
someone else's gerrit change. Is there a documented proceedure for
backing up
the engine db so that, after checking out the new code and updating
the db
schema, I can revert to my old code and DB (schema and data).
You can use pg_dump for backup and psql for restore :
backup:
pg_dump -C -E UTF8 --column-inserts --disable-dollar-quoting --disable-triggers -U
postgres --format=p -f <backupfile> <dbname>
restore:
psql -U postgres -f <backupfile> template1
Thanks! Usually I use this tool to backup/restore db:
https://github.com/dougsland/misc-rhev/blob/master/rhevm-db-tool.py
However, since it's "rhevm" db tool.. need manually change the db
name to "engine",
I will rename it to engine-db-tool and update the code to 'engine'
soon..
--
Cheers
Douglas
_______________________________________________
Engine-devel mailing list
Engine-devel(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-devel