Re: 7.1 Upgrade Failure

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: "Schroeder, Steve" <schroeder(at)LATHAM(dot)com>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: 7.1 Upgrade Failure
Date: 2001-05-16 20:40:16
Message-ID: 01051616401600.00929@lowen.wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tuesday 15 May 2001 11:25, Schroeder, Steve wrote:
> To Whom It May Concern:
> 5.) Stopped all the current postgres services, etc,.
> 6.) Ran the install version off postgresql.org site.
> 7.) One note that might be of interest is Red Hat's install put the
> pgsql directory in /var/lib/pgsql
> 8.) The install for 7.1 is /usr/local/pgsql.
> 9.) Tried to even rename the /var/lib/pgsql and install new in that
> directory, but got corruption errors looking for files in /usr/local/pgsql.

You have to do a 'dump/initdb/restore' cycle, as inconvenient as it may be.

Restore your 6.5 installation.

Then, run pg_dumpall and place the resulting ASCII dump somewhere you can
find it.

Now, install 7.1, either from RPM (which is available) or from source. You
will need to go through the initdb portion of the installation document.

Now, follow the instructions on upgrading, beginning with the restore process
- -- this is part of the documentation.
- --
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7AuW05kGGI8vV9eERAt9eAJ9sbvYmzbQxc8RZ5yGPdv9rkY1hggCgkLNj
V1Ktud47qR0sb0N5YcVgadE=
=Z1eF
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jonathan Ellis 2001-05-16 21:19:05 orphaned trigger
Previous Message Peter Eisentraut 2001-05-16 20:39:55 Re: Installation problem on MacOSX