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.