I am considering using postgresql for a project and the only thing that concerns me about it is the upgrade story. As someone who comes from using distributed DBs where zero downtime upgrades are the norm, several months of effort to do an upgrade in postgresql seems unacceptable.
Does anyone know if there are any plans to make this better?
Random finding in my twitter feed after reading your comment: http://www.slideshare.net/dataloop/zero-downtime-postgres-upgrades
Interesting. Unfortunately it still seems quite a bit more complicated.
Author of the talk here, it is. I think Postgres has a long way to go on upgrades and clustering.
Since it’s not linked from that SlideShare page (and that page is controlled by the meetup hosts), here’s the video.