| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Greg Burek <gb(at)heroku(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3? |
| Date: | 2013-11-06 16:10:44 |
| Message-ID: | 527A6A04.3040008@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/06/2013 01:06 AM, Greg Burek wrote:
> Hello,
> How advisable or well known is it to take a 9.0 era db directly to 9.3
> using the latest pg_upgrade binary?
Sure. I have done it all the way back to 8.3 (with 9.2). You should of
course test as pg_upgrade is a tool not a perfect solution.
IMO, I would upgrade to 9.2 precisely because it is battle tests, 9.3
isn't but it depends on your particular needs. 9.3 has a lot of cool
stuff in it.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
a rose in the deeps of my heart. - W.B. Yeats
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Ross | 2013-11-06 17:40:07 | After upgrade to 9.3, streaming replication fails to start |
| Previous Message | Jing Fan | 2013-11-06 14:53:15 | Re: WITH RECURSIVE doesn't work properly for me |