2022 Developer Survey is open! Take survey.

New answers tagged

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 ...
user avatar
  • 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. ...
user avatar
  • 32.2k

Top 50 recent answers are included