[Spacewalk-list] duplicate key value during Spacewalk 1.6 to 1.7, using postgresql

[Jan Pazdziora]

On Thu, Mar 08, 2012 at 01:03:56PM +0000, Alan Pittman wrote:
> Thanks for the reply. As you requested, I renamed the 111-rhnPackageKey-data.sql and then created a new version of the file with the information you supplied below. When I rerun the /usr/bin/spacewalk-schema-upgrade, I get the following message: 
> 
> [root at taeps001 ~]# /usr/bin/spacewalk-schema-upgrade
> Unknown schema name [(0 rows)] found.
> [root at taeps001 ~]#
> 
> What am I doing wrong?

Your previous schema upgrade failed, so the schema upgrade script
cannot determine what version to start the upgrade from.

Your best best is to just restore the database backup and run the
schema upgrade fully, from 1.6 to 1.7.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat