Hi All -- I'm finding myself sometimes in need of hacking at the oVirt DB -- has anyone written a wiki page or something about this?

On Thu, 2013-10-17 at 03:31 -0400, Itamar Heim wrote: > On 10/17/2013 12:02 AM, Jason Brooks wrote: >> >> Hi All -- >> >> I'm finding myself sometimes in need of hacking at the oVirt DB -- has >> anyone written a wiki page or something about this? >> > > I'd be interested to know when you need to hack it, which in most normal > flows shouldn't be needed? I was running oVirt 3.2 w/ POSIXFS storage and Gluster. After 3.3 came out, I exported a few VMs, and imported them into a GlusterFS domain on 3.3. After lots of trouble w/ that domain type, I exported the VMs again, blew away that GlusterFS data center, made a new POSIXFS data center, and went to re-import them. oVirt told me no, there were already disks in the system with these names, and I'd have to clone then instead.

I went ahead and cloned, even though that's a bit less convenient, and required some config file fiddling to deal with the changed MAC address, but it's times like these when I feel a desire to crack the DB, if not to change things, then to figure out what ovirt thinks is happening. Jason > > thanks, > Itamar >

From: "Jason Brooks" <jbrooks(a)redhat.com&gt; To: users(a)ovirt.org Sent: Saturday, November 23, 2013 2:48:23 AM Subject: Re: [Users] hacking at the ovirt db howto? ----- Original Message ----- > From: "Jason Brooks" <jbrooks(a)redhat.com&gt; > To: users(a)ovirt.org > Sent: Wednesday, October 16, 2013 9:02:35 PM > Subject: hacking at the ovirt db howto? > > > Hi All -- > > I'm finding myself sometimes in need of hacking at the oVirt DB -- has > anyone written a wiki page or something about this?

For posterity, what I was missing was: su - postgres psql engine And then hack away. I've had to do a bunch of manual unlocking to allow me to remove VMs following failed snapshot operations. > > > Thanks, Jason > > --- > > Jason Brooks > Red Hat Open Source and Standards > > @jasonbrooks | @redhatopen > http://community.redhat.com > > _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users