New answers tagged upgrade
1
vote
Desired State Schema Best Practices for continous schema + data upgrades at different on prem locations
It sounds like you're re-inventing a state-based deployment tool. I would choose a tool (Microsoft SSDT, RedGate SQL Change Automation) and then get that to work for your project instead.
Both offer ...
- 27.1k
1
vote
What is the best way to migrate & upgrade a extremely large postgreSQL server to another hardware whilst minimising downtime
Do not upgrade to any version below v14.
You can use streaming replication and switch-over to move the database to a different machine. Upgrade with pg_upgrade -k requires very little down time. ...
- 32.2k
Top 50 recent answers are included