From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_upgrade automatic testing |
Date: | 2011-08-31 19:24:02 |
Message-ID: | 1314818642.13971.7.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On tis, 2011-08-30 at 16:25 -0400, Tom Lane wrote:
> So I think that as given, this script is only useful for testing
> pg_upgrade of $currentversion to $currentversion. Which is surely
> better than no test at all, but it would not for example have caught
> the 8.3 incompatibility that was just reported.
Well, the goal was always current to current version. Cross-version
testing is obviously important, but will be quite a bit harder.
> How can we improve things here? I've toyed with the idea of
> installing pg_regress.so so that we can refer to it relative to
> $libdir, but that might be a bit invasive, especially if we were to
> try to back-patch it as far as 8.3.
Aside from hesitations to backpatch those sorts of changes, it would
effectively prevent us from ever removing anything from the C libraries
used in the regression tests, because we need to keep the symbols around
so that the schema dump can load successfully into the new instance.
I think a solution would have to be one of:
1) pg_upgrade needs a mode to cope with these situations. It can tell
the user, I upgraded your installation, but some dynamic modules appear
to be missing, you need to sort that out before you can put this back
into use.
2) Design a different test schema to load into the database before
running pg_upgrade. This would then be a one-line change in the script.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2011-08-31 19:27:06 | Re: postgresql.conf archive_command example |
Previous Message | Merlin Moncure | 2011-08-31 19:15:00 | Re: "stored procedures" |