Re: pg_upgrade does not upgrade pg_stat_statements properly

From: Jan Wieck <jan(at)wi3ck(dot)info>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(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-15 16:58:29
Message-ID: 32651584-73f4-7d20-9674-09449ccaaf4e@wi3ck.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 7/15/21 12:46 PM, David G. Johnston wrote:

> I am an application developer who operates on the principle of "change
> only one thing at a time".

Which pg_upgrade by definition isn't. It is bringing ALL the changes
from one major version to the target version, which may be multiple at
once. Including, but not limited to, catalog schema changes, SQL
language changes, extension behavior changes and utility command
behavior changes.

On that principle, you should advocate against using pg_upgrade in the
first place.

Regards, Jan

--
Jan Wieck

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message James Coleman 2021-07-15 17:00:36 Re: [PATCH] Use optimized single-datum tuplesort in ExecSort
Previous Message David G. Johnston 2021-07-15 16:46:08 Re: pg_upgrade does not upgrade pg_stat_statements properly