Re: [v15 beta] pg_upgrade failed if earlier executed with -c switch

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [v15 beta] pg_upgrade failed if earlier executed with -c switch
Date: 2022-06-03 12:01:18
Message-ID: 48B90CDE-DB6B-4450-AC06-13E3AAF55AA3@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 3 Jun 2022, at 13:19, tushar <tushar(dot)ahuja(at)enterprisedb(dot)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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2022-06-03 12:17:28 Re: Collation version tracking for macOS
Previous Message tushar 2022-06-03 11:19:36 [v15 beta] pg_upgrade failed if earlier executed with -c switch