Michael Orlitzky <[email protected]> wrote:
> On 11/10/2014 06:04 AM, [email protected] wrote:
> > Hi. I have a puzzle regarding upgrading postgresql. In my recent world
> > update I went from 9.4_beta2 to beta3, but when I tried to start the
> > server, it complained that the databases were written with a different
> > "catalog version" -- whatever that is, and the pg_upgrade tool requires
> > both old and new binaries to actually upgrade the database. So as a
> > temporary measure, I went back to beta2 and things worked again. So
> > what the heck are you supposed to do here, I like pg, but this is very
> > strange to me.
> >
> > Thanks in advance for any suggestions.
> >
>
> pg_upgrade has always been a PITA for me. There's an easier way that
> always works: run pg_dumpall, upgrade postgres, and then restore the
> dump file.
>
> If your databases are small enough, it's much less stressful, and it
> works for major version bumps as well.
>
> If you're worried about overwriting your data, you could always back up
> the beta2 binary files, and then create empty databases under beta3
> before restoring.
Thanks, maybe I will do that next time.
--
Your life is like a penny. You're going to lose it. The question is:
How do
you spend it?
John Covici
[email protected]
