Version Upgrade

List available cluster

sudo pg_lsclusters

Merge multiple cluster

Stop new postgres cluster

sudo pg_dropcluster 16 main --stop

Upgrade previous cluster

sudo pg_upgradecluster 15 main

Drop old cluster

sudo pg_dropcluster 15 main

List running clusters

sudo pg_lsclusters

Remove database packages

sudo apt purge postgresql-15 postgresql-client-15

Postgres command prompt

sudo -i -u postgres
> psql

See database list

\list

Remove Postgres

dpkg -l | grep postgres

sudo apt remove --purge postgresql ...

sudo rm -r /etc/postgresql/
sudo rm -r /etc/postgresql-common/
sudo rm -r /var/lib/postgresql/

sudo userdel -r postgres
sudo groupdel postgres