Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] make postgresql 9.5 default on centos 7

[GENERAL] make postgresql 9.5 default on centos 7

From
Steve Clark
Date:
Hi List,

I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
9.2 version that comes with CentOS 7.

Is there a simple way to fix this so the 9.5 version of tools and libraries are used.

Thanks,
Steve

Re: [GENERAL] make postgresql 9.5 default on centos 7

From
Melvin Davidson
Date:


On Fri, Aug 18, 2017 at 1:50 PM, Steve Clark <steve.clark@netwolves.com> wrote:
Hi List,

I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
9.2 version that comes with CentOS 7.

Is there a simple way to fix this so the 9.5 version of tools and libraries are used.

Thanks,
Steve



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


> Is there a simple way to fix this so the 9.5 version of tools and libraries are used.


Have you looked at the PGPORT environment variable?
https://www.postgresql.org/docs/9.5/static/libpq-envars.html


Also 
PATH=/usr/local/pgsql/bin:$PATH
export PATH

https://www.postgresql.org/docs/9.1/static/install-post.html

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

Re: [GENERAL] make postgresql 9.5 default on centos 7

From
Scott Marlowe
Date:
On Fri, Aug 18, 2017 at 11:50 AM, Steve Clark <steve.clark@netwolves.com> wrote:
> Hi List,
>
> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
> 9.2 version that comes with CentOS 7.
>
> Is there a simple way to fix this so the 9.5 version of tools and libraries are used.

As Melvin mentions, psql and most clients default to looking on port
5432 for PostgreSQL. You can either set $PGPORT envar to the port that
9.5 is running on, or edit the postgresql.conf for each service and
swap the ports listed, so that 9.2 runs on the new port (likely 5433)
and 9.5 runs on the default port of 5432.

Re: [GENERAL] make postgresql 9.5 default on centos 7

From
Alexander Farber
Date:
Hi Steve,

On Fri, Aug 18, 2017 at 7:50 PM, Steve Clark <steve.clark@netwolves.com> wrote:

I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
9.2 version that comes with CentOS 7.

Is there a simple way to fix this so the 9.5 version of tools and libraries are used.


to use PostgreSQL 9.6 on CentOS 7 -

first delete the postgresql packages coming with CentOS 7 by using "yum erase ...." command and then:

rpm -Uvh https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm
yum install postgresql96-server
systemctl initdb postgresql-9.6
systemctl enable postgresql-9.6
systemctl start postgresql-9.6
systemctl status -l postgresql-9.6

Regards
Alex

Re: [GENERAL] make postgresql 9.5 default on centos 7

From
Alexander Farber
Date:
Oops, one correction - instead of

    systemctl initdb postgresql-9.6

please use

    /usr/pgsql-9.6/bin/postgresql96-setup initdb

as explained at https://wiki.postgresql.org/wiki/YUM_Installation

Regards

Alex

Re: [GENERAL] make postgresql 9.5 default on centos 7

From
Devrim Gündüz
Date:
Hi,

On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote:
> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
> 9.2 version that comes with CentOS 7.
>
> Is there a simple way to fix this so the 9.5 version of tools and libraries
> are used.

yum remove postgresql-*
yum reinstall postgresql95*

will do the trick. Please note that the second one will restart the database,
so make sure that you run these in a maintenance period.

The first command will remove all OS PostgreSQL packages. This is a required
step to remove actual binaries from OS. The second command will reinstall the
packages, and they will create alternatives entries for the binaries, etc.

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

Re: [GENERAL] make postgresql 9.5 default on centos 7

From
Scott Marlowe
Date:
On Tue, Aug 22, 2017 at 12:44 PM, Devrim Gündüz <devrim@gunduz.org> wrote:
>
> Hi,
>
> On Fri, 2017-08-18 at 13:50 -0400, Steve Clark wrote:
>> I loaded 9.5 on CentOS 7 but by default every thing wants to use the default
>> 9.2 version that comes with CentOS 7.
>>
>> Is there a simple way to fix this so the 9.5 version of tools and libraries
>> are used.
>
> yum remove postgresql-*
> yum reinstall postgresql95*
>
> will do the trick. Please note that the second one will restart the database,
> so make sure that you run these in a maintenance period.
>
> The first command will remove all OS PostgreSQL packages. This is a required
> step to remove actual binaries from OS. The second command will reinstall the
> packages, and they will create alternatives entries for the binaries, etc.

Centos and Yum have supported multiple versions of PostgreSQL for
quite some time now. Just change the ports in their respective
postgresql.conf files and start them up.