Showing paste #Owys:

uf@lorazepam:~$ sudo pg_upgradecluster 9.5 main
[sudo] password for uf: 
Stopping old cluster...
Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop operation
pg_ctl: server does not shut down
HINT: The "-m fast" option immediately disconnects sessions rather than
waiting for session-initiated disconnection.
Error: Could not stop old cluster
uf@lorazepam:~$ sudo pg_upgradecluster 9.5 main
Stopping old cluster...
Notice: extra pg_ctl/postgres options given, bypassing systemctl for stop operation
Disabling connections to the old cluster during upgrade...
Restarting old cluster with restricted connections...
Redirecting start request to systemctl
Configuring already existing cluster (configuration: /etc/postgresql/9.6/main, data: /var/lib/postgresql/9.6/main, owner: 122:129)
Error: move_conffile: required configuration file /var/lib/postgresql/9.6/main/postgresql.conf does not exist
Error: Could not create target cluster
uf@lorazepam:~$ sudo pg_createcluster 9.6 main
Configuring already existing cluster (configuration: /etc/postgresql/9.6/main, data: /var/lib/postgresql/9.6/main, owner: 122:129)
Error: move_conffile: required configuration file /var/lib/postgresql/9.6/main/postgresql.conf does not exist
uf@lorazepam:~$ 


____________________
pg_lsclusters 
Ver Cluster Port Status Owner    Data directory                Log file
9.5 main    5432 online postgres /home/postgresqlData/9.5/main /var/log/postgresql/postgresql-9.5-main.log
Make a new paste