From: Tom Lane <tgl@sss.pgh.pa.us>
To: sayeed <sayeed.anjum@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade: error when migrating from 8.3 to 9.1
Date: Sun, 15 Jan 2012 12:28:21 -0500
Message-ID: <17931.1326648501@sss.pgh.pa.us> (raw)
In-Reply-To: <1326628486711-5146289.post@n5.nabble.com>
References: <1326628486711-5146289.post@n5.nabble.com>
sayeed <sayeed.anjum@gmail.com> writes:
> 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:
> 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"
> Why does this happen?
Because pg_freespacemap_pages() doesn't exist (and neither does the
freespace map) in versions after 8.3. Had pg_upgrade existed at the
time we removed the FSM, we might have taken a bit more care with what
would happen in an upgrade situation ... but it didn't.
You could do this via pg_dump and reload, in which case the missing
functions would result in ignorable errors during the reload.
If you want to do it via pg_upgrade, I think the most practical way
is to drop the whole pg_freespacemap extension (ie, run its uninstall
script) in your 8.3 installation, then do the upgrade, then install
9.1's version of the extension if you still want it.
regards, tom lane
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: tgl@sss.pgh.pa.us, sayeed.anjum@gmail.com
Subject: Re: pg_upgrade: error when migrating from 8.3 to 9.1
In-Reply-To: <17931.1326648501@sss.pgh.pa.us>
* 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