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)

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

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

PostgreSQL 9.5: IMPORT FOREIGN SCHEMA

In PostgreSQL 9.5 will be possible to import a complete schema from an external database, using Foreign Data Wrappers and IMPORT FOREIGN SCHEMA command.

The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4

PostgreSQL 9.4 extends the SQL standard by inserting two new clauses: the WITHIN GROUP and FILTER clauses.

Tablesample In PostgreSQL 9.5

TABLESAMPLE is an SQL SELECT clause that returns a random sample from a table. SQL:2003 defines two…

BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released

Version 0.9.2 of the BDR (Bi-Directional Replication) extension for PosgreSQL has been released. This is a maintenance…

Why should you learn PostgreSQL?

A few weeks ago I asked one of my colleagues why I should learn PostgreSQL. Harald’s answer…

within-group-and-filter

The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4

PostgreSQL 9.4 extends the SQL standard by inserting two new clauses that facilitate many operations required during…

import-foreign-schema

PostgreSQL 9.5: IMPORT FOREIGN SCHEMA

The release of PostgreSQL 9.5 is imminent so the time has come to analyse what’s new in…

PostgreSQL anti-patterns: Unnecessary json/hstore dynamic columns

PostgreSQL has json support – but you shouldn’t use it for the great majority of what you’re…

robot-slide

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

In the second part of the Automating Barman with Puppet series we configured, via Puppet, two virtual…

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…

12345Next ›Last »