Move PostgreSQL data files, change cluster location

Show PostgreSQL Data Clusters

pg_lsclusters

Move Clusters to a New Path, Keep All Data

$[path]$

copy the data files

sudo service postgresql stop

sudo mkdir -p $path$/12
sudo chown -R postgres:postgres $path$
sudo cp -R /var/lib/postgresql/12/main $path$/12/
sudo mv /var/lib/postgresql/12/main /var/lib/postgresql/12/main_old

change the config

sudo $texteditor$ /etc/postgresql/10/main/postgresql.conf

data_directory = '$path$/12/main'

start postgres and test

sudo service postgresql start
pg_lsclusters

delete old data files

sudo rm -rf /var/lib/postgresql/12/main_old

Change Clusters to a New Path, LOSE ALL THE DATA

$[path]$

ALL THE DATA WILL BE LOSE!!! {class=red-text}

sudo mkdir -p $path$/12/main
sudo chown -R postgres:postgres $path$
 
sudo pg_dropcluster --stop 12 main
sudo pg_createcluster -d $path$/12/main --locale en_US.UTF-8 --start 12 main
pg_lsclusters