Hey, I am trying to upgrade a CentOS 5.4 32bit test server running postgres 8.3.4 to postgres 9.1 RC1 and am running into an error I haven't seen mentioned in the forums (at least dealing with the upgrade process). The steps I ran through for the upgrade are...
>Stop postgres >move /usr/local/pgsql to /usr/local/pgsql.8.3 >move /usr/pgdata/data to /usr/pgdata/data.8.3 >build 9.1 RC1 from source using "./configure --with-perl --with-openssl --disable-integer-datetimes; make; make install" >build and install pg_upgrade and pg_upgrade_support >swap to postgres user >run "/usr/local/pgsql/bin/initdb --lc-collate=C --lc-ctype=C --lc-messages=C --lc-monetary=C --lc-numeric=C --lc-time=C -E SQL-ASCII -D /usr/pgdata/data" to create the 9.1 cluster and set the settings to match the old cluster >/usr/local/pgsql/bin/pg_upgrade --link --old-datadir /usr/pgdata/data.8.3/ --new-datadir /usr/pgdata/data/ --old-bindir /usr/local/pgsql.8.3/bin/ --new-bindir /usr/local/pgsql/bin/ What I get is... Performing Consistency Checks ----------------------------- Checking current, bin, and data directories ok Checking cluster versions ok Checking database user is a superuser ok Checking for prepared transactions DB command failed SELECT * FROM pg_catalog.pg_prepared_xact() ERROR: a column definition list is required for functions returning "record" Failure, exiting The binaries for the 8.3.4 install were built from source using the --with-perl --with-openssl options as well. Any thoughts on what I might be able to do to fix or workaround this? Thanks! - Justin
