pg_upgrade vs extension upgrades

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_upgrade vs extension upgrades
Date: 2017-04-10 15:30:52
Message-ID: CABUevEyb38S0ApKpNNh1q_6zFnAwmqVjRauVg1uvJL9qRpxjHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

After you've run pg_upgrade, you have to loop through all your databases
and do an "ALTER EXTENSION abc UPDATE" once for each extension.

Is there a reason we shouldn't have pg_upgrade emit a script that does
this, similar to how it emits a script to run ANALYZE?

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-04-10 15:34:22 Re: RMT: Use Visual Studio 2015 for Compiling and linking the Windows version in PG10
Previous Message Robert Haas 2017-04-10 15:26:01 Re: pg_dump emits ALTER TABLE ONLY partitioned_table