Hi,

Sorry to ask this question straight out but I wasn't sure where else to get an answer! 

Due to the 32 character limit on column/table names, we needed to recompile PostgreSQL from the source with updated settings.  It compiles fine, but on running initdb, we get the following output:

------------------------------------
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

Fixing permissions on existing directory /var/lib/pgsql/data... ok
creating directory /var/lib/pgsql/data/base... ok
creating directory /var/lib/pgsql/data/global... ok
creating directory /var/lib/pgsql/data/pg_xlog... ok
creating directory /var/lib/pgsql/data/pg_clog... ok
creating template1 database in /var/lib/pgsql/data/base/1... /usr/bin/initdb: line 473: 23462 Broken pipe             cat "$POSTGRES_BKI"
     23463                       | sed -e "s/POSTGRES/$POSTGRES_SUPERUSERNAME/g" -e "s/ENCODING/$MULTIBYTEID/g"
     23464 Segmentation fault      | "$PGPATH"/postgres -boot -x1 $PGSQL_OPT $BACKEND_TALK_ARG template1

initdb failed.
---------------------------------

Can anyone shed some light on this just by looking at it?  Two of us have wasted basically an entire day getting to this point and would appreciate any assistance.  We may end up having to settle with 64 characters and install the latest RC :-) However ideally we'd like to be able to go beyond 64.

Cheers,

Chris

----------------------------------------------
Chris Cox
B.IT.(Information Systems) 
Senior Software Engineer

Creatop Interactive Media
Level 1, 240 McCullough Street
Sunnybank. Qld. 4109
Australia
Ph:     +61 7 3216 9755
Mobile: +61 412 416600
http://www.creatop.com.au/
chris@creatop.com.au
----------------------------------------------

Thu, 28 Nov 2002 17:50:18 +1000 (EST)
chris@creatop.com.au
InitDB Failure - PostgreSQL 7.2, RedHat 7.3, compile from source
chris@creatop.com.au writes:
> Due to the 32 character limit on column/table names, we needed to recompile PostgreSQL from the source with updated settings.  It compiles fine, but on running initdb, we get the following output:

Without bothering to examine the details, I'll bet you didn't do a full
recompile.  You need "make clean" then "make all" after changing
settings such as this one.

> However ideally we'd like to be able to go beyond 64.

Note that the reason 7.3 defaults to 64, and not more, is that we
measured noticeable performance degradation at 128 and beyond.

			regards, tom lane

Thu, 28 Nov 2002 09:48:38 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: InitDB Failure - PostgreSQL 7.2, RedHat 7.3, compile from source 