Japan has been an early and vigorous adopter of PostgreSQL (back in 2006, when PostgreSQL was still emerging from obscurity in the western hemisphere, I noted that in Tokyo bookstores, PostgreSQL books outweighed MySQL ones by about 5:3), and it’s no surprise that by nationality, only the USA and Germany have more committers. The Japan […]
Automating Barman with Puppet: it2ndq/barman (part two)
/1 Comment/in Barman, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco CanovaiIn the first part of this article we configured Vagrant to execute two Ubuntu 14.04 Trusty Tahr virtual machines, respectively called pg and backup. In this second part we will look at how to use Puppet to set up and configure a PostgreSQL server on pg and back it up via Barman from the backup […]
Dynamic SQL-level configuration for BDR 0.9.0
/1 Comment/in Craig's PlanetPostgreSQL /by craig.ringerThe BDR team has recently introduced support for dynamically adding new nodes to a BDR group from SQL into the current development builds. Now no configuration file changes are required to add nodes and there’s no need to restart the existing or newly joining nodes. This change does not appear in the current 0.8.0 stable […]
Automating Barman with Puppet: it2ndq/barman (part one)
/1 Comment/in Barman, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco CanovaiThis is not the first time that 2ndQuadrant has looked at Puppet. Gabriele Bartolini has already written an article in two parts on how to rapidly configure a PostgreSQL server through Puppet and Vagrant, accompanied by the release of the code used in the example on GitHub (http://github.com/2ndquadrant-it/vagrant-puppet-postgresql).
What’s new about Barman 1.4.0?
/2 Comments/in Barman, Giulio's PlanetPostgreSQL /by Giulio CalacociThe 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver which aim to simplify the life of DBAs and system administrators.
JSONB type performance in PostgreSQL 9.4
/15 Comments/in Marco's PlanetPostgreSQL /by Marco NenciariniThe 9.4 version of PostgreSQL introduces the JSONB data type, a specialised representation of the JSON data, allowing PostgreSQL to be competitive in managing the “lingua franca” of the moment for the exchange of data via web services. It is useful to perform a number of tests to verify its actual performance.
NoSQL with PostgreSQL 9.4 and JSONB
/1 Comment/in Giuseppe's PlanetPostgreSQL /by 2ndQuadrant PressThe introduction of the JSONB data type in PostgreSQL, definitely makes the “NoSQL” side of this relational DBMS come out: this introduction meets the requirements of all those who prefer a data structure in a “key-value” array, dictionary style (widely used in the field of development) and, at the same time, ensures all the advantages […]
Incremental backup with Barman 1.4.0
/1 Comment/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniToday version 1.4.0 of Barman has been officially released. The most important feature is incremental backup support, which relies on rsync and hard links and helps you reduce both backup time and disk space by 50-70%.
How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver
/1 Comment/in Gabriele's PlanetPostgreSQL /by Gabriele BartoliniPostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it is now possible, in an instant, to check the state of the archiving process of transactional logs (WALs), crucial component of a PostgreSQL disaster recovery system.
The CHECK clause for updatable views
/0 Comments/in Giuseppe's PlanetPostgreSQL, PostgreSQL /by 2ndQuadrant PressWritten by Giuseppe Broccolo Since PostgreSQL 9.3, it is possible to update and insert into views directly, so long as the view refers to only one underlying table. PostgreSQL 9.4 allows us to use the CHECK clause for INSERTs into updatable views. For example, consider a table composed of just one integer column; and […]
Japan PostgreSQL Conference 2014
/0 Comments/in Ian's PlanetPostgreSQL /by Ian BarwickJapan has been an early and vigorous adopter of PostgreSQL (back in 2006, when PostgreSQL was still emerging from obscurity in the western hemisphere, I noted that in Tokyo bookstores, PostgreSQL books outweighed MySQL ones by about 5:3), and it’s no surprise that by nationality, only the USA and Germany have more committers. The Japan […]