Re: Pre-version pg_upgrade syntax check

On 2/10/20 3:40 PM, Rich Shepard wrote:
> On Mon, 10 Feb 2020, Rich Shepard wrote:
>
>> Good advice; I'll do that.
>
> Huh! Not what I expected:
>
> postgres(at)salmo:~$ pg_upgrade -c -b /usr/lib64/postgresql/11/bin/ -B
> /usr/lib64/postgresql/12/bin/ -d /var/lib/pgsql/11/data -D
> /var/lib/pgsql/12/data/
>
> (All on one line; wrapped by alpine.)
>
> Performing Consistency Checks
> -----------------------------
> Checking cluster versions Old cluster data and binary directories are
> from different major versions.
> Failure, exiting
>
> Well, of course they're from different major versions, that's why I'm
> running pg_upgrade. What did I do incorrectly?

What it is saying is -b and -d are pointing at binary and data
directories that are incompatible. You need to make sure that:

/usr/lib64/postgresql/11/bin/
and
/var/lib/pgsql/11/data

are actually pointing at 11 instances of binaries and data respectively.

>
> Rich
>
>

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