Wednesday, January 16

Author: Gabriele Bartolini

A long time open-source programmer, Gabriele has been writing Linux/Unix applications in C and C++ for over 10 years, specialising in search engines and web analytics with large databases. Gabriele has a degree in Statistics from the University of Florence. His areas of expertise are data mining and data warehousing, having worked on web traffic analysis in Australia and Italy. Gabriele is a consultant with 2ndQuadrant and an active member of the international PostgreSQL community. Gabriele currently lives in Prato, a small but vibrant city located in the northern part of Tuscany, Italy. His second home is Melbourne, Australia, where he has studied at Monash University and worked in the ICT sector. His hobbies include "calcio" (football or soccer, depending on which part of the world you come from) and playing his Fender Stratocaster electric guitar.
Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring

Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring

Featured, Gabriele's PlanetPostgreSQL
During the last October's Italian PGDay and European PostgreSQL conference, my friend Marco Nenciarini and I had the pleasure to talk about a new open source plugin for PostgreSQL, called redislog. In that presentation ("Integrating PostgreSQL with Logstash for real-time monitoring") we provided an example of our exploration/experimentation approach, with extensive and thorough coverage of testing and benchmarking activities. If you are curious to know more about that process, please refer to the slides of that talk, which are publicly available on Prezi. For the impatient: redislog taps into PostgreSQL's logging facility and allows DBAs to ship log events into a Redis queue, directly in JSON format, and to enter the ELK stack through the first class lane. Devops and the (more…)
Getting WAL files from Barman with ‘get-wal’

Getting WAL files from Barman with ‘get-wal’

Barman, Gabriele's PlanetPostgreSQL
Barman 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 day, a very large basin of WAL files, collected from one or more PostgreSQL servers within the same organisation. The internal codename of this feature was "WAL hub" and, in our mind, its main purpose was to allow any application (e.g. standby) to easily request and receive any WAL file for a given server, by enhancing Barman's command line interface and, ultimately, by implementing server support for PostgreSQL's streaming (more…)
Italian PGDay, eighth edition: over 120 attendees!

Italian PGDay, eighth edition: over 120 attendees!

Gabriele's PlanetPostgreSQL
November 7th 2014 was the eighth Italian PostgreSQL Day, the national event dedicated to the promotion of the world's most advanced open source database. The Italian edition is one of the most enduring in the whole Postgres community (the first one took place in July 2007) and the results of the activity of a very established non profit organisation such as ITPUG (Italian PostgreSQL Users Group). (more…)