Re: Two started cluster on the same data directory and port

On 11/30/23 08:37, Loles wrote:
> 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.

Is there both?:

/etc/postgresql/14/main/
/etc/postgresql/14/main_old/

>
>
> El jue, 30 nov 2023 a las 17:34, Loles (<lolesft(at)gmail(dot)com
> <mailto:lolesft(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(at)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com