Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos? - Mailing list pgsql-general

From Devrim Gündüz
Subject Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos?
Date
Msg-id 1495618107.3655.31.camel@gunduz.org
Whole thread Raw
In response to Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos?  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
Hi,

On Tue, 2017-05-23 at 23:39 -0700, Ken Tanzer wrote:

> Can I also ask y'all a more general question about this, specifically
> related to how Postgres is packaged for RHEL/Centos?  I've got both 9.6 and
> 9.2 installed.  In this case though, it seems that the 9.2 version is
> privileged/selected by default. 

It may happen only if 9.2 is installed via Red Hat RPMs. Otherwise, 9.6 will be
the selected by default for many binaries. If that is your case, you need to:

* Stop 9.2
* Uninstall 9.2 RPMs
* Install 9.2 from PGDG
* Start 9.2
* Stop 9.6
* Reinstall 9.6 (so that the binaries are fixed)
* Start 9.6

>  But psql defaults to the 9.6 version.  Are there other similar things that
> will default to either 9.2 or 9.6? 

These are the binaries that defaults to the higher version when there are more
than 1 major version are installed:

psql
clusterdb
createdb
createlang
createuser
dropdb
droplang
dropuser
pg_basebackup
pg_dump
pg_dumpall
pg_restore
reindexdb
vacuumdb


> And if so, what controls that behavior,

We control this by using alternatives

>  is it easily-changeable, and/or can you go back and forth?

Yes, you check update-alternatives command.

Regards,

--
Devrim Gündüz
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Attachment

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Installing module for 9.6, not 9.2, on Centos?
Next
From: Bill Moran
Date:
Subject: [GENERAL] Current best practice for maximum shared_buffers settings on bighardware?