Reg: Postgresql8.3 Using on Ubuntu

Dear sir/mam,
Please share on which Ubuntu version will support the postgresql8.3

Regards,
Neelaveni

On Friday 26 April 2019 03:16 PM, Flo Rance wrote:

postgresql 8.3 has reached end-of-life in 2013. You must definitely
use a more recent version.

https://www.postgresql.org/support/versioning/

Flo

On Fri, Apr 26, 2019 at 11:25 AM neelaveni <neelaveni@bksystems.co.in
<mailto:neelaveni@bksystems.co.in>> wrote:

Dear sir/mam,
Please share on which Ubuntu version will support the
postgresql8.3

Regards,
Neelaveni

Dear sir/mam,
I accept that, but I require the details of which Ubuntu version
support the postgresql8.3
Kindly share it.

Regards,
Neelaveni

On Friday 26 April 2019 03:16 PM, Flo Rance wrote:

postgresql 8.3 has reached end-of-life in 2013. You must definitely use a
more recent version.

https://www.postgresql.org/support/versioning/

Flo

On Fri, Apr 26, 2019 at 11:25 AM neelaveni <neelaveni@bksystems.co.in>
wrote:

Dear sir/mam,
Please share on which Ubuntu version will support the postgresql8.3

Regards,
Neelaveni

On Friday 26 April 2019 05:51 PM, Flo Rance wrote:

All current versions of Ubuntu support postgresql 8.3, but you'll have
to build it from source.

https://www.postgresql.org/docs/8.3/installation.html

On Fri, Apr 26, 2019 at 1:17 PM neelaveni <neelaveni@bksystems.co.in
<mailto:neelaveni@bksystems.co.in>> wrote:

Dear sir/mam,
I accept that, but I require the details of which Ubuntu
version support the postgresql8.3
Kindly share it.

Regards,
Neelaveni

On Friday 26 April 2019 03:16 PM, Flo Rance wrote:

postgresql 8.3 has reached end-of-life in 2013. You must
definitely use a more recent version.

https://www.postgresql.org/support/versioning/

Flo

On Fri, Apr 26, 2019 at 11:25 AM neelaveni
<neelaveni@bksystems.co.in <mailto:neelaveni@bksystems.co.in>> wrote:

Dear sir/mam,
Please share on which Ubuntu version will support the
postgresql8.3

Regards,
Neelaveni

