Solved

Why do I have 2 versions of psql, pg_dump and other tools?

Posted on 2014-04-08
10
1,072 Views
Last Modified: 2014-05-13
Hello experts,

In Scientific Linux 6.3 (haven't tested this in CentOS), why do I have 2 versions of tools such as psql and pg_dump?:
[root@sl ~]# find / -name psql
/usr/bin/psql
/usr/pgsql-9.3/bin/psql

Open in new window

My installation process boils down to these steps:
rpm -i http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-sl93-9.3-1.noarch.rpm
yum install postgresql93-server postgresql93-contrib postgresql-contrib 
service postgresql-9.3 initdb

Open in new window

So when I invoke the tools without an absolute path:

WARNING: psql version 8.4, server version 9.3.

And the most important question would be, how can I fix this in a cleanly manner? I see the following recommendation but its more like a workaround to me:

http://serverfault.com/questions/426480/pg-dump-not-working-do-i-need-to-change-order-of-path
0
Comment
Question by:José Méndez
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 20

Author Comment

by:José Méndez
Comment Utility
Ok I just added this line to the end of my .bashrc :

export PATH=/usr/pgsql-9.3/bin:$PATH

Open in new window


Would still want some input about this method of fixing it, and if someone could please help me understand why are there 2 versions of the tools, that would be awesome.

Thanks,
0
 
LVL 22

Expert Comment

by:earth man2
Comment Utility
IThought you use
rpm -U
to update an installation else you risk a double install.
You can use rpm to uninZstall a package.  Sorry I don't have experience of this flavour of Linux.  I use Fedora.
0
 
LVL 20

Author Comment

by:José Méndez
Comment Utility
the rpm line is meant to install the repo =S, but I get your point, if the software is already there, instead of installing, I'll need to figure out how to update the tools from this new repo I added. Not sure why since the yum command is not specific for the tools
0
 
LVL 22

Expert Comment

by:earth man2
Comment Utility
to relocate default ie default package dir is in conflict with your current install you could try

rpm -i --relocate /usr/pgsql-9.3/bin=/usr/bin packagename.rpm

yum --installroot=<path> install <package>

These tools have a verbose / dry run mode so you can see what files will be acted upon.
0
 
LVL 61

Expert Comment

by:gheist
Comment Utility
You must run correct client to get rid of the warning
Since you installed from postgresql.org rpm, the system included psql is obsolete.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 2

Expert Comment

by:Jack Frost
Comment Utility
You may not have two versions.  You might want to check using ls -l and see if the entry in /usr/bin is a symlink to the actual program.  Many entries in /usr/bin are like that.  It gives you version independent access that survives through updates.
0
 
LVL 61

Expert Comment

by:gheist
Comment Utility
You can have at least 4 versions.... All supported and running at once... (SCL, postgresql.org and one in system)
0
 
LVL 20

Accepted Solution

by:
José Méndez earned 0 total points
Comment Utility
Its the postgresql-contrib package the one that introduces the duplicate tools!!! I am trying to figure out now why that one is needed.
0
 
LVL 61

Expert Comment

by:gheist
Comment Utility
If you post output of "rpm -qa | grep postg" and somebody might be able to help... Otherwise close the question.
0
 
LVL 20

Author Closing Comment

by:José Méndez
Comment Utility
Here are the correct steps to install, taken from www.postgresql.org/download/linux/redhat/, from which I got errors back in like 2012 or something (for Scientific Linux):

yum install http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-sl93-9.3-1.noarch.rpm
yum install postgresql93.x86_64 postgresql93-contrib.x86_64

Now I have
# psql -V
psql (PostgreSQL) 9.3.4

x)

Thanks all!!

P:S.: Gheist you posted 3 times in this thread, none of which had ANY sense. Whats with the power trip telling people to close out their questions if your demands are not met?? LOL
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
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.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

771 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now