Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Jonathan EllisDate: 2001-05-16 21:19:05
Subject: orphaned trigger
Previous:From: Peter EisentrautDate: 2001-05-16 20:39:55
Subject: Re: Installation problem on MacOSX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group