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

[Alan Pittman]

Hi,
  I'm upgrading Spacewalk w/postgresql on a RHEL6, x86_64 server. All went well until I ran the schema update. Got the following  error message:

                                     ?column?                                      
------------------------------------------------------------------------------------
 spacewalk-schema-1.6-to-spacewalk-schema-1.7/110-create_pxt_session.sql.postgresql
(1 row)

CREATE FUNCTION
COMMIT
                                ?column?                                 
-------------------------------------------------------------------------
 spacewalk-schema-1.6-to-spacewalk-schema-1.7/111-rhnPackageKey-data.sql
(1 row)

psql:/var/log/spacewalk/schema-upgrade/20120307-154732-script.sql:5090: ERROR:  duplicate key value violates unique constraint "rhn_pkey_keyid_uq"

This is just the bottom of the schema-upgrade log file. If you want to see the whole file, let me know and I'll send it. Just trying to conserve space here.

Alan

Alan Pittman 
Publix Super Markets, Inc. 
863-686-8754 ext. 46320 
alan.pittman at publix.com 

"Unix is user-friendly. It's just very selective about who its friends are."