Migration from 8.0.2 to 8.1.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux