The following bug has been logged online:

Bug reference: 1306
Logged by: David Dick

Email address: ddick (AT) cpan (DOT) 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.



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

David Dick <david_dick (AT) iprimus (DOT) com.au> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

../configure --prefix=/usr/local

lets me run throu the entire test suite without an issue.

Tom Lane wrote:
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

*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:
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

David Dick <david_dick (AT) iprimus (DOT) com.au> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster