[Spacewalk-list] Could not populate database

[Nuno Dias]

Ok, thank's.

Nuno

On Thu, 2010-06-24 at 09:56 +0200, Jan Pazdziora wrote: 
> On Wed, Jun 23, 2010 at 05:05:19PM +0100, Nuno Dias wrote:
> > Hi,
> > 
> > I installed spacewalk from the rpm repositories, version 1.0 and after I
> > run spacewalk-setup --disconnected I'm getting this error "Could not
> > populate database".
> > 
> > In the logs I have this 
> > 
> > psql:/etc/sysconfig/rhn/postgres/main.sql:6307: ERROR:  syntax error at
> > or near "BYTEA"
> > LINE 8:     primary     BYTEA,
> > 
> > This is what is in /etc/sysconfig/rhn/postgres/main.sql
> >                         ^
> > CREATE TABLE rhnPackageRepodata
> > (
> >     package_id  NUMERIC
> >                     CONSTRAINT rhnPackageRepodata_pk PRIMARY KEY
> >                     CONSTRAINT rhn_pkey_rd_pid_fk
> >                         REFERENCES rhnPackage (id)
> >                         ON DELETE CASCADE,
> >     primary     BYTEA,
> >     filelist    BYTEA,
> >     other       BYTEA,
> >     created     TIMESTAMPTZ
> >                     DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
> >     modified    TIMESTAMPTZ
> >                     DEFAULT (CURRENT_TIMESTAMP) NOT NULL
> > )
> > ; <---- Line 6307
> > 
> > 
> > Can someone give me some help?
> 
> This is caused by the fact that primary is a reserved word in
> PostgreSQL:
> 
> 	https://www.redhat.com/archives/spacewalk-devel/2010-June/msg00029.html
> 
> Having said that -- are you sure you wanted to install the PostgreSQL
> version? It is known not to work.
> 

-- 
Nuno Dias <ndias at lip.pt>
LIP