[Spacewalk-list] Postgresql 9.2.5

[Milan Zazrivec]

> I attempted to install Spacewalk 2.0 on a server using Postgresql 9.2.5. 
> Everything works in the setup document until I get to the point where I
> must run:
> 
> spacewalk-setup --disconnected --external-db
> 
> Which fails with the error:
> 
> ** Database: Populating database.
> *** Progress: #
> Could not populate database.
> 
> The above error doesn’t really tell me anything.  The only log I can find
> to tell me anything:
> 
> [root at hostname ~]# tail /var/log/rhn/populate_db.log
> SELECT 1
> psql:/etc/sysconfig/rhn/postgres/deploy.sql:6:
> /usr/share/pgsql/contrib/dblink.sql: No such file or directory
> 
> There is no pgsql directory below /usr/share.  I have the contrib package
> installed on CentOS 6.4 which is where this file is supposed to come from.
>  I am using the 9.2 repository from postgresql.org.
> 
> Does this mean that Spacewalk is not compatible with postgresql 9.2?  Is it
> compatible with any version 9?  I can’t find any dblink.sql anywhere.

On your Spacewalk machine, when you edit the following file:

    /etc/sysconfig/rhn/postgres/main.sql

and replace the following line:

    \i /usr/share/pgsql/contrib/dblink.sql

with the following line:

    create extension dblink;

and re-run spacewalk-setup, does your problem go away?

-MZ