Re: Reg: Postgresql8.3 Using on Ubuntu - Mailing list pgsql-bugs

You'll have to compile and install the module as explained here: https://www.postgresql.org/docs/8.3/contrib.html

Flo

On Mon, Apr 29, 2019 at 10:43 AM neelaveni <neelaveni@bksystems.co.in> wrote:

Thanks, Yes after installing the libperl-dev, I didn't get the error for "$libdir/plperl",

but I'm getting error for "$libdir/dblink".

Kindly provide the solution for that also, please.

On Monday 29 April 2019 01:29 PM, Flo Rance wrote:

The problem is here: /usr/bin/ld: cannot find -lperl

If you want to build perl library, you need to install libperl-dev package.

Regards,

Flo

On Mon, Apr 29, 2019 at 9:25 AM neelaveni <neelaveni@bksystems.co.in> wrote:

Dear Sir/Mam,

    While execute the dbdump on the postgres8.3 I've got the following error,

        ERROR:  could not access file "$libdir/plperl": No such file or directory

        ERROR:  could not access file "$libdir/dblink": No such file or directory

    Then I've tried to ./configure --with-perl, but while using the make its fails as follow,

        make[4]: Entering directory '/root/postgresql-8.3.7/src/pl/plpgsql/src'
make[4]: Nothing to be done for 'all'.
make[4]: Leaving directory '/root/postgresql-8.3.7/src/pl/plpgsql/src'
make[3]: Leaving directory '/root/postgresql-8.3.7/src/pl/plpgsql'
make[3]: Entering directory '/root/postgresql-8.3.7/src/pl/plperl'
clang -O1 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -fpic -shared -Wl,-soname,libplperl.so.0   plperl.o spi_internal.o SPI.o -L/usr/local/lib -L/usr/lib/x86_64-linux-gnu/perl/5.22/CORE -L../../../src/port -fstack-protector-strong -lperl -ldl -lm -lpthread -lc -lcrypt -Wl,-rpath,'/usr/lib/x86_64-linux-gnu/perl/5.22/CORE' -o libplperl.so.0.0
/usr/bin/ld: cannot find -lperl
clang: error: linker command failed with exit code 1 (use -v to see invocation)
../../../src/Makefile.shlib:284: recipe for target 'libplperl.so.0.0' failed
make[3]: *** [libplperl.so.0.0] Error 1
make[3]: Leaving directory '/root/postgresql-8.3.7/src/pl/plperl'
Makefile:30: recipe for target 'all' failed
make[2]: *** [all] Error 1
make[2]: Leaving directory '/root/postgresql-8.3.7/src/pl'
Makefile:17: recipe for target 'all' failed
make[1]: *** [all] Error 2
make[1]: Leaving directory '/root/postgresql-8.3.7/src'
GNUmakefile:12: recipe for target 'all' failed
make: *** [all] Error 2

    Kindly help me to fix this issue.

Regards,

Neelaveni

On Monday 29 April 2019 12:21 PM, Flo Rance wrote:

Thank you Andrew for the details.

Flo

On Sat, Apr 27, 2019 at 1:45 PM Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:

>>>>> "neelaveni" == neelaveni  <neelaveni@bksystems.co.in> writes:

 neelaveni> Thank you so much your suggestions help me lot ..... While
 neelaveni> using

 neelaveni> ./configure CFLAGS="-01", I got some error. Its seems to 01,
 neelaveni> but when I use CFLAGS="-O1" its working properly.

The correct option would be CFLAGS="-O2 -fno-aggressive-loop-optimizations"

That option will be used by default if you compile the REL8_3_STABLE
branch tip from git; as an exceptional case, the option was backpatched
to that branch (and some others) even after it was EOLed.

--
Andrew (irc:RhodiumToad)