Postgres FM cover image

pg_upgrade: the tricky and dangerous parts

Postgres FM

CHAPTER

The Problem With Automating the Process Involving Logical and Run Postgres Measure Upgrade

In new cluster after PGA grade, we don't have statistics, so we need to run analyze. I would say it's not a good idea to run analyze right away. We can start logical first and run analyze logical subscription first. But if order of actions logical first, then upgrade and continue logical, there are risks of corruption. If you have a really big database, probably we still won't work well.

00:00
Transcript
Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner