Hi All,
I am thinking of using 9.5 alpha on a (non-production) database server that is currently running 9.2. The server is CentOS 6.4. Can I just do rpm -Uvh and hope it will all be fine or do I have to go through full dump/restore or even the pg_upgrade-based procedure? The full dump/restore will be very time consuming which I want to avoid; and pg_upgrade apparently wants each version to have its own installation and data directories which I don't have.
The primary motivation is the "UPSERT" feature introduced in 9.5. This is an analysis database which contains a subset of our production data, but tables that would benefit from UPSERT are currently dropped and recreated every time the dump/restore script is run (which is quite inefficient, in my opinion).
Binand