Skip site navigation (1) Skip section navigation (2)

syntax error 2299 creating template db; making RPM/Linux

From: Alex Vorobiev <sasha(at)forum(dot)swarthmore(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Cc: staff(at)forum(dot)swarthmore(dot)edu
Subject: syntax error 2299 creating template db; making RPM/Linux
Date: 1998-11-16 18:00:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
RH Linux 5.1 
PostgreSQL 6.4

i am trying to create an RPM for 6.4.  among other problems, i fail to
create a template db.  

(1) i (my script) run the following command:

su postgres -c LD_LIBRARY_PATH=/var/tmp/pgsql-root/usr/lib
/var/tmp/pgsql-root/usr/bin/initdb --pgdata=/var/tmp/pgsql-root/var/lib/pgsql
--pglib= /var/tmp/pgsql-root/usr/lib/pgsql

(2) i have narrowed the problem down to the following line in initdb:

| postgres $BACKENDARGS template1

(3) once i set debug to 1 in initdb, i get the following at the end of 
the output from the above command:

Creating template database in /var/tmp/pgsql-root/var/lib/pgsql/base/template1
Running: postgres -boot -C -F -D/var/tmp/pgsql-root/var/lib/pgsql -d template1
[ much debug output skipped ]
> CREATED relation pg_description with OID 17066
> Commit End
Amopen: relation pg_description. attrsize 63
create attribute 0 name objoid len 4 num 1 type 26
create attribute 1 name description len -1 num 2 type 25
> Amclose: relation (null).
>       syntax error 2299 : parse error

is this a problem with the template?  please advise.


pgsql-admin by date

Next:From: 송기원Date: 1998-11-17 05:58:43
Subject: How to use text type field....
Previous:From: Dax KelsonDate: 1998-11-16 06:08:27
Subject: Permissions/security on pg_* tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group