pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alain Bourgeois <alain.bourgeois@zetes.com>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: pg_upgrade -c cannot be run if old cluster is running
Date: Thu, 05 Sep 2024 09:39:02 -0400
Message-ID: <1827652.1725543542@sss.pgh.pa.us> (raw)
In-Reply-To: <PAXP191MB1712B2F0354E98E4396CC739F09D2@PAXP191MB1712.EURP191.PROD.OUTLOOK.COM>
References: <172546462173.8361.7114078895863039790@wrigleys.postgresql.org>
	<1692842.1725482754@sss.pgh.pa.us>
	<PAXP191MB1712B2F0354E98E4396CC739F09D2@PAXP191MB1712.EURP191.PROD.OUTLOOK.COM>

Alain Bourgeois <alain.bourgeois@zetes.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

view thread (9+ messages)  latest in thread

Message-ID: <1827652.1725543542@sss.pgh.pa.us>
Permalink:  ../1827652.1725543542@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1827652.1725543542@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, alain.bourgeois@zetes.com, pgsql-docs@lists.postgresql.org
  Subject: Re: pg_upgrade -c cannot be run if old cluster is running
  In-Reply-To: <1827652.1725543542@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox