Solved

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

Posted on 2014-04-08
10
1,126 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
ID: 39987633
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
ID: 39989503
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
ID: 39989595
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 22

Expert Comment

by:earth man2
ID: 39989980
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 62

Expert Comment

by:gheist
ID: 39997883
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
 
LVL 2

Expert Comment

by:Jack Frost
ID: 40021099
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 62

Expert Comment

by:gheist
ID: 40021349
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
ID: 40024103
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 62

Expert Comment

by:gheist
ID: 40024156
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
ID: 40061302
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
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.

856 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