Re: Upgrading postgresql-8.0 to 8.1
- From: Tom Allison <tom@xxxxxxxxxxx>
- Date: Sat, 30 Dec 2006 23:47:22 -0500
David Gaudine wrote:
I use postgresql 8.0, but since this is "local/obsolete" in Etch I want to
upgrade to 8.1. I've already done this on a backup system, but I got a
few warnings so I want to make sure I'm doing it right before I do it on
my main system.
Here's what I did that seemed to work but gave some of warnings;
- Install postgresql-8.1 and packages that it depends on
- Stop the 8.1 server (I don't remember if I stopped the 8.0 server)
- pg_dropcluster 8.1 main
- pg_upgradecluster 8.1 main
- start the 8.1 server
Is there a better way?
David
I'm far from guru but one method that might be 'safe' would be to use pgdump to just dump the database, stop 8.0 and load everything into 8.1.
If anything goes wrong, you have all the data in a file so you can at least fix it. I would expect this to be issues with creation of tables/databases at most and not something you have to fix on every line.
--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx
- References:
- Upgrading postgresql-8.0 to 8.1
- From: David Gaudine
- Upgrading postgresql-8.0 to 8.1
- Prev by Date: Re: Making hotplugging my camera work
- Next by Date: new to debian but having installation problems
- Previous by thread: Re: Upgrading postgresql-8.0 to 8.1 (correction)
- Next by thread: sasl2 authentication on postfix
- Index(es):
Relevant Pages
|
|
