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+FWGK5t6nE3e1fAWc5j1yXEKkDFhP3ZTNUyHRGbxysDN7k7kA@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>) |
| Responses |
Re: Two started cluster on the same data directory and port
|
| List | pgsql-general |
root@hostname:~# su - postgres
postgres@hostname:~$ nano /etc/postgresql/14/main_old/start.conf
postgres@hostname:~$ exit
cerrar sesión
root@hostname:~# pg_ctlcluster stop 14 main
(change auto for disabled and exit with save)
postgres@hostname:~$ nano /etc/postgresql/14/main_old/start.conf
postgres@hostname:~$ exit
cerrar sesión
root@hostname:~# pg_ctlcluster stop 14 main
(change auto for disabled and exit with save)
root@hostname:~# ps -ef | grep postgres
root 2609 1512 0 18:24 pts/1 00:00:00 grep postgres
root@hostname:~# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
14 main 5432 down postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
14 main_old 5432 down postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main_old.log
root@hostname:~#
root@hostname:~#
root@hostname:~# pg_ctlcluster start 14 main
root@hostname:~# ps -ef | grep postgres
postgres 2620 1 2 18:24 ? 00:00:00 /usr/lib/postgresql/14/bin/postgres -D /var/lib/postgresql/14/main -c config_file=/etc/postgresql/14/main/postgresql.conf
postgres 2625 2620 0 18:24 ? 00:00:00 postgres: 14/main: checkpointer
postgres 2626 2620 0 18:24 ? 00:00:00 postgres: 14/main: background writer
postgres 2627 2620 0 18:24 ? 00:00:00 postgres: 14/main: walwriter
postgres 2628 2620 0 18:24 ? 00:00:00 postgres: 14/main: autovacuum launcher
postgres 2629 2620 0 18:24 ? 00:00:00 postgres: 14/main: stats collector
postgres 2630 2620 0 18:24 ? 00:00:00 postgres: 14/main: logical replication launcher
root 2642 1512 0 18:24 pts/1 00:00:00 grep postgres
root@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
root 2609 1512 0 18:24 pts/1 00:00:00 grep postgres
root@hostname:~# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
14 main 5432 down postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main.log
14 main_old 5432 down postgres /var/lib/postgresql/14/main /var/log/postgresql/postgresql-14-main_old.log
root@hostname:~#
root@hostname:~#
root@hostname:~# pg_ctlcluster start 14 main
root@hostname:~# ps -ef | grep postgres
postgres 2620 1 2 18:24 ? 00:00:00 /usr/lib/postgresql/14/bin/postgres -D /var/lib/postgresql/14/main -c config_file=/etc/postgresql/14/main/postgresql.conf
postgres 2625 2620 0 18:24 ? 00:00:00 postgres: 14/main: checkpointer
postgres 2626 2620 0 18:24 ? 00:00:00 postgres: 14/main: background writer
postgres 2627 2620 0 18:24 ? 00:00:00 postgres: 14/main: walwriter
postgres 2628 2620 0 18:24 ? 00:00:00 postgres: 14/main: autovacuum launcher
postgres 2629 2620 0 18:24 ? 00:00:00 postgres: 14/main: stats collector
postgres 2630 2620 0 18:24 ? 00:00:00 postgres: 14/main: logical replication launcher
root 2642 1512 0 18:24 pts/1 00:00:00 grep postgres
root@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
Start, up the two cluster.
El jue, 30 nov 2023 a las 18:01, Adrian Klaver (<adrian.klaver@aklaver.com>) escribió:
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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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@gmail.com
> <mailto:lolesft@gmail.com>
> > <mailto:lolesft@gmail.com <mailto:lolesft@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.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com> <mailto: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>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
pgsql-general by date: