Bdtjtk

I've already removed a cluster several times, but it is still showing up in the pg_lsclusters list. What might be wrong?

Here are what I have done to remove this cluster and check if it is indeed removed:

• stop the cluster use pg_ctlcluster 10 3dcitydb stop (this succeeded)


• use pg_dropcluster 10 3dcitydb
  


• use sudo systemctl daemon-reload
  


• delete the data directory (which is /postgres and I checked it is indeed deleted.)

But it seems whatever I try it is still there. Any advice would be helpful. Thanks!

Here is a cleaned command history...

yql@ai4ce-white-ubuntu1804:/data$ sudo pg_ctlcluster 10 3dcitydb stop

[sudo] password for yql: 



yql@ai4ce-white-ubuntu1804:/data$ pg_lsclusters

Ver Cluster  Port Status Owner    Data directory              Log file

10  3dcitydb 5433 down   postgres postgresdb                  /var/log/postgresql/postgresql-10-3dcitydb.log

10  main     5432 online postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log



yql@ai4ce-white-ubuntu1804:/data$ pg_dropcluster 10 3dcitydb

Warning: systemd was not informed about the removed cluster yet. Operations like "service postgresql start" might fail. To fix, run:

  sudo systemctl daemon-reload



yql@ai4ce-white-ubuntu1804:/data$ pg_lsclusters

Ver Cluster  Port Status Owner     Data directory              Log file

10  3dcitydb 5433 down   <unknown> postgresdb                  /var/log/postgresql/postgresql-10-3dcitydb.log

10  main     5432 online postgres  /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log



yql@ai4ce-white-ubuntu1804:/data$ sudo systemctl daemon-reload

yql@ai4ce-white-ubuntu1804:/data$ pg_lsclusters

Ver Cluster  Port Status Owner     Data directory              Log file

10  3dcitydb 5433 down   <unknown> postgresdb                  /var/log/postgresql/postgresql-10-3dcitydb.log

10  main     5432 online postgres  /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log



yql@ai4ce-white-ubuntu1804:/data$ sudo ls /postgresdb

base    pg_commit_ts  pg_logical    pg_notify    pg_serial     pg_stat      pg_subtrans  pg_twophase  pg_wal   postgresql.auto.conf

global  pg_dynshmem   pg_multixact  pg_replslot  pg_snapshots  pg_stat_tmp  pg_tblspc    PG_VERSION   pg_xact  postmaster.opts



yql@ai4ce-white-ubuntu1804:/data$ sudo rm -r /postgresdb



yql@ai4ce-white-ubuntu1804:/data$ pg_lsclusters

Ver Cluster  Port Status Owner     Data directory              Log file

10  3dcitydb 5433 down   <unknown> postgresdb                  /var/log/postgresql/postgresql-10-3dcitydb.log

10  main     5432 online postgres  /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log





yql@ai4ce-white-ubuntu1804:/data$ sudo ls /postgresdb

ls: cannot access '/postgresdb': No such file or directory



yql@ai4ce-white-ubuntu1804:/data$ sudo systemctl daemon-reload



yql@ai4ce-white-ubuntu1804:/data$ pg_lsclusters

Ver Cluster  Port Status Owner     Data directory              Log file

10  3dcitydb 5433 down   <unknown> postgresdb                  /var/log/postgresql/postgresql-10-3dcitydb.log

10  main     5432 online postgres  /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log