As people have been working on merging Postgres-XL with the PostgreSQL 9.5 branch, I’ve been trying out Postgres-XL’s ability to run a decision support-like workload. The DBT-3 test kit, originally developed at the OSDL as a TPC-H derivative, has some new changes so that it can run against Postgres-XL. I’ll describe how to use DBT-3 […]
Emulating row security in PostgreSQL 9.4
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL 9.5 adds declarative row security. You can declare policies on tables and have them enforced automatically – for example, allowing user joe to only see rows with the owner column equal to joe. This is a great feature, and it’s been a long time coming. It didn’t make it into PostgreSQL 9.4, but automatically […]
Creating a PostgreSQL Service on Ubuntu
/2 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidOk, so you have a PostgreSQL distribution on your Ubuntu server. You have created the data directory and initialized the database. Now you want to run the server in a way that users can start, stop, & restart the server in pretty much the same way they do for other daemons and services running on […]
When are we going to contribute BDR to PostgreSQL?
/10 Comments/in Craig's PlanetPostgreSQL /by craig.ringerMy colleagues and I are often asked “when will you (2ndQuadrant) contribute BDR to PostgreSQL?” This makes an interesting assumption: that we have not already done so. We have. Much of BDR has already been contributed to core PostgreSQL, with more to come. All of BDR is under the PostgreSQL license and could be merged […]
Announcing Barman 1.5.1
/0 Comments/in Barman, International News /by Gabriele Bartolini2ndQuadrant is proud to announce the release of version 1.5.1 of Barman, Backup and Recovery Manager for PostgreSQL.
Benchmarking Postgres-XL
/5 Comments/in 2ndQuadrant, Featured, Pavan's PlanetPostgreSQL, PostgreSQL /by Pavan DeolaseeAs you may have noted from my previous blog, the last few months were busy in getting Postgres-XL up-to-date with the latest 9.5 release of PostgreSQL. Once we had a reasonably stable version of Postgres-XL 9.5, we shifted our attention to measure performance of this brand new version of Postgres-XL. Our choice of the benchmark […]
How to find out which PostgreSQL table a file on disk corresponds to
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerAnsible Loves PostgreSQL
/8 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimAnsible is simply great and PostgreSQL is surely awesome, let’s see how they work amazingly together!
Testing Postgres-XL with DBT-3
/6 Comments/in Mark's PlanetPostgreSQL /by Mark WongAs people have been working on merging Postgres-XL with the PostgreSQL 9.5 branch, I’ve been trying out Postgres-XL’s ability to run a decision support-like workload. The DBT-3 test kit, originally developed at the OSDL as a TPC-H derivative, has some new changes so that it can run against Postgres-XL. I’ll describe how to use DBT-3 […]
Getting WAL files from Barman with ‘get-wal’
/1 Comment/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniBarman 1.5.0 enhances the robustness and business continuity capabilities of PostgreSQL clusters, integrating the get-wal command with any standby server’s restore_command. In this blog article I will go over the reasons behind this feature and briefly describe it. One of the initial ideas we had in mind when conceiving Barman was to make it, one […]
Announcing Barman 1.5.0
/0 Comments/in Barman, International News /by Gabriele BartoliniVersion 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released.