<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi,</p>
<p>I am seeing this issue when trying to upgrade our current spacewalk server 2.2 release using either 2.3 or 2.4 repos.</p>
<p><br>
</p>
<p>(snip)</p>
<p><span style="font-size: 12pt;">-----------------------------------------------------------------------------------------</span><br>
</p>
<p></p>
<div> spacewalk-schema-2.2-to-spacewalk-schema-2.3/010-rhnDistChannelMap_index.sql.postgresql</div>
<div>(1 row)</div>
<div><br>
</div>
<div>ALTER TABLE</div>
<div>CREATE INDEX</div>
<div>CREATE INDEX</div>
<div>COMMIT</div>
<div> ?column? </div>
<div>--------------------------------------------------------------------------------------</div>
<div> spacewalk-schema-2.2-to-spacewalk-schema-2.3/011-rhnWebContactEnabled.sql.postgresql</div>
<div>(1 row)</div>
<div><br>
</div>
<div>CREATE VIEW</div>
<div>COMMIT</div>
<div> ?column? </div>
<div>--------------------------------------------------------------------------------------------</div>
<div> spacewalk-schema-2.2-to-spacewalk-schema-2.3/012-rhnServerPackageArchCompat.sql.postgresql</div>
<div>(1 row)</div>
<div><br>
</div>
<div>psql:/var/log/spacewalk/schema-upgrade/20160209-104250-script.sql:1620: ERROR: duplicate key value violates unique constraint "rhn_sp_ac_said_paid_uq"</div>
<p><br>
</p>
<p>I have tried one option about manually running the commands but get an error below following this message <a href="http://www.redhat.com/archives/spacewalk-list/2014-March/msg00040.html" id="LPlnk897596" title="http://www.redhat.com/archives/spacewalk-list/2014-March/msg00040.html
Ctrl+Click or tap to follow the link">http://www.redhat.com/archives/spacewalk-list/2014-March/msg00040.html</a>:</p>
<br>
<p></p>
<div><span style="font-size: 12pt;">su - postgres</span><br>
</div>
<div>psql spaceschema</div>
<div>psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres", database "spaceschema", SSL off</div>
<div><br>
</div>
<div>If i re-run the schema upgrade I now see this.</div>
<div><br>
</div>
<p></p>
<p></p>
<div>/usr/bin/spacewalk-schema-upgrade</div>
<div>Unknown schema name [(0 rows)] found.</div>
<div><br>
</div>
<div>Any help would be great thanks, there is mention in one for the previous list to manually run the sql statements in the dd but I cant login to even do this.</div>
<div><br>
</div>
<div>regards</div>
<div>Darren</div>
<br>
<p></p>
</div>
</body>
</html>