Thread: RPM Upgrading
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
On Thursday, October 01, 2015 08:17:46 AM Binand Sethumadhavan wrote: > 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. Well, you'll have to do one or the other. You can't just use your old data directory with the new software. If you use the PostgreSQL RPM Repository packages you can have both versions installed without conflicts.
Hi, On Thu, 2015-10-01 at 08:17 +0530, Binand Sethumadhavan wrote: > > 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? Depends on how you installed 9.2 on CentOS 6.4. If you used the community RPMs for 9.2, then you can install 9.5 in parallel and then use pg_upgrade. However, if they are CentOS RPMs, then first replace them with community RPMs (fully binary compatible, only default $PGDATA is difference), and then install 9.5. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR