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+FWGK5we+Cw=h=ezhqDcXrmvwcLGE7tMsMdv4fQ39Q-0Ohr_A@mail.gmail.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
No, they are not symbolic links. I have thought about moving the main_old directory somewhere else and it doesn't change anything because the cluster main_old is linked to the main data directory. In fact, neither the log nor any main_old data file changes, they are all from 2020. It's a strange case

El jue., 30 nov. 2023 16:23, Adrian Klaver <adrian.klaver@aklaver.com> escribió:
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

>
> Thanks!
>

--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Tom Lane
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