Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade -c cannot be run if old cluster is running - Mailing list pgsql-docs

From Tom Lane
Subject Re: pg_upgrade -c cannot be run if old cluster is running
Date
Msg-id 1827652.1725543542@sss.pgh.pa.us
Whole thread Raw
In response to RE: pg_upgrade -c cannot be run if old cluster is running  (Alain Bourgeois <alain.bourgeois@zetes.com>)
Responses Re: pg_upgrade -c cannot be run if old cluster is running
List pgsql-docs
Tree view 
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.confholds 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

pgsql-docs by date:

Previous
From: Alain Bourgeois
Date:
Subject: RE: pg_upgrade -c cannot be run if old cluster is running
Next
From: Daniel Gustafsson
Date:
Subject: Re: pg_upgrade -c cannot be run if old cluster is running