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

From Loles
Subject Re: Two started cluster on the same data directory and port
Date
Msg-id CA+FWGK5BCtYdA5X1bZNFixsxqXU9vXVeS1=ue6h1UHoGs-e9-g@mail.gmail.com
Whole thread Raw
In response to Two started cluster on the same data directory and port  (Loles <lolesft@gmail.com>)
Responses Re: Two started cluster on the same data directory and port
List pgsql-general
Every time I stop the main_old cluster with sudo pg_ctlcluster stop 14 main_old, both are stopped. And when I raise sudo pg_ctlcluster start 14 main, both are raised.

I don't know how I got into this situation and I don't know how to resolve it.


El jue, 30 nov 2023 a las 17:34, Loles (<lolesft@gmail.com>) escribió:
Indeed, that is the problem, they are two different clusters, pointing to the same data directory and reading from the same port.

I can't change the port because it is the same postgresql.conf

I don't know how to disassociate the main_old cluster from the data directory or how to resolve this situation.

El jue, 30 nov 2023 a las 16:32, Adrian Klaver (<adrian.klaver@aklaver.com>) escribió:
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: libpq crashing on macOS during connection startup
Next
From: Adrian Klaver
Date:
Subject: Re: Two started cluster on the same data directory and port