Re: Reg: Postgresql8.3 Using on Ubuntu

May I know where I've get the postgresql-contrib for postgresql8.3 and
its related packages.
I've tried but all are depends on other packages. So unable to get its
properly.

Kindly help me.
Regards,
Neelaveni

On Monday 29 April 2019 02:32 PM, Flo Rance wrote:
> 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
> <mailto: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 <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)
>>>
>>
>