X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 797E99DC87F for ; Wed, 18 Jan 2006 16:23:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19121-07 for ; Wed, 18 Jan 2006 16:23:56 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from chilco.textdrive.com (chilco.textdrive.com [207.7.108.242]) by postgresql.org (Postfix) with ESMTP id F18D29DCA08 for ; Wed, 18 Jan 2006 16:23:52 -0400 (AST) Received: from [192.168.15.104] (unknown [209.149.57.250]) by chilco.textdrive.com (Postfix) with ESMTP id 95C1EDB7D3; Wed, 18 Jan 2006 20:24:16 +0000 (UTC) In-Reply-To: <3E2CA694B71ECB45B3486CE93F8B956E8C9048@back-mail.cpln.ch> References: <3E2CA694B71ECB45B3486CE93F8B956E8C9048@back-mail.cpln.ch> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: multipart/alternative; boundary=Apple-Mail-12-394840944 Message-Id: <7B9E0127-3071-4F4D-A367-0F4D55960FD4@sitening.com> Cc: Helbling Julien From: "Thomas F. O'Connell" Subject: Re: Migration from 8.0.2 to 8.1.0 Date: Wed, 18 Jan 2006 14:23:50 -0600 To: PGSQL Admin X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.136 required=5 tests=[AWL=1.135, HTML_MESSAGE=0.001] X-Spam-Score: 1.136 X-Spam-Level: * X-Archive-Number: 200601/198 X-Sequence-Number: 20286 --Apple-Mail-12-394840944 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed On Dec 12, 2005, at 12:49 AM, Helbling Julien wrote: > Postgres 8.0.2 for Windows is install on a Microsoft Windows Server =20= > 2003 system. The installation was made with all the default values. > > We made a backup of one of our database with the following =20 > instruction : > pg_dump =96i =96h serverName =96p 5432 =96U userName =96W password =96F= c =20 > backupFileName databaseName > > What we want to do is to migrate this database on a 8.1.0 version. =20 > For that we did install postgres 8.1.0 on the same computer but on =20 > the port 5433 and then we tried to make a restore with te following =20= > command : > pg_restore -i -h serverName -p 5433 -U userName -d databaseName =20 > backupFileName > > Because a couple of functions couldn't be created during the =20 > restore we got many problems. All those functions are in the public =20= > scheme of the version 8.0.2. > > We've seen some options did change during the installation of the =20 > version 8.1.0. For exemple : > > - We can not chose any more to install the modul "DBsize" which was =20= > install with the version 8.0.2. > - The modul "support of pgAdmin" is now called pgAdmin81 (the =20 > library's name is admin81.dll). > > Because of those two things the two library dbsize.dll and =20 > admin.dll are not install in the lib directory ant certain function =20= > needs those two library. > > Of course we could copy all the missing library in the right =20 > 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 =20 > Windows to install some options which will "help" the compatibility =20= > between the version 8.1.0 and 8.0.2 ? > > Julien Helbling, I never saw a reply that addressed this, but the dbsize =20 stuff moved from contrib into the backend for 8.1. http://www.postgresql.org/docs/8.1/static/functions-=20 admin.html#FUNCTIONS-ADMIN-DBSIZE As far as I know, the errors you get during restore if the old =20 functions aren't there are non-fatal. But any code that references =20 the old functions should be updated to use the newly named functions =20 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)= --Apple-Mail-12-394840944 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=WINDOWS-1252

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.
=A0
=
We= made a backup of one of our database with the following instruction = :
=A0pg_dump =96i =96h=A0serverName =96p 5432 = =96U=A0userName =96W password =96F c=A0backupFileName = databaseName
=A0
=
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 :
=A0pg_restore -i -h serverName -p 5433 -U = userName -d databaseName backupFileName
=A0
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.
=A0
We've seen = some options did change during the installation of the version 8.1.0. = For exemple :
=A0
=
- = 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).
=A0
=
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.
=A0
Of course = we could copy all the missing library in the right directory but that = looks to not be really "professionnal".
=A0
Here=A0is = the main question=A0:
=A0
=
- = 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 ?
=A0
=
Julien
=
Helbling, I never saw a reply that addressed this, but the = dbsize stuff moved from contrib into the backend for 8.1.


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

11= 0 30th Avenue North, Suite 6
Nashville, TN = 37203-6320
615-260-0005 (cell)
615-469-5150 = (office)
615-469-5151 (fax)
= --Apple-Mail-12-394840944--