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
>
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 |