Обсуждение: pg migrator

Korry Douglas has an EDB sponsored project called pg_migrator on
pgfoundry.   I believe it works for upgrading from 8.1 to 8.2 except
for tables that use the ip address datatype.  It works by just
replacing the 8.1 system catalogs with the 8.2 system catalogs.  I
believe the on-disk images for 8.1 and 8.2 are the same except for the
ip address field.

--Luss
  http://www.enterpisedb.com

On 1/29/07, Bruno Wolff III <bruno@wolff.to> wrote:
> On Mon, Jan 29, 2007 at 15:51:54 -0800,
>   Rich Shepard <rshepard@appl-ecosys.com> wrote:
> > On Tue, 30 Jan 2007, Michael Glaesemann wrote:
> >
> > >It was *discussed*. 8.1 to 8.2 (as does any move from M.x to M.y where x ­
> > >y) requires a dump and reload.
> >
> > Michael,
> >
> >   That's what I thought. However, it never hurts to ask. :-)
>
> I figured that mentionioning you need a tool that doesn't exist would make
> it clear that this was proposed for the future and not current reality.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>

On Mon, 29 Jan 2007, Denis Lussier wrote:

> Korry Douglas has an EDB sponsored project called pg_migrator on
> pgfoundry.  I believe it works for upgrading from 8.1 to 8.2 except for
> tables that use the ip address datatype.  It works by just replacing the
> 8.1 system catalogs with the 8.2 system catalogs.  I believe the on-disk
> images for 8.1 and 8.2 are the same except for the ip address field.

Denis,

   I downloaded the tarball. It's interesting that the search engine on the
pgfoundary part of the site could not find it. I used Google, and it was the
top hit. Once I knew where to look I could find it on the site, but only
manually moving through the pages.

Thanks,

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

On Tue, 30 Jan 2007, Erik Jones wrote:

> I had the same problem:  searching for 'pg_migrator' found nothing.
> However, searching for 'migrator' got it.

   A-ha! I didn't try that, just fell back to Google. :-)

Thanks, Erik,

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Rich Shepard wrote:
> On Mon, 29 Jan 2007, Denis Lussier wrote:
>
>> Korry Douglas has an EDB sponsored project called pg_migrator on
>> pgfoundry.  I believe it works for upgrading from 8.1 to 8.2 except for
>> tables that use the ip address datatype.  It works by just replacing the
>> 8.1 system catalogs with the 8.2 system catalogs.  I believe the on-disk
>> images for 8.1 and 8.2 are the same except for the ip address field.
>
> Denis,
>
>   I downloaded the tarball. It's interesting that the search engine on
> the
> pgfoundary part of the site could not find it. I used Google, and it
> was the
> top hit. Once I knew where to look I could find it on the site, but only
> manually moving through the pages.
I had the same problem:  searching for 'pg_migrator' found nothing.
However, searching for 'migrator' got it.

>   I downloaded the tarball. It's interesting that the search engine on 
> the
> pgfoundary part of the site could not find it. I used Google, and it 
> was the
> top hit. Once I knew where to look I could find it on the site, but only
> manually moving through the pages.
I had the same problem:  searching for 'pg_migrator' found nothing.  
However, searching for 'migrator' got it.

The software that runs pgFoundry (GForge) has a strange rule that states that project names cannot include an underscore.

So, pgFoundry stores this project under the name "pg-migrator".  If you search for that (a dash instead of an underscore), the pgFoundry search engine can find it.

Of course, as Erik points out, a search for "migrator" works just as well (thanks Erik).

            -- Korry

--   Korry Douglas    korryd@enterprisedb.com   EnterpriseDB      http://www.enterprisedb.com

korryd@enterprisedb.com wrote:
>> >   I downloaded the tarball. It's interesting that the search engine on
>> > the
>> > pgfoundary part of the site could not find it. I used Google, and it
>> > was the
>> > top hit. Once I knew where to look I could find it on the site, but only
>> > manually moving through the pages.
>> I had the same problem:  searching for 'pg_migrator' found nothing.
>> However, searching for 'migrator' got it.
>>
>
> The software that runs pgFoundry (GForge) has a strange rule that
> states that project names cannot include an underscore.
>
> So, pgFoundry stores this project under the name "pg-migrator".  If
> you search for that (a dash instead of an underscore), the pgFoundry
> search engine can find it.
>
> Of course, as Erik points out, a search for "migrator" works just as
> well (thanks Erik).
>
>             -- Korry
No problem!  Thanks for the enlightenment as to the why...