From: Thomas F. O'Connell <tfo@sitening.com>
To: PGSQL Admin <pgsql-admin@postgresql.org>
Cc: Helbling Julien <Julien.Helbling@cpln.ch>
Subject: Re: Migration from 8.0.2 to 8.1.0
Date: Wed, 18 Jan 2006 14:23:50 -0600
Message-ID: <7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.com> (raw)
In-Reply-To: <3E2CA694B71ECB45B3486CE93F8B956E8C9048@back-mail.cpln.ch>
References: <3E2CA694B71ECB45B3486CE93F8B956E8C9048@back-mail.cpln.ch>
On Dec 12, 2005, at 12:49 AM, Helbling Julien wrote:
> Postgres 8.0.2 for Windows is install on a Microsoft Windows Server
> 2003 system. The installation was made with all the default values.
>
> We made a backup of one of our database with the following
> instruction :
> pg_dump –i –h serverName –p 5432 –U userName –W password –F c
> backupFileName databaseName
>
> What we want to do is to migrate this database on a 8.1.0 version.
> For that we did install postgres 8.1.0 on the same computer but on
> the port 5433 and then we tried to make a restore with te following
> command :
> pg_restore -i -h serverName -p 5433 -U userName -d databaseName
> backupFileName
>
> Because a couple of functions couldn't be created during the
> restore we got many problems. All those functions are in the public
> scheme of the version 8.0.2.
>
> We've seen some options did change during the installation of the
> version 8.1.0. For exemple :
>
> - We can not chose any more to install the modul "DBsize" which was
> install with the version 8.0.2.
> - The modul "support of pgAdmin" is now called pgAdmin81 (the
> library's name is admin81.dll).
>
> Because of those two things the two library dbsize.dll and
> admin.dll are not install in the lib directory ant certain function
> needs those two library.
>
> Of course we could copy all the missing library in the right
> directory but that looks to not be really "professionnal".
>
> Here is the main question :
>
> - Is is possible during the installation of the version 8.1.0 for
> Windows to install some options which will "help" the compatibility
> between the version 8.1.0 and 8.0.2 ?
>
> Julien
Helbling, I never saw a reply that addressed this, but the dbsize
stuff moved from contrib into the backend for 8.1.
http://www.postgresql.org/docs/8.1/static/functions-
admin.html#FUNCTIONS-ADMIN-DBSIZE
As far as I know, the errors you get during restore if the old
functions aren't there are non-fatal. But any code that references
the old functions should be updated to use the newly named functions
that correspond to the old ones.
--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)=
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tfo@sitening.com, Julien.Helbling@cpln.ch
Subject: Re: Migration from 8.0.2 to 8.1.0
In-Reply-To: <7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.com>
References: <3E2CA694B71ECB45B3486CE93F8B956E8C9048@back-mail.cpln.ch> <7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.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