Thread: [CRITICAL PATCH] Release Candidate 5 ...
Today, by chance, we were able to trigger a bug new to v7.0, dealing with
indices on system tables ...
Tom Lane quickly generated and applied patches for this, and we've created
a Release Candidate 5 based on these patches ...
This RC *requires* a complete dump/initdb/reload of your database
... without it, consider your database a ticking timebomb ...
The Release Candidate is available in its usual location:
ftp://ftp.postgresql.org/pub/...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
The Hermit Hacker <scrappy@hub.org> writes:
> This RC *requires* a complete dump/initdb/reload of your database
> ... without it, consider your database a ticking timebomb ...
Or at least your pg_group table is a timebomb, if it's not empty.
Panic is not called for unless you use groups.
It should be noted that we found and fixed some problems in pg_upgrade
as well. This may mean that pg_upgrade is now safe. Or not, but it's
hard to say without testing. I would like to ask people who are
upgrading to RC5 to try to use pg_upgrade for the move, and report
whether you see problems or not. *Please* read the man page for
pg_upgrade, and make a complete dump beforehand so you have a fallback
if it fails ...
regards, tom lane
> > Today, by chance, we were able to trigger a bug new to v7.0, dealing with > indices on system tables ... > > Tom Lane quickly generated and applied patches for this, and we've created > a Release Candidate 5 based on these patches ... > > This RC *requires* a complete dump/initdb/reload of your database > ... without it, consider your database a ticking timebomb ... ^^^^^^^^^^^^^^^^^^ Did you have to say that? :-) -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
On Fri, 5 May 2000, Bruce Momjian wrote:
> >
> > Today, by chance, we were able to trigger a bug new to v7.0, dealing with
> > indices on system tables ...
> >
> > Tom Lane quickly generated and applied patches for this, and we've created
> > a Release Candidate 5 based on these patches ...
> >
> > This RC *requires* a complete dump/initdb/reload of your database
> > ... without it, consider your database a ticking timebomb ...
> ^^^^^^^^^^^^^^^^^^
>
> Did you have to say that? :-)
Nope, could have gone with something like "a nuclear bomb just itching to
explode", but thought it was too verbose :)
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org