Thread: Help related to Postgresql for RHEL 6.5
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. . -----------------------------------------------------------------------------------------------------------------------
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
Attachment
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 CertifiedEngineer 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. . -----------------------------------------------------------------------------------------------------------------------
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.
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 youoff 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 releasesare 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. . -----------------------------------------------------------------------------------------------------------------------
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.
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.
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