Solved

How do I Remove Postgre 8.1.11 with dependancies?

Posted on 2010-11-16
8
278 Views
Last Modified: 2012-05-10
Hi Experts,

       I am trying to remove Postgre 8.1.11 but I'm getting the following failed dependancies:
libpq.so is needed by (installed) postgresql-python-8.1.11.el5_1.1.i38

How do I get past this error?

Thanks, Missymadi
0
Comment
Question by:missymadi
  • 4
  • 4
8 Comments
 
LVL 7

Expert Comment

by:Hatrix76
ID: 34146914
delete all depending packages first:

in this case, delete the package postgresql-python-8.1.11.el5_1.1.i38 before deleting postgres.

I am not 100% sure if there is an more efficient way in cent-os, but at least you can delete all your packages, just make sure to delete the dependencies first.

best
0
 

Author Comment

by:missymadi
ID: 34147132
Will deleting PostgreSQL 8.1.22 package and dependacies cause issues for an updated version of PostgreSQL and its dependancies? This is my goal to have a clean RHEL OS and have the latest version of PostgreSQL 9.0 installed.

Thanks, Missymadi
0
 
LVL 7

Expert Comment

by:Hatrix76
ID: 34147185
No, you won't have any issues. These are packages that depend on postgresql 8.1, which have nothing to do with the 9.1 version.

best
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:missymadi
ID: 34149031
I just tried to remove the dependancy
rm libpq.so.4

error - no such file or directory.
How do I delete dependancies?
0
 
LVL 7

Expert Comment

by:Hatrix76
ID: 34149121
a dependency is also a rpm package.

you have to remove the installed packages. If you have yum installed you can use it to remove all packages including the dependency packages:
yum remove <package name>

I do not know how the package name of postgresql is exactly in redhat, but you can find out by:

rpm -qa | grep -i postgres

this should list all installed packages regarding postgres, you can remove them also with:

rpm -e <packagename1> <packagename2> ... from the list of packages you received from rpm -qa.


best
Ray
0
 

Author Comment

by:missymadi
ID: 34149435
bash grep -i not found error.
0
 

Author Comment

by:missymadi
ID: 34149480
Strange - I entered
rpm -e libpq.so.4   and recieved the following error:
error: Package libpq.so.4 is not installed.
0
 
LVL 7

Accepted Solution

by:
Hatrix76 earned 500 total points
ID: 34149974
you can not delete libpq.so.4, libpq.so.4 is an actual file, which is installed with a package.

try:

rpm -qa

this should give you a list of all installed packages.

then try:

rpm -qa | grep postgre

I do not understand why grep -i should not work on your system, but lets do basics.

rpm -qf /usr/lib/libpq.so.4

this should tell you the name of the package which contains the libpq.so.4 file.


a very good introduction into RPM is here:
http://www.tfug.org/helpdesk/linux/rpm.html

but do not remove the package like:
rpm -e --nodeps <package_name>

because this will leave the dependency packages on your system and this can cause problems in the future!

best
ray
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: http://www.postgresql.org/ (http://www.postgresql.org/) This requires some add-o…
Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

775 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question