#v3.8.2 Upgrade Guide

The upgrade to Core 3.8.2 is as straightforward as running ark update to get on the latest version. However, Since PostgreSQL versions below 14 are performing poorly with custom query plans, we recommend upgrading to a newer PostgreSQL version

Upgrading a complex software project always comes at the risk of breaking something, so make sure you have a backup.

#Upgrade Steps

The procedure below gives you the exact steps needed for the upgrade to the latest PostgreSQL version.

#Step 1. Stop Core and install latest PostgreSQL

1pm2 stop all
2curl -sL https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /usr/share/keyrings/pgdg.gpg >/dev/null
3echo "deb [signed-by=/usr/share/keyrings/pgdg.gpg] http://apt.postgresql.org/pub/repos/apt $(grep DISTRIB_CODENAME /etc/lsb-release | cut -d'=' -f2)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
4sudo apt-get update && sudo apt-get install postgresql -y

#Step 2. Drop the default new PostgreSQL cluster created with the install and perform the upgrade process

1sudo pg_dropcluster --stop $(pg_lsclusters -h | awk 'NR==2' | awk '{print $1}') main
2sudo pg_upgradecluster $(pg_lsclusters -h | awk '{print $1}') main

#Step 3. Make sure you are able to list DBs

1PGUSER=$(grep CORE_DB_USER .config/ark-core/mainnet/.env | cut -d'=' -f2)
2PGPASSWORD=$(grep CORE_DB_PASSWORD .config/ark-core/mainnet/.env | cut -d'=' -f2)
3psql -l

• You should see your ARK DB.

#Step 4. Remove the old PostgreSQL version and PG cluster

1sudo apt-get purge postgresql-contrib postgresql-$(pg_lsclusters -h | awk 'NR==1' | awk '{print $1}') -y

#Step 5. Finally restart your new PostgreSQL and start Core

1sudo systemctl restart postgresql
2pm2 start all

#Reporting Problems

If you happen to experience any issues please open an issue with a detailed description of the problem, steps to reproduce it and info about your environment.