Requirements

I assume default PostgreSQL binary folder is: "C:\SafeQ6\Management\PGSQL" and PostgreSQL data folder is: "C:\SafeQ6\Management\PGSQL-data", same as default installation of YSoft SafeQ Management Server with embedded PostgreSQL database. Please change these folders according to your deployment options.

1. Download PostgreSQL 11 binaries from https://www.enterprisedb.com/download-postgresql-binaries. Select PostgreSQL 11 version according to your operation system.

2. Backup PostgreSQL 9.4 data folder "C:\SafeQ6\Management\PGSQL-data".

A Step-by-step Guide

Follow next steps to upgrade PostgreSQL installation to version 11.

1. Stop PostgreSQL service and all dependent services.
   
   

2. Copy downloaded PostgreSQL 11 binaries into new folder, at example "C:\SafeQ6\Management\PGSQL_11".
   
   

3. Create postgres_password.txt file in current directory and put postgresql user password into the file.
   

4. Initialize new data folder (such as C:\SafeQ6\Management\PGSQL_11-data), run initdb:

   c:\SafeQ6\Management\PGSQL_11\bin\initdb -D "c:/SafeQ6/Management/PGSQL_11-data/" -E utf-8 --auth=md5 -U "postgres" --pwfile="postgres_password.txt"

5. Upgrade PostgreSQL data folder. Before executing pg_upgrade, make sure that Administrator account has granted Full controll permission for both old PGSQL and PGSQL-data directories and new PGSQL_11 and PGSQL_11-data directories.

   C:\SafeQ6\Management\PGSQL_11\bin\pg_upgrade -U postgres -b "C:\SafeQ6\Management\PGSQL/bin" -B "C:\SafeQ6\Management\PGSQL_11/bin" -d "C:\SafeQ6\Management\PGSQL-data" -D "C:\SafeQ6\Management\PGSQL_11-data"

6. Change configuration in postgresql.conf which you required. List of changes to default configuration by default installation of YSoft SafeQ Management Server:

   listen_addresses = '*' port = 5433 max_connections = 120 shared_buffers = 512MB max_prepared_transactions = 20 work_mem = 128MB maintenance_work_mem = 512MB effective_cache_size = 1024MB logging_collector = on log_directory = 'pg_log' autovacuum_naptime = 43min datestyle = 'iso, dmy' default_text_search_config = 'pg_catalog.simple'

7. Test if PostgreSQL will start correctly:

   "C:\SafeQ6\Management\PGSQL_11\bin\pg_ctl.exe" start -D "C:\SafeQ6\Management\PGSQL_11-data" -w

   and stop the service after check:

   "C:\SafeQ6\Management\PGSQL_11\bin\pg_ctl.exe" stop -D "C:\SafeQ6\Management\PGSQL_11-data" -w

8. Remove old PostgreSQL 9.4 folders: "C:\SafeQ6\Management\PGSQL" and "C:\SafeQ6\Management\PGSQL-data".
   
   

9. Rename "C:\SafeQ6\Management\PGSQL_11" to "C:\SafeQ6\Management\PGSQL" and "C:\SafeQ6\Management\PGSQL_11-data" to "C:\SafeQ6\Management\PGSQL-data".
   
   

10. Delete postgres_password.txt file.
    
    

11. Start PostgreSQL service and all dependent services.

Troubleshooting