Skip site navigation (1) Skip section navigation (2)

pg_upgrade: error when migrating from 8.3 to 9.1

From: sayeed <sayeed(dot)anjum(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_upgrade: error when migrating from 8.3 to 9.1
Date: 2012-01-15 11:54:46
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
I am trying to upgrade a database from postgresql 8.3.8 to 9.1. (Ubuntu 10.10

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

The code at line 85146 is as follows:

CREATE FUNCTION pg_freespacemap_pages() RETURNS SETOF record
    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:
Sent from the PostgreSQL - admin mailing list archive at


pgsql-admin by date

Next:From: Tom LaneDate: 2012-01-15 17:28:21
Subject: Re: pg_upgrade: error when migrating from 8.3 to 9.1
Previous:From: Priya GDate: 2012-01-13 10:39:59

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group