Re: Reg: Postgresql8.3 Using on Ubuntu

Thanks a lot, its working fine.
Further any clarification, I will request psql-general.

Regards,
Neelaveni

On Monday 29 April 2019 04:01 PM, Flo Rance wrote:
> From https://www.postgresql.org/docs/8.3/contrib.html:
>
> "When building from the source distribution, these modules are not
> built automatically. You can build and install all of them by running
>
> gmake
> gmake install
>
> in the contrib directory of a configured source tree; or to build and
> install just one selected module, do the same in that module's
> subdirectory. Many of the modules have regression tests, which can be
> executed by running
>
> gmake installcheck
>
> once you have a PostgreSQL server running. (Note that gmake check is
> not supported; you must have an operational database server to perform
> these tests, and you must have built and installed the module(s) to be
> tested.)"
>
> Btw, you should have asked that on pgsql-general, because it's not a bug.
>
> Flo
>
>
> On Mon, Apr 29, 2019 at 12:17 PM neelaveni <neelaveni(at)bksystems(dot)co(dot)in
> <mailto:neelaveni(at)bksystems(dot)co(dot)in>> wrote:
>
> 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)
>>>>
>>>
>>
>