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, ...).
Can you help ?
Regards
Laurent LEVIER
IT Systems & Networks Security Specialist
IT Infrastructure Department / Information System Division
SITA / EQUANT SC
Tel. CVN : 7223-1912, ext. (+33) 4 92 38 19 12
