PostregSQL 6.5.3 on Linux RedHat 6.1/Ultra1 Sparc (sun4u)

Hi,

I compiled PgSQL 6.5.3 with the following procedure : 
# tar xvzf postgres...gz 
# cd post*3/src 
#./configure --prefix=/usr/local/pgsql --with-x --with-perl --enable-locale --with-pgport=1521 

This fails because PgSQL was not able to recognize my system : 
Linux zebra 2.2.12-42 #1 Fri Nov 12 13:03:33 EST 1999 sparc64 unknown

So, I defined a template that seems to be the better : 
# ./configure --prefix=/usr/local/pgsql --with-x --with-perl --enable-locale --with-pgport=1521 --with-template=linux_sparc 
... 
# make 
All compiled normally 
# make install 
Install was also perfect.

Then I prepared Pgsql : 
# chown -R pgsql:pgsql /usr/local/pgsql /var/pgsql 
# vi ~pgsql/.profile, to get : 
PGLIB=/usr/local/pgsql/lib 
PGDATA=/var/pgsql/data
export PGLIB PGDATA
PATH=$PATH:/usr/local/pgsql/bin
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:/usr/local/pgsql/lib 
export LD_LIBRARY_PATH

Then I installed the template1 database to starting doing my tests : 
su - pgsql 
Environment is set correctly 
$ initdb --username=pgsql 
We are initializing the database system with username pgsql (uid=502). 
This user will own all the files and must also own the server process.
Creating Postgres database system directory /var/pgsql/data
Creating Postgres database system directory /var/pgsql/data/base
Creating template database in /var/pgsql/data/base/template1 
ERROR: Attribute 'aggtransfn1' is repeated 
ERROR: Attribute 'aggtransfn1' is repeated 
initdb: could not create template database 
initdb: cleaning up by wiping out /var/pgsql/data/base/template1
And here we are, This is a typical bug report :)
My machine is an old Ultra 1 (143 MHz), with prom 3.11, and Sparc 64 architecture. 
64 MB RAM, and 2x2GB SCSI disks.

Linux was installed just removing some packages, no changes on system from 
RedHat 6.1 (kernel, ...).

I use the same procedure under Linux or Solaris Sparc, and everything was Ok.

Can you help ?

Regards

Laurent LEVIER
IT Systems & Networks, Unix System Engineer
Security Specialist

Argosnet Security Server : http://www.Argosnet.com
"Le Veilleur Technologique", "The Technology Watcher"