Re: Installing Postgress 8.0.5 in Ubuntu 10.12

Hi all;

Im looking for in information and resources to setup postgresql 8.0.5
in Ubuntu server . tq

On 02/11/2013 03:40 PM, Wan Hashim wrote:
> Hi all;
>
> Im looking for in information and resources to setup postgresql 8.0.5
> in Ubuntu server . tq

Is there a reason you want to install a version that is no longer supported?

Also I believe you mean Ubuntu 12.10, correct?

>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

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 .

tq

On Tue, Feb 12, 2013 at 7:45 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
> On 02/11/2013 03:40 PM, Wan Hashim wrote:
>>
>> Hi all;
>>
>> Im looking for in information and resources to setup postgresql 8.0.5
>> in Ubuntu server . tq
>
>
> Is there a reason you want to install a version that is no longer supported?
>
> Also I believe you mean Ubuntu 12.10, correct?
>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com

--
Regards;

Wan Mohd Hashim Wan Yusoff
Object Expression Sdn Bhd
9-2, Jalan BPP 5/3, Pusat Bandar Putra Permai
Seri Kembangan Selangor
Tel : 03 8940 8385 Fax: 03 5021 9071
Mobile : 012 2055184

On 02/11/2013 04:29 PM, Wan Hashim 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 .

You will probably need to build from source.

Two choices the last release of 8.0.x:

http://www.postgresql.org/ftp/source/v8.0.26/

If you need the exact version:

ftp://ftp-archives.postgresql.org/pub/source/

>
> tq
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

On 2/11/2013 4:29 PM, Wan Hashim wrote:
> our legacy system required postgresql 8.0 to run.

are you sure it requires this old version? most software works with
newer versions with little or no changes.

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

The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
poorly written software.

For OP: Install from source, if you don't need EXACTLY the old 8.0.5
version at least look at the bug fixed version 8.0.latest (28 or so?)

On Mon, Feb 11, 2013 at 6:17 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 2/11/2013 4:29 PM, Wan Hashim wrote:
>>
>> our legacy system required postgresql 8.0 to run.
>
>
>
> are you sure it requires this old version? most software works with newer
> versions with little or no changes.
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

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

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
> poorly written software.

That was 8.3, not 8.1.

regards, tom lane

Wait I think it was 8.2 wasn't it?

On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
>> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
>> poorly written software.
>
> That was 8.3, not 8.1.
>
> regards, tom lane

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

On 02/11/2013 06:59 PM, Scott Marlowe wrote:
> Wait I think it was 8.2 wasn't it?

http://www.postgresql.org/docs/8.3/interactive/release-8-3.html

E.24.2.1. General

Non-character data types are no longer automatically cast to TEXT
(Peter, Tom)

Previously, if a non-character value was supplied to an operator or
function that requires text input, it was automatically cast to text,
for most (though not all) built-in data types. This no longer happens:
an explicit cast to text is now required for all non-character-string
types. For example, these expressions formerly worked:

>
> On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
>>> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
>>> poorly written software.
>>
>> That was 8.3, not 8.1.
>>
>> regards, tom lane
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

On Mon, Feb 11, 2013 at 5:29 PM, Wan Hashim <whashim(at)gmail(dot)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.

On Feb 11, 2013, at 8:18 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> are you sure it requires this old version? most software works with newer versions with little or no changes.

There are some implicit casting changes that broke some of my code
when 8.2 came out. Ever since then there have been no issues for my
applications in updating versions.

Vick Khera wrote:
> There are some implicit casting changes that broke some of my code
> when 8.2 came out.

You mean 8.3, right?

Yours,
Laurenz Albe

On Thu, Feb 14, 2013 at 3:15 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> Vick Khera wrote:
> > There are some implicit casting changes that broke some of my code
> > when 8.2 came out.
>
> You mean 8.3, right?
>

Based on further discussion in this thread, yes.