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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Loles <lolesft(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Two started cluster on the same data directory and port
Date: 2023-11-30 18:35:56
Message-ID: 7280c019-2c61-452c-be52-bf38604df356@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/30/23 09:27, Loles wrote:

> root(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
>
> Start, up the two cluster.
>

Before going any further make sure you have a current backup of the
database.

Hmm, are /etc/postgresql/14/main/ and /etc/postgresql/14/main_old/
symlinked together?

If not what if you move the ~14/main_old/ directory somewhere else and
then restart Postgres?

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Patil 2023-11-30 19:07:34 PAF with Pacemaker
Previous Message Stephen Frost 2023-11-30 17:48:05 Re: Fixing or Mitigating this ERROR: invalid page in block 35217 of relation base/16421/3192429