Re: Cluster fencing tool/software for PostgreSQL cluster with streaming replication
On Mon, 16 Aug 2021 11:31:23 +0100 Vikas Sharma wrote: > Hi, > > I am planning for an enterprise grade PostgreSQL cluster and so looking for > the tool/softwares which will do the cluster management or fencing to avoid > split brain. Look at Pacemaker, pro support and devel by both RedHat and Suse. Depending on the stack you want to build, you might want to use the pgsql official resource agent or PAF (https://clusterlabs.github.io/PAF/). This specific agent might not be supported by RH/Suse though. Regards,
DataDirect PostgreSQL
Hello Team, Good day!!! We are using source as PostgreSQL with Power BI reports. We have established connection and created test dashboard in the PowerBI report. But we have installed trial for Progress DataDirect PostgreSQL. So now we need to use full version of DataDirect PostgreSQL. Could you please give us the information about full version of DataDirect PostgreSQL. Will this purchase and use the s/w or what is the process. Thanks, Jag DISCLAIMER: This e-mail is for the intended recipient only. If you have received it by mistake please let us know by reply and then delete it from your system; access, disclosure, copying, distribution or reliance on any of it by anyone else is prohibited. If you as intended recipient have received this e-mail incorrectly, please notify the sender (via e-mail) immediately.
Re: DataDirect PostgreSQL
> > Hello Team, > Good day!!! > > We are using source as PostgreSQL with Power BI reports. We have established > connection and created test dashboard in the PowerBI report. But we have > installed trial for Progress DataDirect PostgreSQL. > So now we need to use full version of DataDirect PostgreSQL. > Could you please give us the information about full version of DataDirect > PostgreSQL. Will this purchase and use the s/w or what is the process. > > Thanks, > Jag Why do you expect postgres folks to know about Datadirect product? You should ask Datadirect.
Re: DataDirect PostgreSQL
On Wed, 25 Aug 2021 at 15:16, jagadeeshwaraiah, Govindu < govindu.jagadeeshwara...@dsm.com> wrote: > Hello Team, > > Good day!!! > > > > We are using source as PostgreSQL with Power BI reports. We have > established connection and created test dashboard in the PowerBI report. > But we have installed *trial for Progress DataDirect PostgreSQL*. > > So now we need to use full version of DataDirect PostgreSQL. > > Could you please give us the information about full version of DataDirect > PostgreSQL. Will this purchase and use the s/w or what is the process. > > > > Thanks, > > Jag > I didn't even know there was a commercial ODBC driver for PostgreSQL, I've always used the open source one which can be downloaded here: https://odbc.postgresql.org/ However if you do want to purchase the commercial driver, you'll probably need to use the Contact Us or How To Buy links here: https://www.progress.com/odbc/postgresql Oliver
Supported RHEL version for PostgreSQL 11
Hi All, I would like to clarify on OS upgrade for PostgreSQL. Currently we are on PostgreSQL 9.6 on RHEL 7.5. We would like to do a direct upgrade from RHEL 7.5 to RHEL 8.4 and then upgrade PostgreSQL 9.6 to PostgreSQL 11. Is it ok to do a direct upgrade from RHEL 7.5 to RHEL 8.4 Is PostgreSQL 11 compatible with RHEL 8.4 Regards, Gunar
Re: Supported RHEL version for PostgreSQL 11
On Wed, Aug 25, 2021 at 11:47:57PM +0800, Sudhir Guna wrote: > Hi All, > > I would like to clarify on OS upgrade for PostgreSQL. > > Currently we are on PostgreSQL 9.6 on RHEL 7.5. We would like to do a > direct upgrade from RHEL 7.5 to RHEL 8.4 and then upgrade PostgreSQL 9.6 to > PostgreSQL 11. > > Is it ok to do a direct upgrade from RHEL 7.5 to RHEL 8.4 Please describe what you mean by a "direct upgrade" ? You should be careful, since the sort order of indexes can change: https://wiki.postgresql.org/wiki/Locale_data_changes | Version 8 uses the new locale data. Therefore, caution will be necessary when upgrading. > Is PostgreSQL 11 compatible with RHEL 8.4 How did you install postgres ? Compiled from source ? Using RHEL packages ? Using PGDG packages ? PDDG has pacakges for PG11/RH8 https://yum.postgresql.org/rpmchart/#pg11 -- Justin
lower() and unaccent() not leakproof
Hi, lower() and unaccent() (and most string functions) are not marked as leakproof. Is this due to possible locale / character encoding errors they might encounter?
Re: lower() and unaccent() not leakproof
On Wednesday, August 25, 2021, Christophe Pettus wrote: > > lower() and unaccent() (and most string functions) are not marked as > leakproof. Is this due to possible locale / character encoding errors they > might encounter? > > I think you are partially correct. Its due to the fact that error messages, regardless of the root cause, result in the printing of the input value in the error message as context, thus exists a leak via a violation of “ It reveals no information about its arguments other than by its return value. ” David J.
