From: sayeed <sayeed.anjum@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pg_upgrade: error when migrating from 8.3 to 9.1
Date: Sun, 15 Jan 2012 03:54:46 -0800 (PST)
Message-ID: <1326628486711-5146289.post@n5.nabble.com> (raw)
I am trying to upgrade a database from postgresql 8.3.8 to 9.1. (Ubuntu 10.10
Maverick)
It is crashing out with the following error:
Adding support functions to new cluster ok
Restoring database schema to new cluster
"/usr/lib/postgresql/9.1/bin/psql" --set ON_ERROR_STOP=on --no-psqlrc --port
5435 --username "postgres" -f "/var/lib/postgresql/pg_upgrade_dump_db.sql"
--dbname template1 >> "/dev/null"
psql:/var/lib/postgresql/pg_upgrade_dump_db.sql:85146: ERROR: could not
find function "pg_freespacemap_pages" in file
"/usr/lib/postgresql/9.1/lib/pg_freespacemap.so"
The code at line 85146 is as follows:
CREATE FUNCTION pg_freespacemap_pages() RETURNS SETOF record
LANGUAGE c
AS '$libdir/pg_freespacemap', 'pg_freespacemap_pages';
Why does this happen? Any hints how this can be fixed? As a work around, is
it safe to create this function in 9.1 and how do I do that?
Help! Thanks in advance...
--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-upgrade-error-when-migrating-from-8-3-to-9-1-tp5146289p51...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sayeed.anjum@gmail.com
Subject: Re: pg_upgrade: error when migrating from 8.3 to 9.1
In-Reply-To: <1326628486711-5146289.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox