X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BD10CD1B4BA for ; Thu, 18 Mar 2004 19:08:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74977-08 for ; Thu, 18 Mar 2004 15:08:10 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 19615D1EBB1 for ; Thu, 18 Mar 2004 15:08:02 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HUS00C01CRSEU@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Fri, 19 Mar 2004 00:36:11 +0530 (IST) Received: from sancharnet.in ([61.0.95.119]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HUS0006PD284A@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Fri, 19 Mar 2004 00:36:11 +0530 (IST) Date: Fri, 19 Mar 2004 00:56:00 +0530 From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]" Subject: PostgreSQL 7.3.4 to 4.2 Regresion Fails To: pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <4059F7C8.9050806@sancharnet.in> Organization: Sai Hertz And Control Systems Pvt Ltd MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/241 X-Sequence-Number: 12810 Dear all, I am migrating from PostgreSQL 7.3.4 to PostgreSQL 7..4.2 Steps followed are : 1. Backup 2. Get the copy >> extract >> own the extracted files by postgres (SuperUser) 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 gmake 6. Regress test with gmake check The test fails with following error gcc -shared -o autoinc.so 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" ============== /usr/local/src/postgresql-7.4.2/src/test/regress/./tmp_check/install//usr/bin/createdb: relocation error: /usr/local/src/postgresql-7.4.2/src/test/regress/./tmp_check/install//usr/bin/createdb: undefined symbol: get_progname pg_regress: createdb failed gmake[2]: *** [check] Error 2 rm regress.o gmake[2]: Leaving directory `/usr/local/src/postgresql-7.4.2/src/test/regress' 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, http://saihertz.rediffblogs.com Jabber IM: vishalkashyap@jabber.org ICQ : 264360076 Yahoo IM: mailforvishal@yahoo.com ----------------------------------------------- You yourself, as much as anybody in the entire universe, deserve your love and affection. - Buddha --------------- pgsql=# select marital_status from vishals_life; marital_status ------------------ Single not looking 1 Row(s) affected ___ //\\\ ( 0_0 ) ----------------o0o-----o0o---------------------