FYI, also, yesterday, I fixed a pg_upgrade bug when upgrading from 8.3
--- I suggest you wait for 9.0.5 or pull git head for the release you
want.
---------------------------------------------------------------------------
Tom Lane wrote:
> I wrote:
> > I think it'd be a lot safer to modify (or just remove) the test in
> > pg_upgrade. It looks like a one-liner:
>
> Specifically, the attached patch takes care of the problem. Thanks
> for reporting it!
>
> regards, tom lane
>
>
> diff --git a/contrib/pg_upgrade/check.c b/contrib/pg_upgrade/check.c
> index 9690695..93b9e69 100644
> *** a/contrib/pg_upgrade/check.c
> --- b/contrib/pg_upgrade/check.c
> *************** check_for_prepared_transactions(ClusterI
> *** 532,538 ****
>
> res = executeQueryOrDie(conn,
> "SELECT * "
> ! "FROM pg_catalog.pg_prepared_xact()");
>
> if (PQntuples(res) != 0)
> pg_log(PG_FATAL, "The %s cluster contains prepared transactions\n",
> --- 532,538 ----
>
> res = executeQueryOrDie(conn,
> "SELECT * "
> ! "FROM pg_catalog.pg_prepared_xacts");
>
> if (PQntuples(res) != 0)
> pg_log(PG_FATAL, "The %s cluster contains prepared transactions\n",
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +