an update on that,
[racket@ibmlap postgresql-8.1.3]$ rpm -qa | grep postgresql* postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-server-8.1.3-1PGDG error reading information on service postgresql: No such file or directory error: %preun(postgresql-server-8.1.3-1PGDG.i686) scriptlet failed, exit status 1 [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-8.1.3-1PGDG error: Failed dependencies: postgresql = 8.1.3 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-libs-8.1.3-1PGDG error: Failed dependencies: libpq.so is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 libpq.so.4 is needed by (installed) postgresql-8.1.3-1PGDG.i686 libpq.so.4 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686
If you want to use rpm to do this, then you should run 'rpm -qa postgres*' to see what rpms you need to get rid of, and then rpm -e them all on one line..... OR.. you can do this the easy/proper way with yum and simply do 'yum remove postresql' and let yum do the hard work for you. I'd also recommend using the repository file on dev.centos.org to let yum do the installing for you. There are a couple compat-libs packages you need to make postgresql work with php etc.
-- Any sufficiently advanced technology is indistinguishable from magic. -Arthur C. Clarke