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"