<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<br><br>I'm preparing a spacewalk migration from one server with redhat 6 and postgresql 9.1 to amazon .<br>The server will be split in two. One aws instance (RH6) and postgresql (9.4) will be in EC2. <br><br>I'm trying to perform a fresh install.<br>I configured the repo and all dependencies were resolved.<br><br>but when i'm lauching<br><br>spacewalk-setup --disconnected --external-db<br><br>[root@ip-10-230-8-76 bdd]# spacewalk-setup --disconnected --external-db<br>** Database: Setting up database connection for PostgreSQL backend.<br>Hostname (leave empty for local)? spacewalk.bdd.aws.<br>Port [5432]? <br>Database? spacewalk<br>Username? admin<br>Password? <br>** Database: Populating database.<br>*** Progress: #<br>Could not populate database.<br><br>In log file I have this :<br>SELECT 1<br>SET<br>psql:/usr/share/pgsql/contrib/dblink.sql:11: ERROR: no schema has been selected to create in<br>/var/log/rhn/populate_db.log (END) <br><br>file is present and instructions seems to create dblink functions.<br><br>After some search on google, I tried to modified <span style="font-size: 11pt; font-family: "Calibri","sans-serif";">/etc/sysconfig/rhn/postgres/main.sql and change the line </span><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif";"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif";"> \i /usr/share/pgsql/contrib./dblink.sql </span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif";">to</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif";">create extension dblink;</span></p><p class="MsoNormal"><br><span style="font-size: 11pt; font-family: "Calibri","sans-serif";"></span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif";">but still the same error.<br></span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri","sans-serif";">SELECT 1<br>psql:/etc/sysconfig/rhn/postgres/deploy.sql:7: ERROR: no schema has been selected to create in<br><br></span></p>Did I miss something ?<br><br>Any ideas on how to solve this issue ? I know spacewalk 2.0 is not the latest version but that's not my choice.<br><br>Regards<br><br>Thibaud<br> </div></body>
</html>