On Mon, Aug 18, 2014 at 3:16 PM, Ashish Yadav <ashish.yadav@xxxxxxxxxxx> wrote: > Hi, > > I am currently running a stand alone PostgreSQL v8.4.14 on a Linux CentOS > server and need to perform an upgrade. > Can I upgrade to the latest PostgreSQL v9.3.5 or do I need to perform an > intermediate upgrade? > > Current: > psql (PostgreSQL) 8.4.14 > > java version "1.6.0_37" > Java(TM) SE Runtime Environment (build 1.6.0_37-b06) > Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01, mixed mode) > How important is uninterrupted uptime to you? If no big deal, then as mentioned by another poster, upgrde ti 8.4.latest, then after taking a backup install 9.3.latest and use pg_upgrade from 9.3 to get there. Other possibilites are to take a backup with 9.3 and then restore with that. Use slony to replicate from 8.4 to 9.3 so that both are live and switchover time is minimized. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
