Regresstion Tests do not find PGLIB directory
-----BEGIN PGP SIGNED MESSAGE-----
The output of a src/test/regress/'make runtest' command puts out:
bash-2.04$ make runtest
MULTIBYTE=;export MULTIBYTE; \
/bin/sh ./regress.sh i586-pc-linux-gnu 2>&1 | tee regress.out
=============== Notes... =================
postmaster must already be running for the regression tests to succeed.
The time zone is set to PST8PDT for these tests by the client frontend.
Please report any apparent problems to ports@postgresql.org
See regress/README for more information.
=============== dropping old regression database... =================
DROP DATABASE
=============== creating new regression database... =================
CREATE DATABASE
=============== installing languages... =================
installing PL/pgSQL .. createlang: missing required argument PGLIB
directory
(This is the directory where the interpreter for the procedural
language is stored. Traditionally, these are installed in whatever
'lib' directory was specified at configure time.)
failed
ACTUAL RESULTS OF REGRESSION TEST ARE NOW IN FILE regress.out
To run the optional big test(s) too, type 'make bigtest'
These big tests can take over an hour to complete
These actually are: numeric_big
I have configured and made postgresql according to its INSTALL
instructions
on a RedHat 7 pc system.
I have added the appropriate line in /etc/ld.so.conf as suggested
pointing to
the lib directory under the postgresql installation. Such directory
does exist
and contains:
bash-2.04$ ls -al /export/home/postgres/postgresql-7.0.3/lib
total 1120
drwxrwxr-x 2 postgres postgres 4096 Feb 15 11:42 .
drwxr-xr-x 10 postgres postgres 4096 Feb 15 11:54 ..
- - -r--r--r-- 1 postgres postgres 628 Feb 15 11:40
global1.bki.source
- - -r--r--r-- 1 postgres postgres 0 Feb 15 11:40
global1.description
- - -rw-r--r-- 1 postgres postgres 37350 Feb 15 11:40 libecpg.a
lrwxrwxrwx 1 postgres postgres 16 Feb 15 11:40 libecpg.so ->
libecpg.so.3.1.1
lrwxrwxrwx 1 postgres postgres 16 Feb 15 11:40 libecpg.so.3 ->
libecpg.so.3.1.1
- - -rw-r--r-- 1 postgres postgres 29584 Feb 15 11:40 libecpg.so.3.1.1
- - -rw-r--r-- 1 postgres postgres 6548 Feb 15 11:40 libpgeasy.a
lrwxrwxrwx 1 postgres postgres 16 Feb 15 11:40 libpgeasy.so ->
libpgeasy.so.2.1
lrwxrwxrwx 1 postgres postgres 16 Feb 15 11:40 libpgeasy.so.2
- - -> libpgeasy.so.2.1
- - -rw-r--r-- 1 postgres postgres 7971 Feb 15 11:40 libpgeasy.so.2.1
- - -rw-r--r-- 1 postgres postgres 370626 Feb 15 11:40 libpq++.a
lrwxrwxrwx 1 postgres postgres 14 Feb 15 11:40 libpq++.so ->
libpq++.so.3.1
lrwxrwxrwx 1 postgres postgres 14 Feb 15 11:40 libpq++.so.3 ->
libpq++.so.3.1
- - -rw-r--r-- 1 postgres postgres 197278 Feb 15 11:40 libpq++.so.3.1
- - -rw-r--r-- 1 postgres postgres 66378 Feb 15 11:40 libpq.a
lrwxrwxrwx 1 postgres postgres 12 Feb 15 11:40 libpq.so ->
libpq.so.2.1
lrwxrwxrwx 1 postgres postgres 12 Feb 15 11:40 libpq.so.2 ->
libpq.so.2.1
- - -rw-r--r-- 1 postgres postgres 59319 Feb 15 11:40 libpq.so.2.1
- - -r--r--r-- 1 postgres postgres 183974 Feb 15 11:40
local1_template1.bki.source
- - -r--r--r-- 1 postgres postgres 24692 Feb 15 11:40
local1_template1.description
- - -r--r--r-- 1 postgres postgres 3407 Feb 15 11:40 pg_geqo.sample
- - -r--r--r-- 1 postgres postgres 5729 Feb 15 11:40
pg_hba.conf.sample
- - -r--r--r-- 1 postgres postgres 882 Feb 15 11:40
pg_ident.conf.sample
- - -r--r--r-- 1 postgres postgres 7643 Feb 15 11:40
pg_options.sample
- - -rw-r--r-- 1 postgres postgres 72567 Feb 15 11:42 plpgsql.so
- - -r--r--r-- 1 postgres postgres 1 Feb 15 11:42
postmaster.opts.default.sample
I have configured postgress with and without a --libdir definition and
the
get the same result on the regression testing attempts.
The src/test/regress/run_check.sh sets PGLIB="$LIBDIR" but I have not
been able to figure out how $LIBDIR should have been set, whereas now
it seems not to be set. I have not been able to find any reference to
PGLIB
in the postgresql documentation.
Any assistance would greatly be appreciated.
Emily.
Software Design Associates, Inc.
-----BEGIN PGP SIGNATURE-----
Version: 2.6.2
iQCVAwUBOow8G7qabQcdIDyxAQHeOQP5AbmkXVkj9mRHZ8tkdKBQvJtRUJzZ0DDz
Vo7IeZ2Avh0VjPaPBomsuYbnsMjMNikavx3j4Xi7nL8020JFdA83sOE/R2Xq2SPw
D4d+k00Di0ku8Mm6taS/50OB/AFC/oFxfh7XsVTGNvzPhbs76903TF2YnGC8Vkgi
couGMnR98wE=
=21R2
-----END PGP SIGNATURE-----
I have configured and made postgresql according to its INSTALL
instructions on a RedHat 7 pc system.
I have added the appropriate line in /etc/ld.so.conf as suggested
pointing to the lib directory under the postgresql installation.
You need to run ldconfig to actually update the shared library database.
Or reboot, since usually ldconfig is run at boot time.
Did the instructions mention /etc/ld.so.conf but not ldconfig? Perhaps
you can suggest where in the docs we can make it clearer, or better yet,
perhaps you can send patches for the doc/src/sgml/*.sgml files.
- Thomas
Emily Carl writes:
The output of a src/test/regress/'make runtest' command puts out:
installing PL/pgSQL .. createlang: missing required argument PGLIB
directory
(This is the directory where the interpreter for the procedural
language is stored. Traditionally, these are installed in whatever
'lib' directory was specified at configure time.)
failed
ACTUAL RESULTS OF REGRESSION TEST ARE NOW IN FILE regress.out
The src/test/regress/run_check.sh sets PGLIB="$LIBDIR" but I have not
been able to figure out how $LIBDIR should have been set, whereas now
it seems not to be set. I have not been able to find any reference to
PGLIB
in the postgresql documentation.
LIBDIR should be in src/Makefile.global. What does it say there?
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
-----BEGIN PGP SIGNED MESSAGE-----
Emily Carl writes:
The output of a src/test/regress/'make runtest' command puts out:
installing PL/pgSQL .. createlang: missing required argument PGLIB
directory
(This is the directory where the interpreter for the procedural
language is stored. Traditionally, these are installed in whatever
'lib' directory was specified at configure time.)
failed
ACTUAL RESULTS OF REGRESSION TEST ARE NOW IN FILE regress.outThe src/test/regress/run_check.sh sets PGLIB="$LIBDIR" but I have not
been able to figure out how $LIBDIR should have been set, whereas now
it seems not to be set. I have not been able to find any reference to
PGLIB
in the postgresql documentation.
Peter Eisentraut wrote:
LIBDIR should be in src/Makefile.global. What does it say there?
src/Makefile.global contains:
POSTGRESDIR= /export/home/postgres/postgresql-7.0.3
# Where the postgres executables live (changeable by just putting them
# somewhere else and putting that directory in your shell PATH)
BINDIR= $(POSTGRESDIR)/bin# Where libpq.a gets installed. You must put it where your loader will
# look for it if you wish to use the -lpq convention. Otherwise you
# can just put the absolute pathname to the library at the end of your
# command line.
LIBDIR= $(POSTGRESDIR)/lib
Does this definition come in to play in the make done down
in the src/test/regress directory? src/test/regress/README
Instructions state:
" To prepare for regression testing, do "make all" in the regression test
directory. This compiles a 'C' program with PostgreSQL extension functions
..."
- From what I am seeing, it does not. I have not added any
definitions of LD_LIBRARY_PATH or LIBDIR elsewhere such as in the
/etc/profile file (did make the suggested entry in the /etc/ld.so.conf).
Thomas Lockhart wrote:
You need to run ldconfig to actually update the shared library database.
Or reboot, since usually ldconfig is run at boot time.
Did run ldconfig.
Did the instructions mention /etc/ld.so.conf but not ldconfig? Perhaps
you can suggest where in the docs we can make it clearer, or better yet,
perhaps you can send patches for the doc/src/sgml/*.sgml files.
Instructions correctly say to run ldconfig after editing /etc/ld.so.conf.
No doc changes on ldconfig are needed.
Emily.
Software Design Associates, Inc.
-----BEGIN PGP SIGNATURE-----
Version: 2.6.2
iQCVAwUBOo2bubqabQcdIDyxAQGuMgP/bnVl4DqZMLEujZnpFp1Ai2ESRHRP32cJ
vT7ArcR+JzVI3ms+hx7joWX60CVW5ViiKmspmv5At8B3+At0o/C1P3tO3SRWRoN0
pOuQMCgiyob6V65wgsol7G1UgdghYRdSN6s8+XEcFpEC1qFaR3o8AGmn3NVfb5sb
dtMOGGobBSY=
=Ul9j
-----END PGP SIGNATURE-----
Emily Carl writes:
src/Makefile.global contains:
POSTGRESDIR= /export/home/postgres/postgresql-7.0.3
# Where the postgres executables live (changeable by just putting them
# somewhere else and putting that directory in your shell PATH)
BINDIR= $(POSTGRESDIR)/bin# Where libpq.a gets installed. You must put it where your loader will
# look for it if you wish to use the -lpq convention. Otherwise you
# can just put the absolute pathname to the library at the end of your
# command line.
LIBDIR= $(POSTGRESDIR)/libDoes this definition come in to play in the make done down
in the src/test/regress directory? src/test/regress/README
It should, unless you have a sufficiently odd version of GNU make.
Instructions state:
" To prepare for regression testing, do "make all" in the regression test
directory. This compiles a 'C' program with PostgreSQL extension functions
..."- From what I am seeing, it does not.
What exactly are you seeing that makes you believe that?
I have not added any
definitions of LD_LIBRARY_PATH or LIBDIR elsewhere such as in the
/etc/profile file (did make the suggested entry in the /etc/ld.so.conf).
This issue has absolutely nothing to do with the dynamic linker.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/