PostgreSQL 9.4 for administrators (part one)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

Ware Yosemite?

Possible issues with PostgreSQL after upgrades of OS X machines to Yosemite (OS X 10.10)

PostgreSQL 9.4 for administrators (part two)

A two-part article to explain the main new features of PostgreSQL 9.4 for administrators

NoSQL with PostgreSQL 9.4 and JSONB

The introduction of JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out

JSONB type performance in PostgreSQL 9.4

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data!

What’s new about Barman 1.4.0?

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver.

Automating Barman with Puppet: it2ndq/barman (part one)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server

Automating Barman with Puppet: it2ndq/barman (part two)

How to automate Barman setup and configuration with Puppet and the it2ndq/barman module to backup a PostgreSQL server (part two)

puppet-barman-part-2

Automating Barman with Puppet: it2ndq/barman (part two)

In the first part of this article we configured Vagrant to execute two Ubuntu 14.04 Trusty Tahr…

Dynamic SQL-level configuration for BDR 0.9.0

The BDR team has recently introduced support for dynamically adding new nodes to a BDR group from…

vagrant-barman

Automating Barman with Puppet: it2ndq/barman (part one)

This is not the first time that 2ndQuadrant has looked at Puppet. Gabriele Bartolini has already written an…

tazzine-barman-fondogrigio

What’s new about Barman 1.4.0?

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver…

slide-json-marco

JSONB type performance in PostgreSQL 9.4

The 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data,…

slide-json-giuseppe

NoSQL with PostgreSQL 9.4 and JSONB

The introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQ” side of this relational…

Barman, Backup and recovery manager for PostgreSQL

Incremental backup with Barman 1.4.0

Today version 1.4.0 of Barman has been officially released. The most important feature is incremental backup support,…

PostgreSQL and Barman

How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver

PostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it…

group of elephants

The CHECK clause for updatable views

Written by Giuseppe Broccolo  First published in Italian   Since PostgreSQL 9.3, it is possible to update…

Japan PostgreSQL Conference 2014

Japan has been an early and vigorous adopter of PostgreSQL (back in 2006, when PostgreSQL was still…

BDR for PostgreSQL: Present and future

For a couple of years now a team at 2ndQuadrant led by Andres Freund have been working…

PostgreSQL 9.4 for administrators (part two)

  Written by Francesco Canovai First published in Italian    In the previous instalment, we introduced the logical…

Progress on online upgrade

In last couple of months I’ve been working on online upgrade for very large databases as part…

All-processes breakpoints / watchpoints for PostgreSQL

Sometimes SELECT pg_backend_pid() and gdb‘s attach aren’t enough. You might have a variable in shared memory that’s…

Group photo PGDayIT

Italian PGDay, eighth edition: over 120 attendees!

November 7th 2014 was the eighth Italian PostgreSQL Day, the national event dedicated to the promotion of…

PostgreSQL 9.4 for administrators (part one)

Written by Francesco Canovai     Version 9.4 of PostgreSQL, soon to be released, has many innovations for…

123456789