BUG #1306: locale related issue.
The following bug has been logged online:
Bug reference: 1306
Logged by: David Dick
Email address: ddick@cpan.org
PostgreSQL version: 8.0 Beta
Operating system: Debian (Woody) with a Linux 2.6.7 kernel
Description: locale related issue.
Details:
in response to;
tar -jxf postgresql-8.0.0beta4.tar.bz2
cd postgresql-8.0.0beta4
./configure
make check
combination, i received the following message. postgres 7.4.3 makes check
fine
*snip*
/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 11316
============== creating database "regression" ==============
CREATE DATABASE
pg_regress: could not set database default locales
make[2]: *** [check] Error 2
rm regress.o
make[2]: Leaving directory
`/home/dave/postgresql-8.0.0beta4/src/test/regress'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/home/dave/postgresql-8.0.0beta4/src/test'
make: *** [check] Error 2
dave@summit:~/postgresql-8.0.0beta4$
dave@summit:~$ uname -a
Linux summit 2.6.7 #1 SMP Sun Jul 18 08:02:18 EST 2004 i686 unknown
Sorry for the brevity of the report. Would be happy to respond with more
detail if requested.
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
CREATE DATABASE
pg_regress: could not set database default locales
This is most likely not actually locale-related at all; it's probably
got something to do with a failure to start psql. Please remove the
"2>/dev/null" in the pg_regress script at the point where this error
would be reported, so you can see what the problem really is.
(Yes, we've done that in CVS tip...)
regards, tom lane
*snip*
/bin/sh ./pg_regress --temp-install --top-builddir=../../..
--schedule=./parallel_schedule --multibyte=SQL_ASCII
============== removing existing temp installation ==============
============== creating temporary installation ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 65432 with pid 29624
============== creating database "regression" ==============
CREATE DATABASE
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
relocation error:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
undefined symbol: PQserverVersion
pg_regress: could not set database default locales
make[2]: *** [check] Error 2
make[2]: Leaving directory
`/home/dave/postgresql-8.0.0beta4/src/test/regress'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/home/dave/postgresql-8.0.0beta4/src/test'
make: *** [check] Error 2
dave@summit:~/postgresql-8.0.0beta4$
Tom Lane wrote:
Show quoted text
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
CREATE DATABASE
pg_regress: could not set database default localesThis is most likely not actually locale-related at all; it's probably
got something to do with a failure to start psql. Please remove the
"2>/dev/null" in the pg_regress script at the point where this error
would be reported, so you can see what the problem really is.
(Yes, we've done that in CVS tip...)regards, tom lane
David Dick <david_dick@iprimus.com.au> writes:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
relocation error:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
undefined symbol: PQserverVersion
pg_regress: could not set database default locales
Apparently psql is picking up an old libpq.so version from
/usr/local/pgsql/lib. You may need to go ahead and install the
newer version. Or if that doesn't sound like a good plan, reconfigure
and rebuild with an installation --prefix that doesn't match the
existing older installation.
regards, tom lane
./configure --prefix=/usr/local
lets me run throu the entire test suite without an issue.
Tom Lane wrote:
Show quoted text
David Dick <david_dick@iprimus.com.au> writes:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
relocation error:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
undefined symbol: PQserverVersion
pg_regress: could not set database default localesApparently psql is picking up an old libpq.so version from
/usr/local/pgsql/lib. You may need to go ahead and install the
newer version. Or if that doesn't sound like a good plan, reconfigure
and rebuild with an installation --prefix that doesn't match the
existing older installation.regards, tom lane
David Dick <david_dick@iprimus.com.au> writes:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
relocation error:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
undefined symbol: PQserverVersion
pg_regress: could not set database default locales
Your temp installation is picking up a previously-installed older
libpq.so library. AFAIK the best way around this is to go ahead
and install the newer libpq.so.
regards, tom lane