Re: pg_upgrade does not upgrade pg_stat_statements properly

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Dave Cramer <davecramer(at)postgres(dot)rocks>
Cc: Jan Wieck <jan(at)wi3ck(dot)info>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade does not upgrade pg_stat_statements properly
Date: 2021-07-30 11:07:28
Message-ID: 20210730110728.tqt3oeohyvtuqqk7@nol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 30, 2021 at 06:48:34AM -0400, Dave Cramer wrote:
>
> Well I think that's on the extension author to fix. There's only so much
> pg_upgrade can do here.
> It seems reasonable that upgrading the extension should upgrade the
> extension to the latest version.

That would only work iff the extension was *not* up to date on the original
instance. Otherwise I fail to see how any extension script will be called at
all, and therefore the extension was no way to fix anything.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2021-07-30 11:18:56 Re: pg_upgrade does not upgrade pg_stat_statements properly
Previous Message Lætitia Avrot 2021-07-30 10:55:42 Re: pg_dump new feature: exporting functions only. Bad or good idea ?