From: Evan Rempel <erempel@uvic.ca>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Upgrade in same major version
Date: Tue, 14 Oct 2008 10:22:28 -0700
Message-ID: <48F4D554.8090507@uvic.ca> (raw)
In-Reply-To: <5A6C6B35-B5FF-4C4A-B976-A5B4522AB6B3@indiana.edu>
References: <5A6C6B35-B5FF-4C4A-B976-A5B4522AB6B3@indiana.edu>
What this means is that you do not have to "update" the data repository (wherever your
postgresql database is stored). All that needs to be done is to uninstall the old version,
and install the new version. Start the new version and use the data where it sits.
Now, that all sound fine when I say it fast. There are a number of precautions that
you may prefer to take, and the steps may differ significantly depending on your system.
1. Probably take a complete backup of your database should something go wrong.
2. Ensure that you have a way to "get back" to the previous version, or have
a very reliable way to move forward, such as taking a pgdump that can be loaded
back into the database, nearly regardless of version.
3. Your uninstall may be a package management step such as rpm, or you may
just delete the files if your install was done from source.
4. Your install may be a package management step such as rpm, or you may
require a "sudo make install" if your install was done from source.
I hope this points you in mostly the right direction without begin to long
winded.
Evan.
Carol Walter wrote:
> Hello,
>
> I'm doing an upgrade from 8.2.4 to 8.2.10. The documentation says,
> "When you update between compatible versions, you can simply replace
> the executables and reuse the data directory on disk." I guess I
> don't quite understand what this means. Replace them by running some
> parts of the installation process? Replace them by copying them.
> Are you talking about those files that usually reside in /usr/local/
> pgsql/bin and include psql and pg_ctl?
>
> I know these may seem like dumb questions to those of you who are old
> hands at this. I'd be glad to read more documentation if there is
> some that is more explicit than what I quoted above.
>
> Thanks so much,
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
--
Evan Rempel erempel@uvic.ca
Senior Programmer Analyst 250.721.7691
University Systems, University of Victoria
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: erempel@uvic.ca
Subject: Re: Upgrade in same major version
In-Reply-To: <48F4D554.8090507@uvic.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox