erick_paper

Well-Known Member
Apr 19, 2005
245
0
166
Hi. I would like to update an RPM (for postgresql). This is what the manual says:

Code:
rpm {-U|--upgrade} [COLOR="#cc0000"][install-options][/COLOR] PACKAGE_FILE .
Now all the rest is fine. I will download the rpm for the 8.2.9 latest pgsql version. But what are the install options? Can I skip them? Is there a way of knowing what the previous rpm of 8.2.3 is currently installed with and just use the same?

Thanks to anyone who knows this stuff!
 

Murtaza_t

Well-Known Member
Jan 24, 2005
476
0
166
Earth
cPanel Access Level
Website Owner
To get the version you can either run:

Code:
]# pgsql -v
OR
Code:
]# rpm -qa | grep sql
this will list all the rpm that has been installed with the name sql in it.

The upgrade command will be:

Code:
]# rpm -Uvh PACKAGE_FILE
 

erick_paper

Well-Known Member
Apr 19, 2005
245
0
166
Thanks so much. Will this change any of my configuration? Can I leave my /conf files and other settings alone? I mean, this will only update the postgresql system programs right?

I ask because "testing" the command shows me these errors:

Code:
[B]rpm -Uvh --test postgresql-8.2.9-1PGDG.rhel4.i386.rpm[/B]
warning: postgresql-8.2.9-1PGDG.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 442df0f8
error: Failed dependencies:
	postgresql = 8.2.3 is needed by postgresql-server-8.2.3-1PGDG.i686
	postgresql = 8.2.3 is needed by (installed) postgresql-contrib-8.2.3-1PGDG.i686
	postgresql = 8.2.3 is needed by (installed) postgresql-devel-8.2.3-1PGDG.i686
	postgresql = 8.2.3 is needed by (installed) postgresql-server-8.2.3-1PGDG.i686
Does this mean that I have to first UNinstall 8.2.3? Or is there a sequence in which I should be doing this?
 
Last edited:

k.agashe

Member
May 23, 2006
12
0
151
Hi,

The errors it is showing are for the failed dependancies. It will not get installed unless the 3-4 dependancies are met.

These are packages which are dependant upon each other, so it will check whether the another is installed . There would be a sequence but you would require all 4 of the packages that is for sure.