Re: Reg: Postgresql8.3 Using on Ubuntu

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