Thread: 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

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:
> 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
>

*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:
> "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
>

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