Re: Two started cluster on the same data directory and port - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Two started cluster on the same data directory and port
Date
Msg-id cf37b994-64af-4c70-8e30-ef9a0e2229bf@aklaver.com
Whole thread Raw
In response to Re: Two started cluster on the same data directory and port  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On 11/30/23 07:23, Adrian Klaver wrote:
> On 11/30/23 05:37, Loles wrote:
>> Hi!
>>
>> I have this situation on a server that is giving me problems.
>>
>> postgres@hostname:~$ pg_lsclusters
>> Ver Cluster  Port Status Owner    Data directory              Log file
>> 14  main     5432 online postgres /var/lib/postgresql/14/main 
>> /var/log/postgresql/postgresql-14-main.log
>> 14  main_old 5432 online postgres /var/lib/postgresql/14/main 
>> /var/log/postgresql/postgresql-14-main_old.log
>>
>> How can I stop, even delete, the main_old cluster?
> 
> Assuming you are on  Debian/Ubuntu.
> 
> 1) sudo pg_ctlcluster stop 14 main_old
> 
>      This will stop the server for this session
> 
> 2) sudo vi  /etc/postgresql/14/main_old/start.conf
> 
>      Change auto to manual.
>      This will keep the server from restarting on reboot.
>      You can still start it using
>       sudo pg_ctlcluster start 14 main_old
>      Though if you want to do that then:
>          vi /etc/postgresql/14/main_old/postgresql.conf
>       and change port to something other then 5432.
> 
> 3) If you have determined you really don't need that server and have all 
> the data safely backed up or moved to the other server, then(THIS IS NOT 
> REVERSIBLE):
> 
>      sudo pg_dropcluster 14 main_old

Blaming it on not enough coffee, but I just noticed both clusters are 
pointing at the same data directory. I would NOT do:

     sudo pg_dropcluster 14 main_old

> 
>>
>> Thanks!
>>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Two started cluster on the same data directory and port
Next
From: Adrian Klaver
Date:
Subject: Re: libpq crashing on macOS during connection startup