Thread
-
PostregSQL 6.5.3 on Linux RedHat 6.1/Ultra1 Sparc (sun4u)
Laurent LEVIER <llevier@argosnet.com> — 1999-12-17T22:09:49Z
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"