Re: Reg: Postgresql8.3 Using on Ubuntu

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(at)bksystems(dot)co(dot)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(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)
>>>>
>>>
>>>
>>