From: | Binand Sethumadhavan <binand(at)gmx(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | RPM Upgrading |
Date: | 2015-10-01 02:47:46 |
Message-ID: | CAFBJCCbt7095vayOhJdJzC46NAPAoM-xPix+kc==0rvROfN-rw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alan Hodgson | 2015-10-01 15:21:42 | Re: RPM Upgrading |
Previous Message | JORGE MALDONADO | 2015-09-30 15:38:04 | Backup failed using pg_dump from command promt |