[99839] in RedHat Linux List
syntax error 2299 creating template db; making RPM/Linux
daemon@ATHENA.MIT.EDU (Alex Vorobiev)
Tue Nov 17 09:43:01 1998
To: redhat-list@redhat.com
Date: Tue, 17 Nov 1998 09:41:55 -0500
From: Alex Vorobiev <sasha@forum.swarthmore.edu>
Resent-From: redhat-list@redhat.com
Reply-To: redhat-list@redhat.com
[ posted to pgsql-admin@postgresql.org ]
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@forum.swarthmore.edu
--
PLEASE read the Red Hat FAQ, Tips, Errata and the MAILING LIST ARCHIVES!
http://www.redhat.com http://archive.redhat.com
To unsubscribe: mail redhat-list-request@redhat.com with
"unsubscribe" as the Subject.
