pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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)=

view thread (2+ messages)

Message-ID: <7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.com>
Permalink:  ../7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.com/
Also on:    postgresql.org/message-id/7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.com

 · 

reply

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