How to safely remove a corrupted cluster? - Mailing list pgsql-general

From Marco Ippolito
Subject How to safely remove a corrupted cluster?
Date
Msg-id CAFegzBTuuhdf9gjga_aBvL+HJzk06KCtohqiNZGdNO5jVnuv5A@mail.gmail.com
Whole thread Raw
Responses Re: How to safely remove a corrupted cluster?
List pgsql-general
If the saying "to learn you have to make mistakes", I'm "learning"...:

I removed a cluster's folder without using pg_dropcluster... sio now I have a corrupted cluster. How can I safely remove it?

(base) marco@pc:~$ pg_lsclusters
Ver Cluster Port Status Owner     Data directory                 Log file
11  fabmnet 5433 down   <unknown> /var/lib/postgresql/11/fabmnet /var/log/postgresql/postgresql-11-fabmnet.log
11  main    5432 online postgres  /var/lib/postgresql/11/main    /var/log/postgresql/postgresql-11-main.log

(base) marco@pc:~$ pg_dropcluster 11 fabmnet
Warning: corrupted cluster: data directory does not exist
Warning: systemd was not informed about the removed cluster yet. Operations like "service postgresql start" might fail. To fix, run:
  sudo systemctl daemon-reload
(base) marco@pc:~$ sudo systemctl daemon-reload
[sudo] password for marco:
(base) marco@pc:~$ pg_dropcluster 11 fabmnet
Warning: corrupted cluster: data directory does not exist
Warning: systemd was not informed about the removed cluster yet. Operations like "service postgresql start" might fail. To fix, run:
  sudo systemctl daemon-reload

Marco

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: PGPASSWORD in crypted form, for example BlowFish or SHA-256
Next
From: Jason Ralph
Date:
Subject: n_live_tup count increase after vacuum