RE: [GENERAL] Error running 'initdb' - Mailing list pgsql-general
From | Frans de Wet |
---|---|
Subject | RE: [GENERAL] Error running 'initdb' |
Date | |
Msg-id | 000101be7594$548737f0$0101a8c0@carolina Whole thread Raw |
In response to | Error running 'initdb' ("Jason Farnsworth" <jason@nsdigital.com>) |
List | pgsql-general |
Make sure you have ONLY ONE VERSION (the correct version) of initdb, postmaster, and psql and so on in your path ... if you had the postgresql rpm installed and then upgraded from the tgz files you can run into problems like this ... although ... I am not 100% sure that it is the exact same problem I had ... just a hint ;-) I had the postgres binaries in /usr/bin and in /usr/local/pgsql/bin and the postmaster from /usr/local/pgsql/bin was running with the older binaries in the path trying to access it correctly. No luck till I removed the RPM. Frans -----Original Message----- From: owner-pgsql-general@postgreSQL.org [mailto:owner-pgsql-general@postgreSQL.org] On Behalf Of Jason Farnsworth Sent: Wednesday, March 24, 1999 03:10 To: pgsql-general@postgreSQL.org Subject: [GENERAL] Error running 'initdb' 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
pgsql-general by date: