[edit on GitHub]

Upgrade Matrix

Upgrade Supermarket

Database Preparation

Upgrade Steps

External PostgreSQL

The External PostgreSQL upgrade steps are provided as a courtesy. It is the responsibility of the user to upgrade and maintain any External PostgreSQL configurations.

Follow these steps to upgrade the PostgreSQL major version.

Upgrade Supermarket

Do we need to upgrade Supermarket first?

Backup PostgreSQL Database

1. Stop the Supermarket application

sudo supermarket-ctl stop

1. Start the Supermarket PostgreSQL service

sudo supermarket-ctl start postgresql

1. Back up the PostgreSQL database

/opt/supermarket/embedded/bin/pg_dumpall -U supermarket -p 15432 > /tmp/supermarket-dump.sql

1. Vacuum the PostgreSQL database:

/opt/supermarket/embedded/bin/vacuumdb --all --full -p 15432

1. Reindex the PostgreSQL database:

/opt/supermarket/embedded/bin/reindexdb --all -p 15432

1. Restart the Supermarket application

supermarket-ctl restart

Recovering from Upgrade Failures

If either the vacuumdb or reindexdb commands fail

1. Drop the Supermarket PostgreSQL database

/opt/supermarket/embedded/bin/psql -U supermarket -d postgres -p 15432 -c "drop database supermarket"

1. Recreate the Supermarket PostgreSQL database

/opt/supermarket/embedded/bin/psql -U supermarket -d postgres -p 15432 -c "create database supermarket"

1. Restore Supermarket PostgreSQL database from the existing dump.sql file

/opt/supermarket/embedded/bin/psql -U supermarket -d supermarket -p 15432 -f /tmp/supermarket-dump.sql

1. Restart the Supermarket application

supermarket-ctl restart