The Postgres-XL community has released a new version of the software, tagged as 9.5r1.1. This is a minor update to earlier 9.5r1 release, but contains some very important bug fixes. I would encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from , […]
Auditing Users and Roles in PostgreSQL
/6 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraOne of the services we offer are security reviews (or audits, if you want), covering a range of areas related to security. It may be a bit surprising, but a topic that often yields the most serious issues is roles and privileges. Perhaps the reason why roles and privileges are a frequent source of issues […]
How Postgres-XL is tested
/2 Comments/in Pallavi's PlanetPostgreSQL /by Pallavi SontakkeThe purpose of this blog is to explain the process of Quality Analysis that Postgres-XL goes through internally at 2ndQuadrant. Here, I describe the bare minimum tests that each release goes through, not to mention the other tests carried out by many 2ndQuadrant and other community members. Regression tests are carried out to ensure […]
Using Java arrays to insert, retrieve, & update PostgreSQL arrays
/0 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidPGLogical 1.1 packages for PostgreSQL 9.6beta1
/0 Comments/in 2ndQuadrant, Petr's PlanetPostgreSQL, pglogical, PostgreSQL /by Petr JelinekWe have made pglogical 1.1 packages available for PostgreSQL 9.6beta1 for both rpm and deb based distributions. They are available for install from our standard pglogical package repository. You may ask why do we release packages for beta version of Postgres? Well, one of the reasons is that you can use pglogical to replicate your […]
Postgres-XL 9.5r1.1 released
/0 Comments/in 2ndQuadrant, Pavan's PlanetPostgreSQL /by Pavan DeolaseeThe Postgres-XL community has released a new version of the software, tagged as 9.5r1.1. This is a minor update to earlier 9.5r1 release, but contains some very important bug fixes. I would encourage everyone to immediately upgrade to this latest release. Being a minor release, you only need to download the latest sources from , […]
Waiting for Barman 1.6.1
/1 Comment/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniThe upcoming version 1.6.1 of Barman will introduce a few interesting new features which consolidate its central role in business continuity installations of PostgreSQL databases. Discover why.
Visual PostgreSQL debugging
/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringerHaving recently been doing some debugging work where many watchpoints, conditional breakpoints etc were necessary I’d like to shout out to a really useful tool: The standalone CDT debugger. It’s part of the Eclipse project, but before you run screaming – it doesn’t require project setup or anything and it serves as a good GUI […]
PGLogical 1.1 released with sequence support and more
/0 Comments/in Petr's PlanetPostgreSQL, pglogical /by Petr JelinekThe new feature version of pglogical is now available. The new release brings support for sequence replication, manually configured parallel subscriptions, replica triggers, numerous usability improvements and bug fixes. Let’s look into the changes in more detail.
Don’t set fsync=off if you want to keep your data
/3 Comments/in Craig's PlanetPostgreSQL /by craig.ringerThere are a lot of amazing features coming in PostgreSQL 9.6, but I’m personally very happy about a really small, simple one that helps close a long-standing user foot-gun. commit a31212b429cd3397fb3147b1a584ae33224454a6 Author: Robert Haas Date: Wed Apr 27 13:46:26 2016 -0400 Change postgresql.conf.sample to say that fsync=off will corrupt data. Discussion: [email protected] Per a suggestion […]
Column Store Plans
/5 Comments/in 2ndQuadrant, Alvaro's PlanetPostgreSQL, PostgreSQL /by Álvaro HerreraOver at pgsql-general, Bráulio Bhavamitra asks: I wonder if there is any plans to move postgresql entirely to a columnar store (or at least make it an option), maybe for version 10? This is a pretty interesting question. Completely replacing the current row-based store wouldn’t be a good idea: it has served us extremely well […]