Monday, September 24

Gabriele’s PlanetPostgreSQL

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…)
Postgres and devops: testing 9.3 with Vagrant and Puppet – part one

Postgres and devops: testing 9.3 with Vagrant and Puppet – part one

Gabriele's PlanetPostgreSQL
My top #1 open source tool that I have discovered in the last year is definitely Vagrant. Vagrant is a software that helps you build and configure virtual environments for development and testing purposes. Vagrant relies on virtual machine providers such as VirtualBox, VMWare and AWS, as well as provisioning tools such as Chef and Puppet, allowing developers to clearly define their boxes using text files (which then can be easily versioned). (more…)

OSS4B 2013, innovate through Open Source

Gabriele's PlanetPostgreSQL
The traditional Monash University Prato Centre, historical venue of the first European PGDay, will host the first edition of another conference: Open Source Software for Business, aka OSS4B. OSS4B 2013 will take place in Prato, Tuscany, Italy on September 19 and 20. Through the experience gained with several organisations of PostgreSQL related events, we have tried to bring this kind of conference to a higher level, by embracing all open source technologies and services (not just Postgres) which are at the core of ICT enterprises. (more…)