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 32a1e9d1-6bf6-4d4c-8952-10cb5b23b55a@aklaver.com
Whole thread Raw
In response to Two started cluster on the same data directory and port  (Loles <lolesft@gmail.com>)
List pgsql-general
On 11/30/23 08:34, Loles wrote:

Please reply to list also.
Ccing list.

> 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 <mailto: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 <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Loles
Date:
Subject: Re: Two started cluster on the same data directory and port
Next
From: Adrian Klaver
Date:
Subject: Re: Two started cluster on the same data directory and port