Re: How to safely remove a corrupted cluster?

From: Marco Ippolito <ippolito(dot)marco(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to safely remove a corrupted cluster?
Date: 2019-09-19 13:17:35
Message-ID: CAFegzBTcFzCKQ8nYtUy=wgaQzLVRWGag3ZJQbBrsQx0m03VP1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Solved by repeating the execution of (base) postgres(at)pc:~$ pg_dropcluster
--stop 11 fabmnet :

(base) postgres(at)pc:~$ pg_dropcluster --stop 11 fabmnet
Error: specified cluster does not exist

Marco

Il giorno gio 19 set 2019 alle ore 13:02 Marco Ippolito <
ippolito(dot)marco(at)gmail(dot)com> ha scritto:

> 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(at)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(at)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(at)pc:~$ sudo systemctl daemon-reload
> [sudo] password for marco:
> (base) marco(at)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2019-09-19 13:23:21 Re: PGPASSWORD in crypted form, for example BlowFish or SHA-256
Previous Message Steve Litt 2019-09-19 12:48:42 Re: PostgreSQL License