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

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: (view raw, whole thread or download thread mbox)
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


seapug by date

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

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