The 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.
The 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 […]
Version 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released.
Version 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman now supports concurrent backup from PostgreSQL 9.2 and 9.3 servers, using the pgespresso extension, allowing users to issue backups from a streaming replicated standby server. Read the full announcement at http://www.pgbarman.org/barman-1-3-1-released/. Many thanks for funding towards the development of this release […]
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 […]
Last week at the CHAR(10) conference we had a workshop on “Cloud Databases”. To put it simply: what to do when the use case requirements exceed the resources available in the database server. This was a main topic of the whole conference, and several solutions have been illustrated during the day. A common theme has […]