On Sun, 2006-04-09 at 23:49 +0900, Mark Sargent wrote:

Jim Perrin wrote:

...

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.....

[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

Seems the same as before

...

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.

[racket@ibmlap postgresql]$ sudo /usr/bin/yum remove postgresql* Password: Setting up Remove Process No Match for argument: postgresql-8.1.3.tar.bz2 No Match for argument: postgresql-server-8.1.2-1.c4.i386.rpm No Match for argument: postgresql-8.1.2-1.c4.i386.rpm Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check Setting up repositories addons 100% |=========================| 951 B 00:01 dag 100% |=========================| 1.1 kB 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-server.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check

Dependencies Resolved

============================================================================= Package Arch Version Repository Size ============================================================================= Removing: postgresql i686 8.1.3-1PGDG installed 11 M Removing for dependencies: postgresql-server i686 8.1.3-1PGDG installed 16 M

Transaction Summary

Install 0 Package(s) Update 0 Package(s) Remove 2 Package(s) Total download size: 0 Is this ok [y/N]: y Downloading Packages: Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction 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 Removing : postgresql ######################### [1/2]

Removed: postgresql.i686 0:8.1.3-1PGDG Dependency Removed: postgresql-server.i686 0:8.1.3-1PGDG Complete!

[racket@ibmlap postgresql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 29 kB 00:00 c4-testing: ################################################## 109/109 Added 109 new packages, deleted 0 old in 5.50 seconds Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql to pack into transaction set. postgresql-8.1.2-1.c4.i38 100% |=========================| 110 kB 00:01 ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Finished Dependency Resolution Error: Missing Dependency: postgresql = 8.1.3 is needed by package postgresql-server

yum remove postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG

(the above is one line)

If that has everything remove cleanly ... then try the install with yum.