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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 4 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

in the 9.0 manual the location was located in

Chapter 24 Backup and Restore, section 24.4 Migration Between Releases

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

2010 January - Upgrading to 8.4.2 from 8.4.1

2009 September - Upgrade procedure when using one-click installer?

share|improve this answer

For the record, running the installer for Windows from Enterprise DB (the default, linked from the Postgres site), at least since the current version Postgres 9.4, you don't have to stop the postgresql service. The installer does that for you. You still need to re-establish connections, if any (most clients do this automatically).

Best refer to the current manual (using the current version of Postgres):

share|improve this answer

Your Answer


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.