Re: pg_upgrade -c cannot be run if old cluster is running

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alain Bourgeois <alain(dot)bourgeois(at)zetes(dot)com>
Cc: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade -c cannot be run if old cluster is running
Date: 2024-09-05 13:39:02
Message-ID: 1827652.1725543542@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Alain Bourgeois <alain(dot)bourgeois(at)zetes(dot)com> writes:
> /usr/lib/systemd/system/postgresql-10.service has PGDATA=/var/lib/pgsql/10/data/, /var/lib/pgsql/10/data/postgtresql.conf holds data_directory = '/mnt/pgdata/pgdir'

This is probably the source of your problem. IIRC, pg_upgrade
needs to be pointed at the actual old data directory, not
PGDATA=/var/lib/pgsql/10/data.

regards, tom lane

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2024-09-05 13:41:10 Re: pg_upgrade -c cannot be run if old cluster is running
Previous Message Alain Bourgeois 2024-09-05 09:45:02 RE: pg_upgrade -c cannot be run if old cluster is running