Postgres older version 8.3.7 on ubuntu 14

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgres older version 8.3.7 on ubuntu 14

Vaidyanathaswamy, Anandsaikrishnan

Good Morning,

 

We have older version of postgres 8.3.7, I am trying to install postgres  on ubuntu 14.04 LTS under GCP instance, Im having difficulty in installating the postgres 8.3.7 .

 

We are not able proceed with the installation manually. I am wondering whether ubuntu 14 is compatible with version 8.3.7

 

root@postgres83ubuntu:/home/rsa-key-20181011/postgresql-8.3.7# ./configure

checking build system type... x86_64-unknown-linux-gnu

checking host system type... x86_64-unknown-linux-gnu

checking which template to use... linux

checking whether to build with 64-bit integer date/time support... no

checking whether NLS is wanted... no

checking for default port number... 5432

checking for gcc... no

checking for cc... no

configure: error: no acceptable C compiler found in $PATH

 

 

See `config.log' for more details.

 

 

I am able to perform the 8.4 version with the following documents.

 

https://erpnani.blogspot.com/2016/03/install-postgresql-84-from-its-official.html

 

 

Do you recommend any such document,

 

Your help is much appreciated.

 

Thanks !

sai

******************************************************************************************
This message may contain confidential or proprietary information intended only for the use of the
addressee(s) named above or may contain information that is legally privileged. If you are
not the intended addressee, or the person responsible for delivering it to the intended addressee,
you are hereby notified that reading, disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please immediately notify us by 
replying to the message and delete the original message and any copies immediately thereafter.

Thank you.
******************************************************************************************
CLLD

Reply | Threaded
Open this post in threaded view
|

Re: Postgres older version 8.3.7 on ubuntu 14

Steve Crawford


On Tue, Oct 23, 2018 at 10:08 AM Vaidyanathaswamy, Anandsaikrishnan <[hidden email]> wrote:

Good Morning,

 

We have older version of postgres 8.3.7, I am trying to install postgres  on ubuntu 14.04 LTS under GCP instance, Im having difficulty in installating the postgres 8.3.7 .

 

We are not able proceed with the installation manually. I am wondering whether ubuntu 14 is compatible with version 8.3.7

 

root@postgres83ubuntu:/home/rsa-key-20181011/postgresql-8.3.7# ./configure

checking build system type... x86_64-unknown-linux-gnu

checking host system type... x86_64-unknown-linux-gnu

checking which template to use... linux

checking whether to build with 64-bit integer date/time support... no

checking whether NLS is wanted... no

checking for default port number... 5432

checking for gcc... no

checking for cc... no

configure: error: no acceptable C compiler found in $PATH

 



First, I would *strongly* suggest upgrading to a newer version for security, performance and support.

But if you insist on compiling, the answer is in your output - it isn't finding a compiler. Be sure to install gcc or other compiler.

Cheers,
Steve
 
Reply | Threaded
Open this post in threaded view
|

Re: Postgres older version 8.3.7 on ubuntu 14

Chapman Flack
On 10/23/18 13:15, Steve Crawford wrote:
> On Tue, Oct 23, 2018 at 10:08 AM Vaidyanathaswamy, Anandsaikrishnan <
> [hidden email]> wrote:

>> We are not able proceed with the installation manually. I am wondering
>> whether ubuntu 14 is compatible with version 8.3.7
...
> First, I would *strongly* suggest upgrading to a newer version for
> security, performance and support.
>
> But if you insist on compiling, the answer is in your output - it isn't
> finding a compiler. Be sure to install gcc or other compiler.

It would certainly be interesting to know why such an old version is
needed. Also, even if it has to be 8.3 for some reason, does it have to be
8.3.7 and not the last maintenance release 8.3.23 ?

I have found that to build 8.3 or 8.2 using modern gcc, it is necessary
to add a C flag -fno-aggressive-loop-optimizations

as in

   $ CFLAGS=-fno-aggressive-loop-optimizations  ./configure

But of course, that comes after the first problem, installing a C compiler
in the first place. :)

Alternatively, you can build from the git commit exactly one later than
the one tagged REL8_3_23. That commit just adds the extra C flag.

-Chap

Reply | Threaded
Open this post in threaded view
|

RE: Postgres older version 8.3.7 on ubuntu 14

Vaidyanathaswamy, Anandsaikrishnan
Thank you so much for your prompt reply,

Background on  this, We have postgres same version for the past 12 years with 8.3.7, We are moving to cloud GCP
To start with testing the 8.3.7 on ubuntu 14.04 LTS version, I am finding difficulty in installing the 8.3.7 version, Here is the latest error,


checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... no
checking whether NLS is wanted... no
checking for default port number... 5432
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking if gcc supports -Wdeclaration-after-statement... yes
checking if gcc supports -Wendif-labels... yes
checking if gcc supports -fno-strict-aliasing... yes
checking if gcc supports -fwrapv... yes
configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
checking whether to build with Tcl... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build with GSSAPI support... no
checking whether to build with Kerberos 5 support... no
checking whether to build with PAM support... no
checking whether to build with LDAP support... no
checking whether to build with Bonjour support... no
checking whether to build with OpenSSL support... no
checking for egrep... grep -E
configure: using CPPFLAGS= -D_GNU_SOURCE
configure: using LDFLAGS=
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for ranlib... ranlib
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for tar... /bin/tar
checking whether ln -s works... yes
checking for gawk... gawk
checking for bison... no
configure: WARNING:
*** Without Bison you will not be able to build PostgreSQL from CVS nor
*** change any of the parser definition files.  You can obtain Bison from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this, because the Bison
*** output is pre-generated.)  To use a different yacc program (possible,
*** but not recommended), set the environment variable YACC before running
*** 'configure'.
checking for flex... no
configure: WARNING:
*** Without Flex you will not be able to build PostgreSQL from CVS or
*** change any of the scanner definition files.  You can obtain Flex from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
checking for perl... /usr/bin/perl
checking for main in -lm... yes
checking for library containing setproctitle... no
checking for library containing dlopen... -ldl
checking for library containing socket... none required
checking for library containing shl_load... no
checking for library containing getopt_long... none required
checking for library containing crypt... -lcrypt
checking for library containing fdatasync... none required
checking for library containing shmget... none required
checking for -lreadline... no
checking for -ledit... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure.  It is possible the compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.
root@postgres83ubuntu:/home/rsa-key-20181011/postgresql-8.3.7# CFLAGS=-fno-aggressive-loop-optimizations  ./configure --prefix /usr/local/pgsql
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... no
checking whether NLS is wanted... no
checking for default port number... 5432
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking if gcc supports -Wdeclaration-after-statement... yes
checking if gcc supports -Wendif-labels... yes
checking if gcc supports -fno-strict-aliasing... yes
checking if gcc supports -fwrapv... yes
configure: using CFLAGS=-fno-aggressive-loop-optimizations -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
checking whether to build with Tcl... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build with GSSAPI support... no
checking whether to build with Kerberos 5 support... no
checking whether to build with PAM support... no
checking whether to build with LDAP support... no
checking whether to build with Bonjour support... no
checking whether to build with OpenSSL support... no
checking for egrep... grep -E
configure: using CPPFLAGS= -D_GNU_SOURCE
configure: using LDFLAGS=
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for ranlib... ranlib
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for tar... /bin/tar
checking whether ln -s works... yes
checking for gawk... gawk
checking for bison... no
configure: WARNING:
*** Without Bison you will not be able to build PostgreSQL from CVS nor
*** change any of the parser definition files.  You can obtain Bison from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this, because the Bison
*** output is pre-generated.)  To use a different yacc program (possible,
*** but not recommended), set the environment variable YACC before running
*** 'configure'.
checking for flex... no
configure: WARNING:
*** Without Flex you will not be able to build PostgreSQL from CVS or
*** change any of the scanner definition files.  You can obtain Flex from
*** a GNU mirror site.  (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
checking for perl... /usr/bin/perl
checking for main in -lm... yes
checking for library containing setproctitle... no
checking for library containing dlopen... -ldl
checking for library containing socket... none required
checking for library containing shl_load... no
checking for library containing getopt_long... none required
checking for library containing crypt... -lcrypt
checking for library containing fdatasync... none required
checking for library containing shmget... none required
checking for -lreadline... no
checking for -ledit... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure.  It is possible the compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.

-----Original Message-----
From: Chapman Flack <[hidden email]>
Sent: Tuesday, October 23, 2018 10:28 AM
To: Steve Crawford <[hidden email]>; Vaidyanathaswamy, Anandsaikrishnan <[hidden email]>
Cc: [hidden email]
Subject: Re: Postgres older version 8.3.7 on ubuntu 14

[External Content] This message is from an external source. Please exercise caution when opening attachments or links.

On 10/23/18 13:15, Steve Crawford wrote:
> On Tue, Oct 23, 2018 at 10:08 AM Vaidyanathaswamy, Anandsaikrishnan <
> [hidden email]> wrote:

>> We are not able proceed with the installation manually. I am
>> wondering whether ubuntu 14 is compatible with version 8.3.7
...
> First, I would *strongly* suggest upgrading to a newer version for
> security, performance and support.
>
> But if you insist on compiling, the answer is in your output - it
> isn't finding a compiler. Be sure to install gcc or other compiler.

It would certainly be interesting to know why such an old version is needed. Also, even if it has to be 8.3 for some reason, does it have to be
8.3.7 and not the last maintenance release 8.3.23 ?

I have found that to build 8.3 or 8.2 using modern gcc, it is necessary to add a C flag -fno-aggressive-loop-optimizations

as in

   $ CFLAGS=-fno-aggressive-loop-optimizations  ./configure

But of course, that comes after the first problem, installing a C compiler in the first place. :)

Alternatively, you can build from the git commit exactly one later than the one tagged REL8_3_23. That commit just adds the extra C flag.

-Chap
******************************************************************************************
This message may contain confidential or proprietary information intended only for the use of the
addressee(s) named above or may contain information that is legally privileged. If you are
not the intended addressee, or the person responsible for delivering it to the intended addressee,
you are hereby notified that reading, disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please immediately notify us by  
replying to the message and delete the original message and any copies immediately thereafter.

Thank you.
******************************************************************************************
CLLD
Reply | Threaded
Open this post in threaded view
|

Re: Postgres older version 8.3.7 on ubuntu 14

Chapman Flack
On 10/23/18 1:51 PM, Vaidyanathaswamy, Anandsaikrishnan wrote:

> configure: error: readline library not found
> If you have readline already installed, see config.log for details on the
> failure.  It is possible the compiler isn't looking in the proper directory.
> Use --without-readline to disable readline support.

The missing library provides features like previous command recall
and editing in psql. If those features are valuable to you, you can
install the readline library; otherwise, you can add --without-readline
on the configure command, and build PostgreSQL without it.

-Chap