## create a new cluster * it will create new config files under: /etc/postgresql/15/foo * it will create a new database storage under: /var/lib/postgresql/15/test ```console pg_createcluster 15 foo ``` ## delete a cluster ```console pg_dropcluster 15 foo ```

https://medium.com/keeping-code/running-multiple-postgresql-versions-simultaneously-on-macos-linux-90b3d7e08ffd

https://devcoops.com/list-remove-upgrade-postgresql-cluster/olution Step 1. First things first, let’s see how many clusters we got installed on our machine. pg_lsclusters Output: Ver Cluster Port Status Owner Data directory Log file 10 main 5432 online postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log 11 main 5433 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log As we can see, we got two clusters, 10 and 11. Step 2. Let’s say we don’t need cluster 11. Stop and remove PostgreSQL cluster 11. pg_dropcluster 11 main --stop Note(s): If you want only to stop the cluster, use the command: pg_ctlcluster stop 11 main. pg_ctlcluster command supports start/restart/reload operations as well. Step 4. Now, if we want to do an upgrade, always do a backup first. export BCKP_DATE="$(date +%Y_%m_%d-%H:%M)" pg_dumpall -f <backup_dir>/postgres_10_${BCKP_DATE}.sql Step 5. Upgrade cluster 10 to 11. pg_upgradecluster 10 main Step 6. Cluster 10 should be down, so verify it. Ver Cluster Port Status Owner Data directory Log file 10 main 5432 down postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log 11 main 5433 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log Step 7. Now, we have a fresh new PostgreSQL cluster 11. Remove any PostgreSQL 10 packages and package dependencies. sudo apt-get purge postgresql-10 postgresql-client-10 21.06.23

https://devcoops.com/list-remove-upgrade-postgresql-cluster/

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024