============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Jason Farnsworth
Your email address : jason@nsdigital.com
Category : install: other
Severity : serious
Summary: initdb error during install
System Configuration
--------------------
Operating System : Linux 2.0.35 ELF Glibc (Red Hat 5.0)
PostgreSQL version : 6.4.2
Compiler used : gcc 2.7.2.3
Hardware:
---------
Pentium II 450Mhz
128MB RAM
Linux orion 2.0.35 #1 Tue Sep 22 16:50:10 PDT 1998 i686 unknown
/dev/rd/c0d0p1 1488226 1048003 363321 74% /
/dev/rd/c0d0p4 11137855 85694 10473806 1% /home
Versions of other tools:
------------------------
GNU Make version 3.76.1
flex version 2.5.4
--------------------------------------------------------------------------
Problem Description:
--------------------
Followed the INSTALL doc word for word. Section 19 says to run initdb, I get the following:
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.19956
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.
--------------------------------------------------------------------------
Test Case:
----------
initdb =)
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------