PG Cluster Commands in Ubuntu
The postgresql package for Ubuntu includes some useful commands for managing your database cluster. I learned about these today when we upgraded postgres versions on a digital ocean droplet.
The ones that I learned of were -
-
pg_lsclustersfor listing the available clusters on the machine and their status -
pg_upgradecluster OLD_VERSION CLUSTER_NAMEfor upgrading to a new cluster. If you don't specify the optional-v(new version), it's assumed you want the most recent version you have installed. This handles copying your old conf files to the new version and setting it up on the originally specified port. -
pg_dropcluster VERSION CLUSTER_NAMEfor removing a cluster. Optionally you can specify--stopto force a shutdown and delete. -
pg_createcluster VERSION CLUSTER_NAMEwhich will create a new cluster given the version and name param. The default is to not start this new cluster on creation, but you can optionally specify the--startflag to immediately start the cluster.
https://manpages.ubuntu.com/manpages/trusty/man8/pg_createcluster.8.html https://manpages.ubuntu.com/manpages/trusty/en/man8/pg_dropcluster.8.html https://manpages.ubuntu.com/manpages/trusty/man8/pg_upgradecluster.8.html https://manpages.ubuntu.com/manpages/xenial/en/man1/pg_lsclusters.1.html