I've been spending the last couple of days trying to upgrade lots of stuff
from the standard linux disto programs. Postgres is not making this easy on
me. I've followed the INSTALL file instructions verbatim and all is good
until section 19 of the install doc. It instructs to run the 'initdb'
command. When I do this I get the following error:
==============================================
[postgres@orion pgsql]$ initdb
initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as input to
create the template database.
initdb: using /usr/local/pgsql/lib/global1.bki.source as input to create the
global classes.
initdb: using /usr/local/pgsql/lib/pg_hba.conf.sample as the host-based
authentication control file.
We are initializing the database system with username postgres (uid=531).
This user will own all the files and must also own the server process.
Creating Postgres database system directory /usr/local/pgsql/data
Creating Postgres database system directory /usr/local/pgsql/data/base
initdb: creating template database in /usr/local/pgsql/data/base/template1
Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
syntax error 2305 : parse error
Creating global classes in /base
Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1
Adding template1 database to pg_database...
Running: postgres -boot -C -F -D/usr/local/pgsql/data -Q template1 <
/tmp/create.20108
ERROR: pg_atoi: error in "template1": can't parse "template1"
ERROR: pg_atoi: error in "template1": can't parse "template1"
initdb: could not log template database
initdb: cleaning up.
[postgres@orion pgsql]$
===============================================
The /usr/local/pgsql/data directory is never created, no database is made,
and I get a core file.
I really need to get this working, any ideas? Thanks =)
________________________________
Northstar Digital Media Inc.
Jason Farnsworth
jason@nsdigital.com