Re: upgrade from 7.3.1 to 7.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chantal Ackermann <chantal(dot)ackermann(at)biomax(dot)de>
Cc: Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>, ianh(at)tpchd(dot)org
Subject: Re: upgrade from 7.3.1 to 7.3.2
Date: 2003-02-10 18:32:52
Message-ID: 15639.1044901972@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chantal Ackermann <chantal(dot)ackermann(at)biomax(dot)de> writes:
> actually, the major point of my posting was, that the script pg_upgrade
> which is part of contrib in 7.3.1 and 7.3.2 is calling pg_dumpall with
> an option (-s) that does not exist.

Hm. Evidently when Peter rewrote pg_dumpall in C, he was a little too
narrow-minded about which pg_dump options should be accepted by
pg_dumpall. (The old script version would pass through almost anything.)
I wonder if anything else besides -s ought to be added back.

But as to the matter at hand: the fact that no one has tested pg_upgrade
since then should give you a good clue as to (a) its usefulness and (b)
how much you should trust it. The reason it's in contrib and not in the
main distro is that it's unreliable.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Smith 2003-02-10 18:58:11 Why must SELECT DISTINCT, ORDER BY expressions must appear in target list?
Previous Message Holger Klawitter 2003-02-10 18:29:50 renaming table leaves constraint behind [7.3.2]