Un événement communautaire Cette année encore 2ndQuadrant aide la communauté PostgreSQL en France en étant Partenaire du pgDay 2017 à Paris Cette journée de conférences, en anglais exclusivement, est une opportunité unique d’en apprendre plus sur le fonctionnement et l’activité de PostgreSQL. Sécurité, benchmarks, supervision, roadmap pour la version 10, réplication, … de nombreux sujets, […]
Corruption in CREATE INDEX CONCURRENTLY
/1 Comment/in Pavan's PlanetPostgreSQL /by Pavan DeolaseeTwo weeks back we discovered an ancient bug in PostgreSQL which may cause index corruption when index is built via CREATE INDEX CONCURRENTLY (aka CIC). All supported releases of PostgreSQL are affected by this bug. The bug could be a source of index corruption reports that we receive from the field once in awhile. Now […]
Problem with Buildfarm registrations fixed
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanRecently we switched the PostgreSQL Buildfarm to use https for its front-facing web transactions. That’s worked pretty well, but one thing got broken in the change. The registration page uses a Captcha to help avoid web spam, which has been a problem in the past. However, the code to fetch the relevant html was still […]
Processing PostgreSQL JSON & JSONB data in Java
/6 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidExplaining CREATE INDEX CONCURRENTLY
/4 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeDataloss at GitLab
/13 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsGitLab, thanks for using PostgreSQL 9.6 and its replication and backup facilities. We’re sorry that you lost your database: http://about.gitlab.com/2017/02/01/gitlab-dot-com-database-incident/ Thank you for posting this publicly to allow us to comment on this for your postmortem analysis. I’m very happy that you monitor Replication Lag, that is good. Replication lag of 4GB is at times […]
pgDay 2017 à Paris: conférence PostgreSQL internationale
/0 Comments/in Cedric's FR PlanetePostgreSQL /by 2ndQuadrant PressUn événement communautaire Cette année encore 2ndQuadrant aide la communauté PostgreSQL en France en étant Partenaire du pgDay 2017 à Paris Cette journée de conférences, en anglais exclusivement, est une opportunité unique d’en apprendre plus sur le fonctionnement et l’activité de PostgreSQL. Sécurité, benchmarks, supervision, roadmap pour la version 10, réplication, … de nombreux sujets, […]
Inserting JSONB data in PostgreSQL 9.6
/0 Comments/in Rubens' PlanetPostgreSQL /by Rubens SouzaThe jsonb_insert function brought in with PostgreSQL 9.6 gives more control when inserting new values into a jsonb array and/or new keys into a jsonb object. This article introduces this new function together with some examples.
repmgr 3.3
/0 Comments/in Ian's PlanetPostgreSQL /by Ian Barwickrepmgr 3.3 introduces a number of additional options for setting up and managing replication clusters, with particular emphasis on cascading replication support. These changes will also make it easier to set up complex clusters using provisioning scripts. Additionally there are changes to the repmgr command line utility’s logging behaviour which you should take into consideration […]
What does pg_start_backup() do?
/5 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsReading mailing lists can damage your health, as I recently discovered on the PostgreSQL Performance list where backup was being discussed. First off, don’t read blogs for finding out critical pieces of info. Read the docs because they are accurate, fully reviewed and well maintained. I should add that I was the initial author of […]
The rds_superuser role isn’t that super
/6 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanThe Amazon RDS documentation blithely contains this statement: “When you create a DB instance, the master user system account that you create is assigned to the rds_superuser role. The rds_superuser role is similar to the PostgreSQL superuser role (customarily named postgres in local instances) but with some restrictions.” But just how super is it? One […]