[Spacewalk-list] Error initializing Spacewalk: Could not populate database.

[Fabio Venturi]

Hello to anyone,
I'm trying to setup Spacewalk on a virtual machine with CentOS release
5.5 (Final) with PostgeSQL backend,
the following packages are installed on the system:

spacewalk-repo-1.2-0.el5
spacewalk-backend-libs-1.2.75-1.el5
spacewalk-branding-1.2.2-1.el5
spacewalk-html-1.2.31-1.el5
spacewalk-setup-jabberd-1.3.1-1.el5
spacewalk-backend-xml-export-libs-1.2.75-1.el5
spacewalk-backend-config-files-tool-1.2.75-1.el5
spacewalk-backend-package-push-server-1.2.75-1.el5
spacewalk-base-minimal-1.2.31-1.el5
spacewalk-grail-1.2.31-1.el5
spacewalk-setup-1.2.16-1.el5
spacewalk-schema-1.2.69-1.el5
spacewalk-java-lib-1.2.115-1.el5
spacewalk-certs-tools-1.2.2-1.el5
spacewalk-backend-1.2.75-1.el5
spacewalk-backend-sql-1.2.75-1.el5
spacewalk-backend-config-files-common-1.2.75-1.el5
spacewalk-backend-xmlrpc-1.2.75-1.el5
spacewalk-backend-iss-export-1.2.75-1.el5
spacewalk-backend-config-files-1.2.75-1.el5
spacewalk-backend-iss-1.2.75-1.el5
spacewalk-doc-indexes-1.1.1-1.el5
spacewalk-pxt-1.2.31-1.el5
spacewalk-admin-1.2.7-1.el5
spacewalk-backend-tools-1.2.75-1.el5
spacewalk-monitoring-1.2.1-1.el5
spacewalk-sniglets-1.2.31-1.el5
spacewalk-selinux-1.2.5-1.el5
spacewalk-java-1.2.115-1.el5
spacewalk-taskomatic-1.2.115-1.el5
spacewalk-common-1.2.3-1.el5
spacewalk-client-repo-1.2-0.el5
spacewalk-java-config-1.2.115-1.el5
spacewalk-config-1.2.7-1.el5
spacewalk-backend-server-1.2.75-1.el5
spacewalk-backend-app-1.2.75-1.el5
spacewalk-backend-applet-1.2.75-1.el5
spacewalk-backend-xp-1.2.75-1.el5
spacewalk-slf4j-1.6.1-1.el5
spacewalk-base-1.2.31-1.el5
spacewalk-monitoring-selinux-1.2.3-1.el5
spacewalk-search-1.2.4-1.el5

and
spacewalk-java-postgresql-1.2.115-1.el5
spacewalk-postgresql-1.2.3-1.el5
spacewalk-backend-sql-postgresql-1.2.75-1.el5
postgresql-libs-8.1.22-1.el5_5.1
postgresql-8.1.22-1.el5_5.1
postgresql-server-8.1.22-1.el5_5.1
postgresql-pl-8.1.22-1.el5_5.1
postgresql-jdbc-8.1.407-1jpp.4

PostgreSQL is up and running with database/role working correctly,
when running the command spacewalk-setup the output is:

[root at spacewalk.net1.lan ~]# spacewalk-setup --disconnected
** Database: Setting up database connection for PostgreSQL backend.
Hostname (leave empty for local)?
Database? spacewalk
Username? spacewalk
Password?
** Database: Populating database.
*** Progress: ##
Could not populate database.



And in the last line of the log file there is the following error:

[...]
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"rhn_urlps_recid_pk" for table "rhn_url_probe_step"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"valid_countries_pk" for table "valid_countries"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
"valid_countries_tl_unq" for table "valid_countries_tl"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"web_cust_not_id_pk" for table "web_customer_notification"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"wup_text_pk" for table "web_user_prefix"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"wust_type_pk" for table "web_user_site_type"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"wusi_id_pk" for table "web_user_site_info"
ERROR:  syntax error at or near "DEFAULT" at character 91


I've tried to search this error, but with no luck,
is this a known problem?
Thank you in advance for any hint,
Yours sincerely,

-
Fabio Venturi