Re: Replacing rpm installation with tarball - Mailing list pgsql-general

Hello,
    You cannot upgrade from 7.2 to 7.3. There are a number of reasons and
therefore the safest course of action is to pg_dump the 7.2 database and
then uninstall 7.2. Then install your 7.3.x release. I believe you
should be aiming for at least 7.3.2.

As quoted from an older email about 7.3 the initial 7.3 release.
<QUOTE>
"There are significant changes in this RPM from previous releases.  Most
significantly there is experimental support for multiple postmasters,
courtesy Karl DeBisschop.  Next most significantly, upgrading the server
subpackage from a previous major version IS NOT SUPPORTED.  AT ALL.  If
an
rpm -U works for you without you going through odd RPM measures for
postgresql-server-7.3-1PGDG.i386.rpm, then I've made an error somewhere,
because the upgrade lock worked here :-).

Upgrading must be done by dumping the old database out, rpm -e the old
server
subpackage, install the new server subpackage, start the new postmaster
(initdb is automatic on first start when using the supplied initscript),
and
restore your data.  Upgrading the remainder of the subpackages IS
supported
-- you may upgrade everything but the server subpackage, migrate your
data,
and do the dump/restore dance."
</QUOTE>

To build 7.3.x from src you'll want a wide range on libraries. Often
discover they are missing a devel library or two. There is a common one,
that I too was missing, but it's been a while and I've forgotten which
one it was. If anyone else can remember...?

Other than that. Good luck.

Regards Hadley.


On Sat, 2003-03-08 at 14:00, Rich Shepard wrote:
>   I cannot upgrade the existing 7.2.1 installation with the 7.3.2 rpms that
> Lamar put together. He's looking at the error message to see if it gives him
> any idea of what went wrong.
>
>   While I'm running RH 7.3 here, I thing the most expiditious solution is to
> build from source and install over the current binaries. Is there anything
> of which I need to be aware before doing this?
>
> TIA,
>
> Rich
>
> Dr. Richard B. Shepard, President
>
>                        Applied Ecosystem Services, Inc. (TM)
>             2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
>  + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
>                          http://www.appl-ecosys.com/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley.willan@deeperdesign.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.