Skip to content

upgrading-postgresql.md

Latest commit

 

History

History
59 lines (41 loc) · 1.3 KB

upgrading-postgresql.md

File metadata and controls

59 lines (41 loc) · 1.3 KB
Raw

Upgrading PostgreSQL

For major releases of PostgreSQL, the internal storage format is typically changed, complicating upgrades.

Requirements

  • 350GiB free space

This guide uses examples for Debian, but should apply to any Linux distribution.

Install a New PostgreSQL Version

If you're using Debian (or Ubuntu), make sure you've enabled the PostgreSQL APT repository, which will enable you to install multiple versions.

Install a new PostgreSQL version alongside the existing:

sudo apt install postgresql-15

Upgrade the Schemas

Stop Cardano DB Sync PostgreSQL

sudo systemctl stop postgresql
sudo pkill -f cardano-db-sync

Upgrade the existing schemas

cd /tmp
sudo -u postgres /usr/lib/postgresql/15/bin/pg_upgrade \
  --old-bindir=/usr/lib/postgresql/11/bin \
  --new-bindir=/usr/lib/postgresql/15/bin \
  --old-datadir=/var/lib/postgresql/11/main \
  --new-datadir=/var/lib/postgresql/15/main \
  --old-options="--config_file=/etc/postgresql/11/main/postgresql.conf" \
  --new-options="--config_file=/etc/postgresql/14/main/postgresql.conf"

Start PostgreSQL

sudo systemctl start postgresql

Clean Up

Remove the old PostgreSQL version

sudo -u postgres ./delete-old-cluster.sh
sudo apt remove postgresql