Thread: Re: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12

I believe the software can work with any postgresql 8.0.* . It is possible to install pg 8.0  in current release of linux?

Sent from my HTC

----- Reply message -----
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Wan Hashim" <whashim@gmail.com>
Cc: "Adrian Klaver" <adrian.klaver@gmail.com>, <pgsql-general@postgresql.org>
Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
Date: Tue, Feb 12, 2013 11:44 am


On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim <whashim@gmail.com> wrote:
> our legacy system required postgresql 8.0 to run. we are in the
> process of upgrading the application and database.
> we must have postgresql 8.8 to keep the system running at this moment .
> if possible , we want to run in Ubuntu 12. we can consider older
> version of OS if it can help .

If you can at least look at going to 8.0.26.  there's almost 5 year of
bug fixes in 8.0.26 missing frm 8.0.5, many of them data corruption
bugs you really don't want to run into.

Not from a package.  I don't think any recent distros have a repo with
8.0 in it, so you'll have to build from source.  HOWEVER, building
from source is REAL easy with postgresql.

sudo apt-get install build-essential  # ubuntu build tools
apt-get install libreadline-dev  # used by pgsql to have an editable
command line
tar xvzf postgresql-8.0.26.tar.gz
cd postgresql-8.0.26
./configure --prefix=/opt/postgres    # or wherever you want pg to install
make
sudo make install

tada!  source install.  Note that you might need whatever tools you
use to build software on your distro.  On Ubuntu it's called
build-essential not sure what it's called on other distros.

On Tue, Feb 12, 2013 at 12:19 AM, whashim@gmail.com <whashim@gmail.com> wrote:
> I believe the software can work with any postgresql 8.0.* . It is possible
> to install pg 8.0  in current release of linux?
>
> Sent from my HTC
>
>
> ----- Reply message -----
> From: "Scott Marlowe" <scott.marlowe@gmail.com>
> To: "Wan Hashim" <whashim@gmail.com>
> Cc: "Adrian Klaver" <adrian.klaver@gmail.com>,
> <pgsql-general@postgresql.org>
> Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
> Date: Tue, Feb 12, 2013 11:44 am
>
>
> On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim <whashim@gmail.com> wrote:
>> our legacy system required postgresql 8.0 to run. we are in the
>> process of upgrading the application and database.
>> we must have postgresql 8.8 to keep the system running at this moment .
>> if possible , we want to run in Ubuntu 12. we can consider older
>> version of OS if it can help .
>
> If you can at least look at going to 8.0.26.  there's almost 5 year of
> bug fixes in 8.0.26 missing frm 8.0.5, many of them data corruption
> bugs you really don't want to run into.



--
To understand recursion, one must first understand recursion.

second line should be

sudo apt-get install libreadline-dev

of course.  unless you're logged in as root.

On Tue, Feb 12, 2013 at 12:26 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> Not from a package.  I don't think any recent distros have a repo with
> 8.0 in it, so you'll have to build from source.  HOWEVER, building
> from source is REAL easy with postgresql.
>
> sudo apt-get install build-essential  # ubuntu build tools
> apt-get install libreadline-dev  # used by pgsql to have an editable
> command line
> tar xvzf postgresql-8.0.26.tar.gz
> cd postgresql-8.0.26
> ./configure --prefix=/opt/postgres    # or wherever you want pg to install
> make
> sudo make install
>
> tada!  source install.  Note that you might need whatever tools you
> use to build software on your distro.  On Ubuntu it's called
> build-essential not sure what it's called on other distros.
>
> On Tue, Feb 12, 2013 at 12:19 AM, whashim@gmail.com <whashim@gmail.com> wrote:
>> I believe the software can work with any postgresql 8.0.* . It is possible
>> to install pg 8.0  in current release of linux?
>>
>> Sent from my HTC
>>
>>
>> ----- Reply message -----
>> From: "Scott Marlowe" <scott.marlowe@gmail.com>
>> To: "Wan Hashim" <whashim@gmail.com>
>> Cc: "Adrian Klaver" <adrian.klaver@gmail.com>,
>> <pgsql-general@postgresql.org>
>> Subject: [GENERAL] Installing Postgress 8.0.5 in Ubuntu 10.12
>> Date: Tue, Feb 12, 2013 11:44 am
>>
>>
>> On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim <whashim@gmail.com> wrote:
>>> our legacy system required postgresql 8.0 to run. we are in the
>>> process of upgrading the application and database.
>>> we must have postgresql 8.8 to keep the system running at this moment .
>>> if possible , we want to run in Ubuntu 12. we can consider older
>>> version of OS if it can help .
>>
>> If you can at least look at going to 8.0.26.  there's almost 5 year of
>> bug fixes in 8.0.26 missing frm 8.0.5, many of them data corruption
>> bugs you really don't want to run into.
>
>
>
> --
> To understand recursion, one must first understand recursion.



--
To understand recursion, one must first understand recursion.

On 2/11/2013 11:26 PM, Scott Marlowe wrote:
> ./configure --prefix=/opt/postgres    # or wherever you want pg to install

and depending on your application's requirements, you may want to enable
perl, python or whatever and whatever other optional stuff you may need..

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast