How to do minor upgrades? 9.0.0 --> 9.0.1 (or .2)

From: Basil Bourque <basil(dot)list(at)me(dot)com>
To: seapug(at)postgresql(dot)org
Subject: How to do minor upgrades? 9.0.0 --> 9.0.1 (or .2)
Date: 2010-10-24 00:13:36
Message-ID: 2492744C-036D-4930-985C-557F6C0F980D@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: seapug

So 9.0.1 is out, and apparently .2 is in the works.

I currently have installed 9.0.0 on my Mac.

How should I upgrade?

Need I uninstall 9.0.0?

Can I install 9.0.1 over 9.0.0? If so, do I need to shutdown the Postgres server? If so, how do I do that? (The background daemons are auto-launched when I boot my Mac)

If I can install 9.0.1 on top of 9.0.0, can I do the same for 9.0.2? At what point must you uninstall and start fresh?

I know that by default the uninstaller leaves my data files in place.

I don't have anything valuable at stake now, so no big deal at the moment. But I am wondering how you do this in the real world with production servers. I know you would make a backup with 'pgdump'. But after that, what do you do?

If I missed any documentation or guides on this, please point me there.

--Basil Bourque

Responses

Browse seapug by date

  From Date Subject
Next Message Robert Bernier 2010-10-24 05:24:42 Re: How to do minor upgrades? 9.0.0 --> 9.0.1 (or .2)
Previous Message Basil Bourque 2010-10-20 22:03:18 Class announced, day after pgWest, Bruce Momjian on "PostgreSQL Administration"