Re:Ask HN: What are the cons of PostgreSQL?
by bpineau on Friday June 10, 2016 @04:34PM
(#11879789)
The stored data format isn't compatible between major versions.
Because of that, upgrades are either stressfull and cumbersome (ie. slony + switchover to a promoted and upgraded slave), or imply a large downtime (ie. pg_upgrade).
Also, because of that (WAL format), you can't use native replication between different major versions of PostgreSQL.
Because of that, upgrades are either stressfull and cumbersome (ie. slony + switchover to a promoted and upgraded slave), or imply a large downtime (ie. pg_upgrade).
Also, because of that (WAL format), you can't use native replication between different major versions of PostgreSQL.