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

On 11/30/23 08:46, Loles wrote:
> Yes, it exists but it is obsolete. The files and directories are all
> dated 2022.
>
> It was obsolete and no longer valid, it could be deleted. Only the main
> cluster is correct.

First try:

vi /etc/postgresql/14/main_old/start.conf

and change auto to disabled.

Stop the server(s) and then:

sudo pg_ctlcluster starp 14 main

>
> El jue, 30 nov 2023 a las 17:43, Adrian Klaver
> (<adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>) escribió:
>
> 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>
> > <mailto: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> <mailto: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>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
> --
> 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