Dear Flo,
Thank you so much for your suggested things.
I've tried to install postgresql 8.3.7 in ubuntu 16.04 using the
source file (postgresql-8.3.7.tar.gz
<https://ftp.postgresql.org/pub/source/v8.3.7/postgresql-8.3.7.tar.gz&gt;)
with the following steps :
./configure
make
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data

logfile 2>&1 &

/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Upto su - postgres all are fine.
But for /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data :
The files belonging to this database system will be owned
by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_IN.
The default database encoding has accordingly been set to
UTF8.
The default text search configuration will be set to
"english".

fixing permissions on existing directory
/usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ...
32MB/204800
creating configuration files ... ok
creating template1 database in
/usr/local/pgsql/data/base/1 ... ok
* initializing pg_authid ... FATAL: wrong number of index
expressions*
* STATEMENT: CREATE TRIGGER pg_sync_pg_database AFTER
INSERT OR UPDATE OR DELETE ON pg_database FOR EACH STATEMENT EXECUTE
PROCEDURE flatfile_update_trigger();*

* child process exited with exit code 1*
* initdb: removing contents of data directory
"/usr/local/pgsql/data"*

* /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile
2>&1 &*
* starts to run on background.*

* But while creating the db, it failed*
*/usr/local/pgsql/bin/createdb test*
* createdb: could not connect to database postgres: could not
connect to server: No such file or directory*
* Is the server running locally and accepting*
* connections on Unix domain socket "/tmp/.s.PGSQL.5432"?*
* [1]+ Exit 2 /usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data > logfile 2>&1*

* While check with log, logfile*
* postgres cannot access the server configuration file
"/usr/local/pgsql/data/postgresql.conf": No such file or directory*

* Kindly help to resolve this.*

Regards,
Neelaveni

On Friday 26 April 2019 05:51 PM, Flo Rance wrote:

All current versions of Ubuntu support postgresql 8.3, but you'll have to
build it from source.

https://www.postgresql.org/docs/8.3/installation.html

On Fri, Apr 26, 2019 at 1:17 PM neelaveni <neelaveni@bksystems.co.in>
wrote:

Dear sir/mam,
I accept that, but I require the details of which Ubuntu version
support the postgresql8.3
Kindly share it.

Regards,
Neelaveni

On Friday 26 April 2019 03:16 PM, Flo Rance wrote:

postgresql 8.3 has reached end-of-life in 2013. You must definitely use a
more recent version.

https://www.postgresql.org/support/versioning/

Flo

On Fri, Apr 26, 2019 at 11:25 AM neelaveni <neelaveni@bksystems.co.in>
wrote:

Dear sir/mam,
Please share on which Ubuntu version will support the postgresql8.3

Regards,
Neelaveni

On Friday 26 April 2019 07:13 PM, Flo Rance wrote:

If you search just a little bit, you'll find that's a known issue.

You should give arguments when you run configure script, but it seems
to depend on you compiler:

./configure CFLAGS="-01"

or

./configure CFLAGS="-01" CC=clang

P.S. Don't forget to run `make clean` before !

Flo

On Fri, Apr 26, 2019 at 2:44 PM neelaveni <neelaveni@bksystems.co.in
<mailto:neelaveni@bksystems.co.in>> wrote:

Dear Flo,
Thank you so much for your suggested things.
I've tried to install postgresql 8.3.7 in ubuntu 16.04 using
the source file (postgresql-8.3.7.tar.gz
<https://ftp.postgresql.org/pub/source/v8.3.7/postgresql-8.3.7.tar.gz&gt;)
with the following steps :
./configure
make
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D
/usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Upto su - postgres all are fine.
But for /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data :
The files belonging to this database system will
be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with
locale en_IN.
The default database encoding has accordingly been
set to UTF8.
The default text search configuration will be set
to "english".

fixing permissions on existing directory
/usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ...
32MB/204800
creating configuration files ... ok
creating template1 database in
/usr/local/pgsql/data/base/1 ... ok
* initializing pg_authid ... FATAL: wrong number
of index expressions**
** STATEMENT: CREATE TRIGGER pg_sync_pg_database
AFTER INSERT OR UPDATE OR DELETE ON pg_database FOR EACH
STATEMENT EXECUTE PROCEDURE flatfile_update_trigger();**
****
** child process exited with exit code 1**
** initdb: removing contents of data directory
"/usr/local/pgsql/data"**
*
* /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data

logfile 2>&1 &**

** starts to run on background.**
**
** But while creating the db, it failed**
****/usr/local/pgsql/bin/createdb test**
** createdb: could not connect to database postgres: could
not connect to server: No such file or directory**
** Is the server running locally and accepting**
** connections on Unix domain socket "/tmp/.s.PGSQL.5432"?**
** [1]+ Exit 2 /usr/local/pgsql/bin/postgres -D
/usr/local/pgsql/data > logfile 2>&1**
**
** While check with log, logfile**
** postgres cannot access the server configuration
file "/usr/local/pgsql/data/postgresql.conf": No such file or
directory**
**
** Kindly help to resolve this.*

Regards,
Neelaveni

On Friday 26 April 2019 05:51 PM, Flo Rance wrote:

All current versions of Ubuntu support postgresql 8.3, but you'll
have to build it from source.

https://www.postgresql.org/docs/8.3/installation.html

On Fri, Apr 26, 2019 at 1:17 PM neelaveni
<neelaveni@bksystems.co.in <mailto:neelaveni@bksystems.co.in>> wrote:

Dear sir/mam,
I accept that, but I require the details of which Ubuntu
version support the postgresql8.3
Kindly share it.

Regards,
Neelaveni

On Friday 26 April 2019 03:16 PM, Flo Rance wrote:

postgresql 8.3 has reached end-of-life in 2013. You must
definitely use a more recent version.

https://www.postgresql.org/support/versioning/

Flo

On Fri, Apr 26, 2019 at 11:25 AM neelaveni
<neelaveni@bksystems.co.in
<mailto:neelaveni@bksystems.co.in>> wrote:

Dear sir/mam,
Please share on which Ubuntu version will support
the postgresql8.3

Regards,
Neelaveni

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

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@tao11.riddles.org.uk <mailto:andrew@tao11.riddles.org.uk>> wrote:

"neelaveni" == neelaveni <neelaveni@bksystems.co.in

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

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

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@bksystems.co.in
<mailto: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 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@tao11.riddles.org.uk
<mailto:andrew@tao11.riddles.org.uk>> wrote:

"neelaveni" == neelaveni <neelaveni@bksystems.co.in

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

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@bksystems.co.in
<mailto: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 -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@bksystems.co.in <mailto: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 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@tao11.riddles.org.uk
<mailto:andrew@tao11.riddles.org.uk>> wrote:

"neelaveni" == neelaveni

<neelaveni@bksystems.co.in
<mailto: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)

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@bksystems.co.in
<mailto:neelaveni@bksystems.co.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@bksystems.co.in <mailto: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 -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@bksystems.co.in
<mailto: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 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@tao11.riddles.org.uk
<mailto:andrew@tao11.riddles.org.uk>> wrote:

"neelaveni" == neelaveni

<neelaveni@bksystems.co.in
<mailto: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)

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

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