Re: Reg: Postgresql8.3 Using on Ubuntu

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(at)bksystems(dot)co(dot)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(at)tao11(dot)riddles(dot)org(dot)uk>
> wrote:
>
>> >>>>> "neelaveni" == neelaveni <neelaveni(at)bksystems(dot)co(dot)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)
>>
>
>