Skip site navigation (1) Skip section navigation (2)

PostgreSQL 7.3.4 to 4.2 Regresion Fails

From: "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in>
To: pgsql-admin(at)postgresql(dot)org
Subject: PostgreSQL 7.3.4 to 4.2 Regresion Fails
Date: 2004-03-18 19:26:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Dear all,

I am migrating from PostgreSQL 7.3.4
PostgreSQL 7..4.2
Steps followed are :
1. Backup
2. Get the copy  >> extract >> own the extracted files by postgres 
3. Remove the old data directoy as old and new data directory would be same
4. Configure with

 ./configure \--bindir=/usr/bin \--prefix=/postgres 
\--libdir=/usr/lib/pgsql \--sysconfdir=/etc/sysconfig/pgsql 
\--datadir=/postgres/data \--enable-multibyte \--with-perl 
\--enable-syslog \--with-CXX \--with-tcl \--with-python \--enable-odbc 
\--with-pgport=5432 \--with-unixodbc

5. Make with


6. Regress test with

gmake check

The test fails with following error


gcc -shared -o autoinc.o
rm refint.o autoinc.o
gmake[3]: Leaving directory `/usr/local/src/postgresql-7.4.2/contrib/spi'
/bin/sh ./pg_regress --temp-install --top-builddir=../../.. 
--schedule=./parallel_schedule --multibyte=SQL_ASCII
============== creating temporary installation        ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 65432 with pid 3393
============== creating database "regression"         ==============
relocation error: 
undefined symbol: get_progname
pg_regress: createdb failed
gmake[2]: *** [check] Error 2
rm regress.o
gmake[2]: Leaving directory 
gmake[1]: *** [check] Error 2
gmake[1]: Leaving directory `/usr/local/src/postgresql-7.4.2/src/test'
gmake: *** [check] Error 2


Machine Specs are:
1. bison (GNU Bison) 1.875
2. gcc version 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
3. Kernel 2.4.20-24.9
4. RH 9.0

What am I doing wrong ?

Thanks in advance.

Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
Jabber IM: vishalkashyap(at)jabber(dot)org
ICQ :      264360076
Yahoo  IM: mailforvishal(at)yahoo(dot)com
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
pgsql=# select marital_status from vishals_life;

Single not looking

1 Row(s) affected

                  ( 0_0 )


pgsql-admin by date

Next:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-03-18 20:02:18
Subject: Re: PostgreSQL 7.3.4 to 4.2 Regresion Fails
Previous:From: Jonathan GardnerDate: 2004-03-18 18:41:18
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group