Re: [v15 beta] pg_upgrade failed if earlier executed with -c switch - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: [v15 beta] pg_upgrade failed if earlier executed with -c switch
Date
Msg-id 48B90CDE-DB6B-4450-AC06-13E3AAF55AA3@yesql.se
Whole thread Raw
In response to [v15 beta] pg_upgrade failed if earlier executed with -c switch  (tushar <tushar.ahuja@enterprisedb.com>)
Responses Re: [v15 beta] pg_upgrade failed if earlier executed with -c switch
List pgsql-hackers
> On 3 Jun 2022, at 13:19, tushar <tushar.ahuja@enterprisedb.com> wrote:

> This behavior was not there in earlier released versions, i guess.
> Is it expected behavior now onwards?

That's an unfortunate side effect which AFAICT was overlooked in the original
thread.  Having a predictable name was defined as important for CI/BF, but I
agree that the above is likely to be a common user pattern (first running -c is
exactly what I did when managing databases and upgraded them with pg_upgrade).

This might break a few automated upgrade scripts out there (but they might also
already need changes to cope with the moved file locations).

We can address this by documentation, and specifically highlight under the -c
option in the manual that the folder need to removed/renamed (and possibly to
STDOUT aswell when run with -c).

--
Daniel Gustafsson        https://vmware.com/




pgsql-hackers by date:

Previous
From: tushar
Date:
Subject: [v15 beta] pg_upgrade failed if earlier executed with -c switch
Next
From: Peter Eisentraut
Date:
Subject: Re: Collation version tracking for macOS