[CentOS] RPM for postgresql 8-* for CentOS4?

[Mark Sargent]

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


Cheers.

Mark Sargent.