Search Postgresql Archives

Re: A note on pg_upgrade and missing "pg_upgrade_support.so"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2010/9/21 Bruce Momjian <bruce@xxxxxxxxxx>:
> Bruce Momjian wrote:
>> Ian Barwick wrote:
>> > Hi
>> >
>> > Just a quick note for anyone else building 9.0 from source and experimenting
>> > with pg_upgrade - if you get a message like the following when running the
>> > pg_upgrade binary:
>> >
>> > pg_upgrade_support.so must be created and installed in
>> > /path/to/pg90/lib/postgresql/pg_upgrade_support.so
>> >
>> > you need to build the the separate "pg_upgrade_support" as well.
>>
>> Well, that is step #4:
>>
>> Â Â Â http://www.postgresql.org/docs/9.0/static/pgupgrade.html
>> Â Â Â 4.
>>
>> Â Â Â Install pg_upgrade
>>
>> Â Â Â Install pg_upgrade and pg_upgrade_support in the new PostgreSQL cluster
>>
>> Was that not clear enough?
>
> I hope my comment didn't sound insulting. ÂI really want to know how
> that doc item can be made clearer.

No insult taken :) .With the benefit of hindsight it's plenty clear;
the problem was:

a) I was doing this in a hurry (had a small amount of time to kill and
a dev machine with an older beta on it)
b) got sidetracked by this thread which appears to describe the same
problem: http://archives.postgresql.org/pgsql-testers/2010-06/msg00000.php
and which was popping up pretty high in Google.

Looking over the doc page again, if scanning over it, it's a bit easy
to misread it as something like "Install pg_upgrade for pg_upgrade
support in the new PostgreSQL cluster".

To my shame I hadn't even looked at pg_upgrade before, so was coming
to it from a point of zero knowledge. How about a slightly more
pedantic phrasing such as:

------
4. Install pg_upgrade

pg_upgrade requires the installation of the contrib modules
"pg_upgrade" and "pg_upgrade_support" in the new PostgreSQL cluster
------

(maybe "pg_upgrade" and "pg_upgrade_support" could be highlighted in
some way, e.g. with the courier-style font if that fits in with the
doc functions).

Anyway, it worked fine and I have since used it to upgrade to 9.0 on
my personal "production" server with minimal downtime.

Thanks for yet another great release


Ian Barwick

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux