Обсуждение: Upgrading to Postgresql 8 on RHEL 3 (Release 9 Shrike)

I am a Linux Newbie.  Never installed software on Linux OS before.  I
need to upgrade an existing Postgresql 7.3.4-3 running on RHEL 3 to
Postgresql 8.
 From my research so far I do not believe that this configuration is
supported.  I have not been able to find the RPM files.
Is this upgrade possible?  If so where can I find the downloads that I
need.

Fred Moseley <fredmoseley@sbcglobal.net> writes:
> I am a Linux Newbie.  Never installed software on Linux OS before.  I
> need to upgrade an existing Postgresql 7.3.4-3 running on RHEL 3 to
> Postgresql 8.
>  From my research so far I do not believe that this configuration is
> supported.  I have not been able to find the RPM files.

I don't think you'll find any prebuilt RPMs for that combination.
In principle you could build them yourself, but it might be a bit
daunting for a newbie.  Is there a reason you have to use RHEL3
rather than something newer?

PG 7.3 to 8.anything is not going to be a drop-in, fire-and-forget
replacement anyway; you will be *very* well advised to plan on
application compatibility testing, and you'll need a database
dump and reload.  So what might be a sane approach is to set up
a new server with a newer OS and a new database beside the old one
as an interim step, and migrate over once you're satisfied with
your testing.

            regards, tom lane

Thanx Tom.  I was hoping the upgrade would be the path of least
resistance.
As the existing db is a test db populated with data.
I will take your advice and setup a new db and do a dump and reload.

On May 1, 2009, at 10:46 AM, Tom Lane wrote:

> Fred Moseley <fredmoseley@sbcglobal.net> writes:
>> I am a Linux Newbie.  Never installed software on Linux OS before.  I
>> need to upgrade an existing Postgresql 7.3.4-3 running on RHEL 3 to
>> Postgresql 8.
>> From my research so far I do not believe that this configuration is
>> supported.  I have not been able to find the RPM files.
>
> I don't think you'll find any prebuilt RPMs for that combination.
> In principle you could build them yourself, but it might be a bit
> daunting for a newbie.  Is there a reason you have to use RHEL3
> rather than something newer?
>
> PG 7.3 to 8.anything is not going to be a drop-in, fire-and-forget
> replacement anyway; you will be *very* well advised to plan on
> application compatibility testing, and you'll need a database
> dump and reload.  So what might be a sane approach is to set up
> a new server with a newer OS and a new database beside the old one
> as an interim step, and migrate over once you're satisfied with
> your testing.
>
>             regards, tom lane