Re: Reg: Postgresql8.3 Using on Ubuntu
От | neelaveni |
---|---|
Тема | Re: Reg: Postgresql8.3 Using on Ubuntu |
Дата | |
Msg-id | e12c8604-0288-5217-821b-771f50273579@bksys.co.in обсуждение исходный текст |
Ответ на | Reg: Postgresql8.3 Using on Ubuntu (neelaveni <neelaveni@bksystems.co.in>) |
Список | pgsql-bugs |
I've tried but all are depends on other packages. So unable to get its properly.
Kindly help me.
Regards,
Neelaveni
You'll have to compile and install the module as explained here: https://www.postgresql.org/docs/8.3/contrib.htmlFloOn Mon, Apr 29, 2019 at 10:43 AM neelaveni <neelaveni@bksystems.co.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 -lperlIf you want to build perl library, you need to install libperl-dev package.Regards,FloOn Mon, Apr 29, 2019 at 9:25 AM neelaveni <neelaveni@bksystems.co.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 2Kindly 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.FloOn Sat, Apr 27, 2019 at 1:45 PM Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:>>>>> "neelaveni" == neelaveni <neelaveni@bksystems.co.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)
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Jozef MlichДата:
Сообщение: Re: crash of postgresql 11.2-2PGDG.rhel7 in StartupXLOG () atxlog.c:6355