Re: pg_upgrade does not upgrade pg_stat_statements properly

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Dave Cramer <davecramer(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade does not upgrade pg_stat_statements properly
Date: 2021-07-14 18:47:47
Message-ID: CAKFQuwY9bAJ7m0eY7aRJxF8QLZFzTJE-yO9q2Ltg8JVv=RW+wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wednesday, July 14, 2021, Dave Cramer <davecramer(at)gmail(dot)com> wrote:

>
>
> Notice the upgraded version is 1.5 and the new version is 1.8
>
> I would think somewhere in the upgrade of the schema there should have
> been a create extension pg_stat_statements ?
>

That would be a faulty assumption. Modules do not get upgraded during a
server version upgrade. This is a good thing, IMO.

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2021-07-14 18:58:45 Re: pg_upgrade does not upgrade pg_stat_statements properly
Previous Message Zhihong Yu 2021-07-14 18:42:35 Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers