Thread: Migration from 8.0.2 to 8.1.0

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