Horton

Thread

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

    laurent.levier@sita.int — 1999-12-17T10:19:47Z

    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