Karanbir Singh wrote: >> On a side note, I have made a similar "pq3" package for upgrading >> from PostgreSQL 7.x to PostgreSQL 8.x - how would I go about to >> submit this RPM as an enhancement package to the CentOS project ? >> (it provides the old /usr/lib/libpq.so.3, for package compatibility) > > Excellent! > > Upload the .src.rpm's somewhere on the net and drop an email here to > the list. What we might also need, along with this package, is the > entire pgsql rpm set - so that people can just enable the repl, and > yum update to pgsql 8. It's based on the original postgresql package, so for that I used: http://mirror.centos.org/centos-4/4.2/os/SRPMS/postgresql-7.4.8 -1.RHEL4.1.src.rpm The new spec file for the compat lib can be found at this location: http://www.algonet.se/~afb/rpm/pq3.spec Also needs a similar package for CentOS 3, using the 7.3.10 RPM (still TODO) http://mirror.centos.org/centos-3/3.6/os/SRPMS/rh-postgresql-7.3.10 -2.src.rpm And for the updated PostgreSQL 8.x RPMS, I used the vendor's packages: http://www.postgresql.org/ftp/binary/ (there are SRPMS in there too, despite the "binary" directory name...) BTW; I'm pretty sure you need to do a full database dump before doing such a major upgrade, but it's been a while since I tried. But the PostgreSQL documentation should say all about that issue. http://www.postgresql.org/docs/faqs.FAQ.html#item3.6 --anders