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