Re: Reg: Postgresql8.3 Using on Ubuntu

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