Friday, February 15

Author: Umair Shahid

Postgres-XL 9.5: Gearing Towards the Beta Release

Umair's PlanetPostgreSQL
PostgreSQL has typically been described as an OLTP-friendly database and has generally been put to the side for OLAP workloads. While I disagree with this notion to begin with, the new Big Data features of the latest 9.5 release makes such thinking even more obsolete. This is also why I am so excited about the upcoming Beta release of Postgres-XL 9.5. XL, based on PostgreSQL, rose from the phenomenal work done in the GridSQL and PostgresXC projects, that later combined as TransLattice Storm (StormDB). The community actively worked on the project through the 9.2 release, but the activity slowed down after that. Until now, that is … when the EU-funded Big Data project, AXLE, brought it back to life and Postgres-XL has now successfully caught up with the recent PostgreSQL 9.5 release, (more…)

The process that created pglogical

pglogical, Umair's PlanetPostgreSQL
pglogical (logical replication for PostgreSQL) is the latest in the series of awesome products developed & supported by 2ndQuadrant. One of the key ingredients to making any product great is the process followed in developing it. We have tried to notch up our game with pglogical, let me describe some of the measures we have taken to ensure reliability. Version control Like all our other PostgreSQL tools, pglogical is hosted on 2ndQuadrant's private github. Version control tools like github not only have provisions for team coordination, allowing multiple people to work collaboratively on the same project, they also allow for maintaining multiple branches and multiple tags. This ability is extremely important to be able to support and patch production releases, sending out hotfixes (more…)

Creating a PostgreSQL Service on Ubuntu

Umair's PlanetPostgreSQL
Ok, 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 your server. How do you setup a PostgreSQL service on Ubuntu? Once you get to know it, the process is pretty straightforward. The first step is to create a script. Below is a sample. #!/bin/bash ## EDIT FROM HERE # Installation prefix prefix=/path/to/PostgreSQL # Data directory PGDATA="/path/to/data" # Who to run the postmaster as, usually "postgres". (NOT "root") PGUSER=postgres # Where to keep a log file PGLOG="$PGDATA/serverlog" # It's often a good idea to protect (more…)

Enterprise Support – The final hurdle for PostgreSQL?

Howard's PlanetPostgreSQL, United Kingdom News
It's been an interesting 9 months for me personally, joining the 2ndQuadrant team in April 2013 to lead marketing. I've been particularly impressed by the quality and skills of the people I've met - not just from 2ndQuadrant but also the Postgres Community, from many countries around the world. Of course what has also impressed me is the quality of PostgreSQL.  The more I learn, the more I can see there is a hugely exciting opportunity ahead for everyone involved. What's puzzled me more than anything though is how little I personally knew about Postgres. With 18 years of commercial marketing in the IT industry, I confess I knew little about Postgres until joining 2ndQuadrant, so I'm frequently making comments like 'wow' as I learn more! I'm always intrigued to find out what (more…)