Re: pg_upgrade does not upgrade pg_stat_statements properly - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: pg_upgrade does not upgrade pg_stat_statements properly
Date
Msg-id CAKFQuwax=XC5MSii-dB6AHg5Z2eZLvZEUG6r9BRtymy98ir1Fw@mail.gmail.com
Whole thread Raw
In response to Re: pg_upgrade does not upgrade pg_stat_statements properly  (Dave Cramer <davecramer@gmail.com>)
Responses Re: pg_upgrade does not upgrade pg_stat_statements properly  (Dave Cramer <davecramer@gmail.com>)
List pgsql-hackers
On Thursday, July 15, 2021, Dave Cramer <davecramer@gmail.com> wrote:

I'm thinking at this point we need something a bit more sophisticated like

ALTER EXTENSION ... UPGRADE. And the extension knows how to upgrade itself.

I’m not familiar with what hoops extensions jump through to facilitate upgrades but even if it was as simple as “create extension upgrade” I wouldn’t have pg_upgrade execute that command (or at least not by default).  I would maybe have pg_upgrade help move the libraries over from the old server (and we must be dealing with different databases having different extension versions in some manner…).

David J.

pgsql-hackers by date:

Previous
From: Zhihong Yu
Date:
Subject: Re: Removing unneeded self joins
Next
From: Alvaro Herrera
Date:
Subject: Re: unnesting multirange data types