sorintlab / stolon

PostgreSQL cloud native High Availability and more.
https://talk.stolon.io
Apache License 2.0
4.64k stars 445 forks source link

Handle postgresql DB upgrade #159

Open sgotti opened 8 years ago

sgotti commented 8 years ago

Experiment if it's possibile to automate major version db upgrades using pg_upgrade.

Nowheresly commented 6 years ago

Any idea about how this could be implemented?

Slach commented 4 years ago

some ideas was published by pglupgrade https://www.2ndquadrant.com/en/blog/tag/pglupgrade/ and use pgbouncer + pg_upgrade + pglogical

I tried to reproduce it, but unsuccessfull and @gulcin (https://github.com/gulcin) just ignored all my emails

gulcin commented 4 years ago

Hi, I am sorry I was away on maternity leave and I don't work for 2ndQuadrant now. This work was done during my time there, and unfortunately I can't share details due to the contract I signed.