| 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: | Whole Thread | Raw Message | 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
| 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 |