Re: pg_migrator issue with contrib - Mailing list pgsql-hackers

From Grzegorz Jaskiewicz
Subject Re: pg_migrator issue with contrib
Date
Msg-id 093489D2-D37B-4423-8EF3-0E107E64C5C3@pointblue.com.pl
Whole thread Raw
In response to Re: pg_migrator issue with contrib  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_migrator issue with contrib  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On 7 Jun 2009, at 03:27, Bruce Momjian wrote:

> Grzegorz Jaskiewicz wrote:
>>
>> On 6 Jun 2009, at 19:50, Tom Lane wrote:
>>> We have five days.
>>>
>>> I don't think we need testing, per se.  The first step should be to
>>> diff
>>> the 8.3 and 8.4 versions of the various contrib .sql.in files and
>>> determine what changed.  Any module whose .sql.in file hasn't  
>>> changed
>>> is definitely safe.
>>
>> I can tell you already that dblink has changed, and I had to drop it
>> before migration, otherwise everything went fine. Migration of 57GB
>> data in place took about 1 minute.
>
> The good news is that the INSTALL instructions where clear enough for
> the tester to understand that uninstalling dblink from the old cluster
> and reinstalling it in the new cluster would work.
Yes, but I forgot about one database, and had to do it all over again,  
luckily I first tested it without --link...



pgsql-hackers by date:

Previous
From: Nicolas Barbier
Date:
Subject: Re: PostgreSQL Developer meeting minutes up
Next
From: Robert Haas
Date:
Subject: Re: pg_migrator issue with contrib