I'm trying to install PostgreSQL 6.5.1 on an Intel-based machine running RedHat Linux 5.2. Everything compiles and installs OK but when I try to run initdb I receive the following error: (Section from initdb output when run in debug mode) ======================================================================== == > CREATED relation pg_description with OID 17004 > 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 2334 : parse error Creating global classes in /base Running: postgres -boot -C -F -D/usr/local/pgsql/data -d template1 <datname name> <datdba int4> <encoding int4> <datpath text> > creating bootstrap relation bootstrap relation created ok > Commit End Amclose: relation (null). > <varfoo oid> > creating bootstrap relation bootstrap relation created ok > Commit End Amclose: relation (null). > <usename name> <usesysid int4> <usecreatedb bool> <usetrace bool> <usesuper bool> <usecatupd bool> <passwd text> <valuntil int4> > creating bootstrap relation bootstrap relation created ok > Commit End tuple 0<Inserting value: 'postgres' Typ == NULL, typeindex = 3 idx = 0 postgres End InsertValue Inserting value: '501' Typ == NULL, typeindex = 7 idx = 1 501 End InsertValue Inserting value: 't' Typ == NULL, typeindex = 0 idx = 2 t End InsertValue Inserting value: 't' Typ == NULL, typeindex = 0 idx = 3 t End InsertValue Inserting value: 't' Typ == NULL, typeindex = 0 idx = 4 t End InsertValue Inserting value: 't' Typ == NULL, typeindex = 0 idx = 5 t End InsertValue Inserting null Inserting value: '2116994400' Typ == NULL, typeindex = 7 idx = 7 2116994400 End InsertValue Insert Begin InsertOneTuple oid 0, 8 attrs End InsertOneTuple, objectid=0 Insert End > Transaction End Amclose: relation (null). > <groname name> <grosysid int4> <grolist _int4> > creating bootstrap relation bootstrap relation created ok > Commit End Amclose: relation (null). > <logfoo oid> > creating bootstrap relation bootstrap relation created ok > Commit End Amclose: relation (null). > Adding template1 database to pg_database... Running: postgres -boot -C -F -D/usr/local/pgsql/data -d template1 < /tmp/create.5188 Amopen: relation pg_database. attrsize 63 create attribute 0 name datname len 32 num 1 type 19 create attribute 1 name datdba len 4 num 2 type 23 create attribute 2 name encoding len 4 num 3 type 23 create attribute 3 name datpath len -1 num 4 type 25 > tuple 17056<Inserting value: 'template1' Typ != NULL template1 End InsertValue Inserting value: '501' Typ != NULL 501 End InsertValue 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. ======================================================================== == Does anyone know how to work around this? Tobias Alm�n
