I need to re-build a cluster due to some incorrect parameters set when it was first created. In particular every database in the cluster is set to
en_GB.UTF8 and needs to be changed to
I'm comfortable with backup up the cluster with
pg_dumpall, creating a new cluster with the correct configuration parameters and then restoring the backup to the new cluster.
To keep the risk as low as possible I would like to leave the existing cluster as unchanged as possible so that it can be started on request, but does NOT auto start on a call such as
sudo service postgresql start. There is easily enough disk space to do this. Edit: To be clear on this I want to leave the old cluster installed, just not started.
How can I leave the cluster in place, but not have it started automatically along with the new (correctly configured) replacement? That is, how do I stop PostgreSQL from starting the old cluster, even though it is starts the new one?