Re: pg_upgrade docs

On 05/24/2010 07:43 PM, Bruce Momjian wrote:
> Stefan Kaltenbrunner wrote:
>> On 05/19/2010 05:16 PM, Bruce Momjian wrote:
>>> Andres Freund wrote:
>>>> On Wednesday 19 May 2010 22:39:32 Bruce Momjian wrote:
>>>>> There are some limitations when migrating from 8.3 to 8.4, but not when
>>>>> migrating from 8.3 to 9.0, because we added a feature to 9.0.  Can you
>>>>> give a specific example?
>>>> Didnt the 'name' alignment change?
>>>
>>> Uh, the heading above that item is:
>>>
>>>    <title>Limitations in migrating<emphasis>from</>  PostgreSQL
>>>    8.3</title>
>>>
>>> What is unclear there?  It covers going to 8.4 and 9.0.
>>
>> well the wording makes it kinda unclear on what happens if you go FROM
>> 8.4 to 9.0. If there are no known limits we might want to add a small
>> note saying so. If there are some we might want to restructure the
>> paragraph a bit...
>
> Sorry for the delay in replying.  The section you list is titled:
>
> 	F.31.4. Limitations in migrating from PostgreSQL 8.3
>
> 	http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html
>
> and the first sentence is:
>
>     pg_upgrade will not work for a migration from 8.3 if a user column
>
> I have updated the paragraph to be:
>
>     Upgrading from PostgreSQL 8.3 has additional restrictions not present
>     when upgrading from later PostgreSQL releases.  For example,
>     pg_upgrade will not work for a migration from 8.3 if a user column
>     is defined as:
>
> Can you suggest other wording?

hmm that seems better thanks, however I just noticed that we don't have 
a "general limitations" section. The way the docs are now done suggests 
that there are not limitations at all (except for the two warnings in 
the migration guide). Is pg_upgrade really up to the point where it can 
fully replace pg_dump & pg_restore independent of the loaded (contrib) 
or even third party modules(like postgis or custom datatypes etc)?



Stefan