On Wed, Aug 01, 2012 at 09:20:53PM +0200, [email protected] wrote: > Hi Jan, > > >>>(1 row)ERROR: relation "rhn_appinst_instance_id_seq" does not existLINE 1: > >>select pg_catalog.setval('rhn_appinst_instance_id_seq', 1, > >>f... ^ > >> > > > >This means the schema that you've dumped is of version 1.6, or your > >original upgrade from 1.6 to 1.7 failed. In any case, if loading the > >dump failed this way, your database is in inconsistent state and I > >don't recomment proceeding with using it. > > Actually, before dumping the database that I was trying to restore, I did a > 'yum update' on the Spacewalk server and a spacewalk-schema-upgrade. I can't > imagine it really is a version 1.6 database.
Did the spacewalk-schema-upgrade run without errors? Do you have a file 065-rhnAppInstallInstance-drop.sql on your filesystem? That should have dropped the sequence for good ... -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
