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 (<lole...@gmail.com <mailto:lole...@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.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>


--
Adrian Klaver
adrian.kla...@aklaver.com



Reply via email to