Re: [GENERAL] pg_upgrade problem

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] pg_upgrade problem
Date: 2011-09-05 15:48:50
Message-ID: 20110905154850.GA30525@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, Sep 01, 2011 at 08:05:51AM +0200, hubert depesz lubaczewski wrote:
> On Wed, Aug 31, 2011 at 09:54:20PM -0400, Bruce Momjian wrote:
> > Working with depesz, I have found the cause. The code I added to fix
> > pg_upgrade in 9.0.4 and earlier releases didn't handle old 8.3 servers
> > properly. I mistakenly processed toast table with the same pg_dump
> > query as used for pre-8.4 toast tables, not realizing those were not
> > functional because there were no reloptions for toast tables in pre-8.4.
>
> Thanks a lot. Will test and post results (around sunday/monday I guess).

All worked.
pg_upgrade/vacuum didn't raise any errors. Will check some random
queries too, but don't expect anything to break.

thanks again for quick help.

Best regards,

depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2011-09-05 15:56:34 Re: [GENERAL] pg_upgrade problem
Previous Message Radosław Smogura 2011-09-05 15:01:31 Re: Protocol question - fastpath & parameter status 'S'

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2011-09-05 15:51:35 Use of literal in SGML docs
Previous Message David Fetter 2011-09-05 15:21:46 Re: regress test failed