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