============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Chad Dressler
Your email address : chadmd@cyber-wire.com
Category : runtime: back-end
Severity : critical
Summary: Parse errors and segmentation fault when running initdb
System Configuration
--------------------
Operating System : SuSE Linux 5.3, kernel 2.0.35
PostgreSQL version : 6.4.2
Compiler used : gcc 2.7.2.1
Hardware:
---------
Linux MizarFive 2.0.35 #2 Sun Nov 29 22:13:38 MST 1998 i686 unknown
Versions of other tools:
------------------------
gmake 3.76.1
flex 2.5.4
--------------------------------------------------------------------------
Problem Description:
--------------------
When I run initdb, I get the following output:
initdb: using /slack/usr/local/src/postgres/pgsql/lib/local1_template1.bki.sourc
e as input to create the template database.
initdb: using /slack/usr/local/src/postgres/pgsql/lib/global1.bki.source as inpu
t to create the global classes.
initdb: using /slack/usr/local/src/postgres/pgsql/lib/pg_hba.conf.sample as the
host-based authentication control file.
We are initializing the database system with username postgres (uid=26).
This user will own all the files and must also own the server process.
Creating Postgres database system directory /slack/usr/local/src/postgres/pgsql/
data
Creating Postgres database system directory /slack/usr/local/src/postgres/pgsql/
data/base
initdb: creating template database in /slack/usr/local/src/postgres/pgsql/data/b
ase/template1
Running: postgres -boot -C -F -D/slack/usr/local/src/postgres/pgsql/data -Q temp
late1
syntax error 2305 : parse error
Creating global classes in /base
Running: postgres -boot -C -F -D/slack/usr/local/src/postgres/pgsql/data -Q temp
late1
Adding template1 database to pg_database...
Running: postgres -boot -C -F -D/slack/usr/local/src/postgres/pgsql/data -Q temp
late1 < /tmp/create.15734
ERROR: pg_atoi: error in "template1": can't parse "template1"
ERROR: pg_atoi: error in "template1": can't parse "template1"
/usr/bin/initdb: line 338: 15756 Segmentation fault postgres $BACKENDARGS template1 </tmp/create.$$
initdb: could not log template database
initdb: cleaning up.
--------------------------------------------------------------------------
Test Case:
----------
The only non-standard thing I did during compliation/installation was to change the install and source directories.
Formy postgres user, PGDATA=/slack/usr/local/src/postgres/pgsql/data and PGLIB=/slack/usr/local/src/postgres/pgsql/lib,
andmy source is in /usr/slack/local/src/postgres/postgresql-6.4.2.
I was following the directions directly from the INSTALL document, and I had reached the "Create the database
installation"step.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
