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

From Jan Wieck
Subject Re: pg_upgrade does not upgrade pg_stat_statements properly
Date
Msg-id 32651584-73f4-7d20-9674-09449ccaaf4e@wi3ck.info
Whole thread Raw
In response to Re: pg_upgrade does not upgrade pg_stat_statements properly  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pg_upgrade does not upgrade pg_stat_statements properly  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_upgrade does not upgrade pg_stat_statements properly
Next
From: James Coleman
Date:
Subject: Re: [PATCH] Use optimized single-datum tuplesort in ExecSort