Help related to Postgresql for RHEL 6.5

Started by Yogesh Sharmaover 11 years ago8 messagesgeneral
Jump to latest
#1Yogesh Sharma
Yogesh1.Sharma@nectechnologies.in

Dear All,

I want to upgrade RHEL 5.4 to RHEL 6.5.
So, could you please let me know, which postgresql version is stable for RHEL 6.5?

Regards,
Yogesh

DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended
for the named recipient(s) only.
It shall not attach any liability on the originator or NEC or its
affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the
opinions of NEC or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of
this message without the prior written consent of the author of this e-mail is
strictly prohibited. If you have
received this email in error please delete it and notify the sender
immediately. .
-----------------------------------------------------------------------------------------------------------------------

#2Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Yogesh Sharma (#1)
Re: Help related to Postgresql for RHEL 6.5

Hi,

On Thu, 2014-08-28 at 03:22 +0000, Yogesh. Sharma wrote:

I want to upgrade RHEL 5.4 to RHEL 6.5.
So, could you please let me know, which postgresql version is stable
for RHEL 6.5?

Any supported PostgreSQL version is available in the yum repository:

http://yum.postgresql.org

You can use 9.3, for example.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

#3Yogesh Sharma
Yogesh1.Sharma@nectechnologies.in
In reply to: Devrim GÜNDÜZ (#2)
Re: Help related to Postgresql for RHEL 6.5

Dear All,

Compatibility issues of 9.3 are more.
So, please guide which version is suitable.

Regards,
Yogesh

-----Original Message-----
From: Devrim Gündüz [mailto:devrim@gunduz.org]
Sent: Thursday, August 28, 2014 7:34 PM
To: Yogesh. Sharma
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help related to Postgresql for RHEL 6.5

Hi,

On Thu, 2014-08-28 at 03:22 +0000, Yogesh. Sharma wrote:

I want to upgrade RHEL 5.4 to RHEL 6.5.
So, could you please let me know, which postgresql version is stable
for RHEL 6.5?

Any supported PostgreSQL version is available in the yum repository:

http://yum.postgresql.org

You can use 9.3, for example.

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended
for the named recipient(s) only.
It shall not attach any liability on the originator or NEC or its
affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the
opinions of NEC or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of
this message without the prior written consent of the author of this e-mail is
strictly prohibited. If you have
received this email in error please delete it and notify the sender
immediately. .
-----------------------------------------------------------------------------------------------------------------------
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4David G. Johnston
david.g.johnston@gmail.com
In reply to: Yogesh Sharma (#3)
Re: Help related to Postgresql for RHEL 6.5

Yogesh. Sharma wrote

Compatibility issues of 9.3 are more.
So, please guide which version is suitable.

Compatibility as in the multixact issues or does your software not work with
9.3 changes?

What about "any supported version" and the provided link is unclear?

There is no way for us to evaluate suitability for your specific need unless
you provide lots more info. If 9.3 scares you off then use 9.2

Are you currently using PostgreSQL?

If you are referring to distro-supported versions (which Debian uses in my
case) you should make that requirement specific. The PostgreSQL community
feels all their officially supported releases are stable.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Help-related-to-Postgresql-for-RHEL-6-5-tp5816742p5816840.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

#5Yogesh Sharma
Yogesh1.Sharma@nectechnologies.in
In reply to: David G. Johnston (#4)
Re: Help related to Postgresql for RHEL 6.5

Dear David,

Are you currently using PostgreSQL?

Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in verion 9.0 I found least Compatibilities.

So, please guide me.

Regards,
Yogesh

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of David G Johnston
Sent: Friday, August 29, 2014 9:22 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Help related to Postgresql for RHEL 6.5

Yogesh. Sharma wrote

Compatibility issues of 9.3 are more.
So, please guide which version is suitable.

Compatibility as in the multixact issues or does your software not work with
9.3 changes?

What about "any supported version" and the provided link is unclear?

There is no way for us to evaluate suitability for your specific need unless you provide lots more info. If 9.3 scares you off then use 9.2

Are you currently using PostgreSQL?

If you are referring to distro-supported versions (which Debian uses in my
case) you should make that requirement specific. The PostgreSQL community feels all their officially supported releases are stable.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Help-related-to-Postgresql-for-RHEL-6-5-tp5816742p5816840.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended
for the named recipient(s) only.
It shall not attach any liability on the originator or NEC or its
affiliates. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect the
opinions of NEC or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of
this message without the prior written consent of the author of this e-mail is
strictly prohibited. If you have
received this email in error please delete it and notify the sender
immediately. .
-----------------------------------------------------------------------------------------------------------------------

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

#6Alan Hodgson
ahodgson@simkin.ca
In reply to: Yogesh Sharma (#5)
Re: Help related to Postgresql for RHEL 6.5

On Friday, August 29, 2014 04:14:35 AM Yogesh. Sharma wrote:

Dear David,

Are you currently using PostgreSQL?

Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in
verion 9.0 I found least Compatibilities.

Any of the currently maintained PostgreSQL versions will run fine on RHEL 6.5 -
that would be the latest release of any version from 9.0 up.

Only you can test and find out if your application(s) will need changes to work
with those versions.

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

#7David G. Johnston
david.g.johnston@gmail.com
In reply to: Yogesh Sharma (#5)
Re: Help related to Postgresql for RHEL 6.5

Yogesh. Sharma wrote

Dear David,

Are you currently using PostgreSQL?

Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in
verion 9.0 I found least Compatibilities.

So, please guide me.

Regards,

Guidance is why we write documentation. if you have specific questions or
concerns after reading the documentation you can ask here.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Help-related-to-Postgresql-for-RHEL-6-5-tp5816742p5816876.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

#8Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Yogesh Sharma (#5)
Re: Help related to Postgresql for RHEL 6.5

On 08/28/2014 09:14 PM, Yogesh. Sharma wrote:

Dear David,

Are you currently using PostgreSQL?

Currently we are using PostgreSQL 8.1.18 version on RHEL 5.8.
Now we plan to update this to PostgreSQL 9.0 version with RHEL6.5. As in verion 9.0 I found least Compatibilities.

So what are the things you are concerned about?

So, please guide me.

If you are going from 8.1 to any supported version you will be dealing
with the type casting changes introduced in 8.3

http://www.postgresql.org/docs/9.3/interactive/release-8-3.html

E.97.2.1. General

Non-character data types are no longer automatically cast to TEXT
(Peter, Tom)

I would spend some time testing that.

Regards,
Yogesh

--
Adrian Klaver
adrian.klaver@aklaver.com

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