Oliver Fuerst wrote:
Hi all, I have the problem that I upgraded Postgresql server to the latest revision 8.0.8. Unfortunately this gave me a compatibility issue where my UNICODE database can be backed-up but not restored as the UNICODE checking routines in 8.0.8 are much more strict (my database contains some characters which the new checking routines reject). I'm running Fedora Core 4 on a Dell PowerEdge 2850 (i386). My question is, if it is possible to downgrade all the Postgres packages to 8.0.7? Best, Oliver Fuerst
I did not do this myself, but some have stated that they dump the database before upgrading to a new version. Then they bring it in to the newer version. You might find information in the archives somewhere. I remember the subject being discussed.
Anyway, to downgrade a package to a previous version, run the --oldpackage flag to rpm. Basically, download the older version and dependent programs to a directory. Then run the below from a root terminal and in the directory where you have the older rpms.
rpm -Uvh --oldpackage *.rpm You should then have the previous version installed. Jim -- Some people live life in the fast lane. You're in oncoming traffic.