Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the recommended way to perform an upgrade from PostgreSQL 9.3.0 to 9.3.1 (minor upgrade) using the Enterprise DB built windows installer? Should I uninstall first or just install over the existing installation?

The current installation was performed with postgresql-9.3.0-1-windows-x64.exe. Now I want to upgrade using postgresql-9.3.1-1-windows-x64.exe.

share|improve this question
    
As per the documentation: stop the server , install the new binaries, and restart. It is always a good idea to take a backup, and generally, to have a plan B. –  dezso Nov 4 '13 at 22:35
    
Thanks for the link @dezso, I had read that section of the 9.3 manual but found it a bit vague, especially with regard to the Windows setup binaries. –  buzz3791 Nov 6 '13 at 18:26
add comment

1 Answer

up vote 2 down vote accepted

On Windows, simply stopping the postgresql service, then running postgresql-9.3.1-1-windows-x64.exe on top of the existing 9.3.0 works. No uninstall necessary. Of course, a backup is recommended.

Clear, explcit documentation for the update procedure on Windows is absent. Note that the documentation link provided by @dezso has been moved in the 9.3 manual to

Chapter 17 Server Setup and Operation, section 17.6 Upgrading a PostgreSQL Cluster http://www.postgresql.org/docs/9.3/static/upgrading.html

in the 9.0 manual the location was located in

Chapter 24 Backup and Restore, section 24.4 Migration Between Releases http://www.postgresql.org/docs/9.0/static/migration.html

The best source of Windows installer information was the Enterprise DB forums. Here are some posting I found that addressed the question...

2010 April - What's the right way to upgrade to a new version of PostgreSQL http://forums.enterprisedb.com/posts/list/2246.page#8336

2010 January - Upgrading to 8.4.2 from 8.4.1 http://forums.enterprisedb.com/posts/list/2115.page#7888

2009 September - Upgrade procedure when using one-click installer? http://forums.enterprisedb.com/posts/list/1906.page#6790

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.