Monday, November 12

Tag: postgresql 9.3

Announcing Barman 1.3.0

Announcing Barman 1.3.0

Barman, International News
Version 1.3.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, making the tool more robust through a new code infrastructure in terms of output, subprocesses, remote commands, file system, events (‘hooks’) and metadata management. Barman now supports: hook scripts before and after archiving a WAL file network compression of remote backup and recovery operations immediate checkpoint at backup time Read the full announcement at http://www.pgbarman.org/barman-1-3-0-released/. Many thanks for funding towards the development of this release go to Ecometer (www.ecometer.it), Agile Business Group (www.agilebg.com) and a French company (that prefers to remain anonymous). About Barman Barman (Backup and Recovery Manager) is an open source (more…)
Announcing Barman 1.2.3

Announcing Barman 1.2.3

Barman, International News
Version 1.2.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released, adding support for the upcoming PostgreSQL 9.3. Read the full announcement at http://www.pgbarman.org/barman-1-2-3-released/. About Barman Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most requested features include backup catalogues, retention policies, remote recovery, archiving and compression of WAL files and backups (more…)

PostgreSQL 9.3 development: Array ELEMENT Foreign Keys

Gabriele's PlanetPostgreSQL
As my French colleague Dimitri Fontaine was pointing out a few days ago, PostgreSQL 9.2 is out. This is another great release for PostgreSQL, but we are already ahead in the development of the next release: PostgreSQL 9.3. The Italian team of 2ndQuadrant has been working since last year on adding a new feature to PostgreSQL: support of referential integrity between the elements of an array in a table (referencing) and the records of another table (referenced). We renamed it "Array ELEMENT foreign keys" - thanks to the feedback received from the hackers list. As you may have guessed, it is not part of the SQL standard. We have submitted a patch for 9.3, but currently it is still missing a reviewer. (more…)