PostgreSQL – v12 – Installation/Upgrade on MS Windows

Background

PostgreSQL Version 12 was released On October 3rd, 2019.

That is about two weeks ago.

Since then I have wanted to upgrade our Development instance from Version 11 to Version 12.

Release Notes

A brief summary of the Release Notes are available here.

 

Installation

Outline

Here are the steps we will take :-

  1. Artifacts
    • Download artifacts
  2. Shutdown current Instance
    • If postgreSQL instances are running on same box and sharing same network port, please shut them down
  3. Launch installation
    • Through the artifacts start installation
  4. Post Installation Review
    • Review services through MS Windows Service Applet
    • Configuration Files

Artifacts

Artifacts are available from here.

Image

v12.0.1.artifacts.20191018.0947PM.PNG

Explanation

Here are the artifacts available for Version 12

  1. Mac OS X
  2. MS Windows
    • Bitness
      • Windows x86-64
      • Windows x86-32

 

Services Management

To allow graceful installation of the new version, let us go shut down any currently running PostgreSQL instances.

Environment

MS Windows

On MS Windows, we use the services applet ( services.msc ), to manage services start and stop.

Same can be accomplished through the sc.exe utility from the command line.

MS Windows – Services Management ( services.msc )

servicesManagement.01.20191019.0451AM

Installation Steps

Outline

  1. The initial screen is the Welcome Screen
  2. Installation Directory
    • Please choose a directory\folder that matches your organization standard for user application binaries
  3. Select Components
    • Here are the components
      • PostgreSQL Server
        • Yes, we want the server
      • pgAdmin 4
        • Administration Utility
        • Yes
      • Stack Builder
        • GUI for downloading and installing modules
        • Yes
      • Command Line Tools
        • Yes
  4. Data Directory
    • Once again, please choose the folder that your organization has set up for storing data
  5. Password
    • Enter and confirm a password for the postgres user
    • The postgres user is the so called root or administrator user in postgreSQL parlance
  6. Port
    • Network Port
    • PostgreSQL default network port is 5432
  7. Advanced Options
    • Default Locale
      • We chose to use the targeted system’s locale
      • Other locales are available; please review the list
  8. Pre Installation Summary
    • Please review each of your chosen options
  9. Ready to Install
  10. Installing
  11. Complete

Images

Image – Welcome

installStep.welcome.01.PNG

Image – Installation Directory

installStep.installationDirectory.01.PNG

Image – Select Components

installStep.selectComponents.01.PNG

Image – Data Directory

installStep.dataDirectory.01.PNG

Image – Password

installStep.password.02

Image – Port

installStep.port.01.PNG

Image – Advanced Options

installStep.advancedOptions.01

Image – Pre Installation Summary

installStep.preInstallationSummary.01.PNG

Image – Ready to Install

installStep.readToInstall.01.PNG

Image – Installing

installStep.installing.01.PNG

Image – Completing

installStep.complete.01

 

Summary

Installation of PostgreSQL is not a so called upgrade in place.

An install does not bring your current configuration, data, security permissions, extensions with it.

You have to do those thing yourself post an install.

One thought on “PostgreSQL – v12 – Installation/Upgrade on MS Windows

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s