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: 199811161800.NAA08647@forum.swarthmore.edu (view raw or flat)
Thread:
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:

-------------------
cat $TEMPLATE \
| sed -e "s/postgres PGUID/$POSTGRES_SUPERUSERNAME $POSTGRES_SUPERUID/" \
      -e "s/PGUID/$POSTGRES_SUPERUID/" \
| 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.

thanks, 
--sasha/sasha(at)forum(dot)swarthmore(dot)edu

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-2014 The PostgreSQL Global Development Group