Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

PostgreSQL News
Syndicate content
PostgreSQL news
Updated: 1 hour 20 min ago

PostgreSQL updates 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22 released

Thu, 07/24/2014 - 01:00

The PostgreSQL Global Development Group has released an update to all supported version of the database system, including versions 9.3.5, 9.2.9, 9.1.14, 9.0.18, and 8.4.22. This minor release fixes a number of issues discovered and reported by users over the last four months, including some data corruption issues, and is the last update of version 8.4. Users of version 9.3 will want to update at the earliest opportunity; users of version 8.4 will want to schedule an upgrade to a supported PostgreSQL version.

Among the notable issues fixed in this release are:

PostgreSQL 9.3 and pg_upgrade: Users who upgraded to version 9.3 using pg_upgrade may have an issue with transaction information which causes VACUUM to eventually fail. These users should run the script provided in the release notes to determine if their installation is affected, and then take the remedy steps outlined there.

PostgreSQL 9.3 crash recovery: Three issues which could compromise data integrity during crash recovery on master or standby servers in PostgreSQL 9.3 have been fixed.

GIN and GiST indexes: Three issues with GIN and GiST indexes, used for PostGIS and full text indexing, can cause corruption or incorrect query responses. Any indexes on bit or bit varying columns should be rebuilt following the instructions in the release notes.

Security during make check: The insecure socket permissions during "make check", reported in a previous security announcement, have now been fixed.

With this release, version 8.4 is now End-of-Life (EOL), per our Versioning Policy. This means that no additional updates will be released for version 8.4, and users should plan to upgrade to a later version very soon.

In addition the above, this update release includes the following fixes which affect multiple PostgreSQL versions:

  • Fix race condition with concurrent tuple updating
  • Prevent "could not find pathkey item to sort" planner error
  • Properly optimize subqueries with set-returning functions
  • Repair planner regression in optimizing AND/OR NULL
  • Fix planner handling of VARIADIC functions
  • Make json_populate_recordset handle nested JSON properly
  • Prevent corruption of TOAST values when creating complex types
  • Prevent "record type has not been registered" query error
  • Fix a possible crash condition with functions and rewinding cursors
  • Patch three memory leaks
  • Fix row checks for rows deleted by subtransactions
  • Change how pg_stat_activity displays sessions during PREPARE TRANSACTION
  • Prevent multixact ID corruption during VACUUM FULL
  • Fix indentation when displaying complex view definitions
  • Fix client hostname lookup in pg_hba.conf
  • Fix libpython linking on OSX
  • Avoid buffer bloat in libpq
  • Fix an issue with dumping materialized views
  • Fix pg_upgrade's handling of multixact IDs
  • Make sure that pgcrypto clears sensitive information from memory
  • Time zone updates for Crimea, Egypt, and Morocco

Four Windows-specific fixes are included in this release:

  • Prevent tablespace creation recovery errors
  • Fix detection of socket failures
  • Allow users to change parameters after startup
  • Properly quote executable names so they don't fail

A few of the issues above require post-update steps to be carried out by affected users. Please see the release notes for details.

As with other minor releases, users are not required to dump and reload their database or use pg_upgrade in order to apply this update release; you may simply shut down PostgreSQL and update its binaries. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links:

Categories: Database, Open Source

PostgreSQL 9.4 Beta 2 Released

Thu, 07/24/2014 - 01:00

The PostgreSQL Global Development Group has made available the second beta release of PostgreSQL 9.4. This beta contains previews of all of the features which will be available in version 9.4, plus corrections for many of the issues discovered by users who tested 9.4 Beta 1. Please download, test, and report what you find.

Among the changes made since 9.4 Beta 1 are:

  • Fix handling of two-phase commit and prepared statements for logical decoding
  • Multiple fixes for bugs in pg_recvlogical
  • Change slot handling logic for replication slots
  • Add support for BSD and e2fsprogs UUID libraries.
  • Multiple jsonb bug fixes
  • Remove use_json_as_text options from json functions
  • Make json_build_* functions STABLE instead of IMMUTABLE
  • Prevent ALTER SYSTEM from changing the data directory
  • Prevent autovacuum-related crash
  • Many documentation improvements and changes

Beta 2 includes changes to pg_control and to the system catalogs. As such, users who have been testing Beta 1 will need to upgrade in order to test Beta 2. We suggest using pg_upgrade for this upgrade in order to test that as well.

For a full listing of the features in version 9.4 Beta, please see the release notes. Additional descriptions and notes on the new features are available on the 9.4 Features Wiki Page.

We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please download PostgreSQL 9.4 Beta 2 and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. Features and APIs in Beta 2 will not change substantially before final release, so it is now safe to start building applications against the new features. More information on how to test and report issues

Get the PostgreSQL 9.4 Beta 2, including binaries and installers for Windows, Linux and Mac from our download page.

Full documentation of the new version is available online, and also installs with PostgreSQL.

Categories: Database, Open Source

MicroOLAP Database Designer for PostgreSQL v1.10.0 is out

Fri, 07/04/2014 - 01:00

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL v1.10.0, an comprehensive CASE tool with intuitive graphical interface allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from a server,
  • export diagram to common graphic formats or as SQL script,
  • create detailed printings and reports.
This release introduces support for the latest v9.4 SQL grammar as well as improved support for inheritance functionality. Modify Engine allows mark constraints as NOT VALID. Several non critical bugs fixed. Download

You're welcome to download the Database Designer for PostgreSQL 1.10.0 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:
  • [!] SQL Executor and Validator support v9.4 grammar now
  • [!] Support for table inheritance improved dramatically
  • [+] "Always make PK columns first" option introduced in Diagram Options
  • [+] Allow CHECK constraints to be declared NOT VALID in Modify script
  • [+] Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
  • [+] Shortcut for "Save As.." and "Export" menu items added
  • [+] SQL keywords are properly highlighted according to 9.4 version
  • [*] Comments now shown at Preview tab of Table Editor by default
  • [*] Handling of incorrect file paths improved in Generate and Modify Database
  • [*] Merging of reversed user types with existing in model improved during Reverse Engineering
  • [-] "Changing domain schema doesn't affect table representation where domain used" bug fixed
  • [-] "Changing some options in the Model Options doesn't activate OK & Apply buttons" bug fixed
  • [-] "Column default values containing backslashes are corrupted after reloading model" bug fixed
  • [-] "Leak proof option doesn't shown in the Function editor after reopen" bug fixed
  • [-] "LEAKPROOF attribute causes syntax error in the SQL Executor" bug fixed
Categories: Database, Open Source

PGConf.EU 2014 Now Open for Registration

Tue, 07/01/2014 - 01:00

PostgreSQL Conference Europe 2014 in Madrid, Spain, on October 21st - 24th, is now open for registration!

PGConf.EU is the largest PostgreSQL dedicated conference in the world, with three packed days of sessions ranging from beginner level to advanced sessions about database internals, and more than 250 attendees.

The 2014 edition is now open for registration to all attendees. Register before September 15 and receive 20% Early Bird discount! We recommend attendees to register as early as possible, since the conference often sells out!

There will be a full day of training sessions on October 21st, the day before the main conference, held by well known teachers from the PostgreSQL community. These sessions are ordered at registration, and are also available for order now. The training sessions are held in smaller groups, and may sell out quickly, so we suggest that anybody who wish to attend the training register early!

To register, access the registration form on the website.

We'd also like to remind you that our call for papers is still open, where we are looking for even more interesting presentations for the conference. Speakers of the conference receive free attendance, so make sure to submit your ideas!

We look forward to seeing you in Madrid!

Categories: Database, Open Source

PgBackMan 1.0.0 released

Thu, 06/26/2014 - 01:00

Oslo, Norway - June 26,2014

We are proud to announce the first release available to the public of PgBackMan - PostgreSQL backup manager.

About PgBackMan

PgBackMan is a tool for managing PostgreSQL logical backups created with pg_dump and pg_dumpall.

It is designed to manage backups from thousands of databases running in multiple PostgreSQL nodes, and it supports a multiple backup server topology.

The PgBackMan code is distributed under the GNU General Public License 3 and it is written in Python and PL/PgSQL. It has been developed and tested by members of the Database Operations Group at the Center for Information Technology at the University of Oslo.

Main Features
  • Central database with metadata information.
  • PgBackMan shell for interaction with the system.
  • Management of multiple backup servers.
  • Management of multiple PostgreSQL servers.
  • Management of thousands of backups dumps through a catalogue.
  • Manual and scheduled backups.
  • Management of retention policies for backups.
  • Fully detailed backup reports.
  • Multiple predefined database backup types, CLUSTER,FULL,SCHEMA,DATA.
  • Full backup of role information for a database.
  • Full backup of database configuration for a database.
  • Automatic definitions of backups for all databases running in a PgSQL node.
  • Automatic restore procedures.
  • Autonomous pgbackman_dump program that functions even if the central database with metadata information is not available.
  • Handling of error situations.
Categories: Database, Open Source

Bucardo 5 released

Mon, 06/23/2014 - 01:00

Version 5 of Bucardo, a multi-source, multi-target replication system for PostgreSQL has been released. You can find more information about the release here:

http://blog.endpoint.com/2014/06/bucardo-5-multimaster-postgres-released.html

For more information on how to download Bucardo, please visit:

http://bucardo.org/wiki/Bucardo

Checksums for the tarball:

d87d109c1cba300d074603b2dd4d1019302acdfd Bucardo-5.0.0.tar.gz f4e68f473a4669d465d0d8f23910d4b3 Bucardo-5.0.0.tar.gz

Categories: Database, Open Source

Admin4 V2.1.4 featuring PostgreSQL module released

Thu, 06/05/2014 - 01:00

The new Admin4 release is the first to contain a greatly enhanced PostgreSQL module. It includes:

  • Object browser with Favourites
  • Query tool with Snippets, sql text fragments stored for frequent usage
  • Data tool for table data modification, with Presets to remember frequently used data retrieval filters.

Favourites, Snippets and Presets are stored centrally in the database, making them available for roaming usage. Your day-to-day code snippets, standard filters and frequently used objects are right there no matter which workstation you're using to maintain the database.

Download it here from sourceforge, it's free (Apache2 licensed). Contributors/testers for this fresh project are welcome!

Categories: Database, Open Source

Postgres Open 2014 Early Bird Tickets and Tutorials on Sale!

Thu, 06/05/2014 - 01:00

The 2014 Postgres Open Program Committee is pleased to announce the opening of Early Bird Tickets and Tutorial Registration sales.

Early Bird Tickets: Book early through July 6, 2014 to save $200 on your registration! Postgres Open has received such strong support from our community sponsors that we’re retaining our ticket prices from 2013 - no increase this year.

Conference Tutorials: We’ve brought in some new presenters and topics this year for our tutorial sessions held Wednesday, September 17th.

  • Adv. SQL + Functions - Joe Conway, Stephen Frost
  • Intro to PostGIS Core and Popular Add-ons - Regina Obe, Leo Hsu (a 2 part/full day session)
  • Writing and Using Extensions - Dimitri Fontaine

In addition, Heroku is offering a free platform tutorial covering dynos and their environment, buildpacks, deployment, releases, HTTP routing, add-ons, and of course Postgres.

Early Bird Tickets and All Tutorials can be purchased here: https://postgresopen.org/2014/tickets/

The CfP has been extended through Sunday June 8th: We’ve received some impressive submissions thus far, however a few of you have asked for some extra time, as such we’re giving you until this Sunday June 8. https://postgresopen.org/2014/callforpapers/

We look forward updating you in the coming weeks and with more speaker info and the presentations schedule for Postgres Open 2014!

Categories: Database, Open Source

PostgreSQL Maestro 14.5 released

Mon, 05/26/2014 - 01:00

SQL Maestro Group announces the release of PostgreSQL Maestro 14.5, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:
  1. PostgreSQL 9.4 compatibility.
  2. Support for materialized views.
  3. Support for range types.
  4. Enhanced Function Editor.
  5. Updatable views generation.
  6. SQL Editor: support for DML statements with the RETURNING clause.
  7. Data import from several files to a single table.
  8. Advanced Column Builder for text files with fixed column width.
  9. Data export to the JSON format.
  10. Some performance and usability improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Categories: Database, Open Source

DBD::Pg 3.2.1 released

Sun, 05/25/2014 - 01:00

Version 3.2.1 of DBD::Pg, the Perl interface to Postgres, has just been released. For more information and to download please visit:

http://search.cpan.org/dist/DBD-Pg/

Categories: Database, Open Source

PostgreSQL 9.4 beta1 on Debian/Ubuntu

Fri, 05/16/2014 - 01:00

Yesterday saw the first beta release of the new PostgreSQL version 9.4. Along with the sources, we uploaded binary packages to Debian experimental and apt.postgresql.org, so there's now packages ready to be tested on Debian wheezy, squeeze, testing/unstable, and Ubuntu trusty, saucy, precise, and lucid.

If you are using one of the release distributions of Debian or Ubuntu, add this to your /etc/apt/sources.list.d/pgdg.list to have 9.4 available:

deb http://apt.postgresql.org/pub/repos/apt/ codename-pgdg main 9.4

On Debian jessie and sid, install the packages from experimental.

Happy testing!

Categories: Database, Open Source

PostgreSQL 9.4 Beta 1 Released

Thu, 05/15/2014 - 01:00

The PostgreSQL Global Development Group announced that the first beta release of PostgreSQL 9.4, the latest version of the world's leading open source database, is available today. This beta contains previews of all of the features which will be available in version 9.4, and is ready for testing by the worldwide PostgreSQL community. Please download, test, and report what you find.

Major Features

The new major features available for testing in this beta include:

  • JSONB: 9.4 includes the new JSONB "binary JSON" type. This new storage format for document data is higher-performance, and comes with indexing, functions and operators for manipulating JSON data.
  • Replication: The new Data Change Streaming API allows decoding and transformation of the replication stream. This lays the foundation for new replication tools that support high-speed and more flexible replication and scale-out solutions.
  • Materialized Views with "Refresh Concurrently", which permit fast-response background summary reports for complex data.
  • ALTER SYSTEM SET, which enables modifications to postgresql.conf from the SQL command line and from remote clients, easing administration tasks.

These features expand the capabilities of PostgreSQL, and introduce new syntax, APIs, and management interfaces.

Additional Features

There are many other features in the 9.4 beta, all of which need testing by you:

  • Dynamic Background Workers
  • Replication Slots
  • Write Scalability improvements
  • Aggregate performance improvements
  • Reductions in WAL volume
  • GIN indexes up to 50% smaller and faster
  • Updatable security barrier views
  • New array manipulation and table functions
  • Time-delayed standbys
  • MVCC system catalog updates
  • Decrease lock level for some ALTER TABLE commands
  • Backup throttling
  • WITHIN GROUP

There have also been many internal changes in the inner workings of the Write Ahead Log (WAL), GIN indexes, replication, aggregation, and management of the system catalogs. The means we need you to help us find any new bugs that we may have introduced in these areas before the full release of 9.4.

For a full listing of the features in version 9.4 Beta, please see the release notes. Additional descriptions and notes on the new features are available on the 9.4 Features Wiki Page.

Test 9.4 Beta 1 Now

We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please download PostgreSQL 9.4 Beta 1 and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. Features and APIs in Beta 1 will not change substantially before final release, so it is now safe to start building applications against the new features. More information on how to test and report issues

Get the PostgreSQL 9.4 Beta 1, including binaries and installers for Windows, Linux and Mac from our download page.

Full documentation of the new version is available online, and also installs with PostgreSQL.

Categories: Database, Open Source

Postgres-XL Released: Scale-out PostgreSQL Cluster

Wed, 05/14/2014 - 01:00

TransLattice announces the availability of the release candidate for Postgres-XL, an open source, clustered, parallel SQL database designed for both OLTP and Big Data analytics.

The key capabilities of Postgres-XL include OLTP write scalability, massive parallel processing (MPP), cluster-wide ACID (atomicity, consistency, isolation, durability) properties and multi-tenant security.

Open access to Postgres-XL further extends the open source PostgreSQL ecosystem and offers additional choices to the community.

Postgres-XL is based on StormDB, the commercial product acquired by TransLattice in 2013. TransLattice will continue to actively contribute to Postgres-XL.

More information can be found at http://www.postgres-xl.org

The full press release of the announcement can be read here: http://www.translattice.com/pr/TransLattice_Launches_Postgres-XL_an_Open_Source_Database_Designed_for_OLTP_and_Big_Data_Analytics.shtml

Categories: Database, Open Source

pg_catcheck released

Tue, 05/13/2014 - 01:00

EnterpriseDB is pleased to announce the initial release of pg_catcheck, a catalog integrity checker for PostgreSQL and Postgres Plus Advanced Server.

pg_catcheck is a simple tool for diagnosing system catalog corruption, released under the same license as PostgreSQL itself. pg_catcheck reports logical errors in system catalogs, such as a value in pg_catalog.relnamespace that is not present in pg_namespace.oid. It is intended to make it easy to determine the nature and extent of system catalog corruption so that you (or your PostgreSQL support provider) can take whatever recovery actions you might deem appropriate, such as repairing enough of the damage to take a successful pg_dump of the damaged cluster. pg_catcheck has been tested on Linux and Windows and is expected to work on other operating systems, and it supports server versions 8.4 and newer.

For more details, see the source code and README here.

You can join the project mailing list, pg-catcheck@enterprisedb.com, here.

Categories: Database, Open Source

pgBadger 5.1 is out

Tue, 05/06/2014 - 01:00

Paris, France - May 6th, 2014

DALIBO is proud to announce the release of pgBadger 5.1.

pgBadger is a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your Postgres log files.

This new release fixes several issues and adds some new features:

  • Support to named PREPARE and EXECUTE queries. They are replaced by the real prepare statement and reported into top queries.
  • Add new --exclude-line command line option for excluding immediately log entries matching any regex.
  • Included remote and client information into the most frequent events.
  • pgBadger is now able to parse remote logfiles using a password less ssh connection and generate locally the reports.
  • Histogram granularity can be adjusted using the -A command line option.
  • Add new detail information on top queries to show when the query is a bind query.
  • Support to logfile compressed using the xz compression format.
  • Change week/day menu in incremental index, it is now represented as usual with a calendar view per month.
  • Fix various compatibility issue with Windows and Perl 5.8

For the complete list of changes, please checkout the release note on https://github.com/dalibo/pgbadger/blob/master/ChangeLog

Links & Credits

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Herve Werner, Fangr Zhang, Ulf Renman, Thom Brown, Johnny Tan, hkrizek, Magnus Persson, Ronan Dunklau, Adrien Nayrat, William Moran, Orange OLPS department, Josh Kupershmidt, brunomgalmeida, Brian DeRocher, ferfebles and Josh Berkus. With very special thanks to Herve Werner who took time and efforts to heavily test the incremental pgBadger feature.

pgBadger is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools or directly on our mailing list.

Links :

About pgBadger :

pgBagder is a new generation log analyzer for PostgreSQL, created by Gilles Darold (also author of ora2pg, the powerful migration tool). pgBadger is a fast and easy tool to analyze your SQL traffic and create HTML5 reports with dynamics graphs. pgBadger is the perfect tool to understand the behavior of your PostgreSQL servers and identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.io/pgbadger/

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io

Categories: Database, Open Source

TeamPostgreSQL 1.07 - free PostgreSQL web interface

Sun, 05/04/2014 - 01:00

We are pleased to announce the release of TeamPostgreSQL 1.07.

TeamPostgreSQL is a free PostgreSQL web interface, that enables access to PostgreSQL databases through the browser. Ideal for organizations to provide database access via the internet or intranet, or simply as a great database interface on your local machine.

Some feature highlights:

  • Fast and dynamic AJAX web interface
  • Powerful data navigation, using one-click search, relationship navigation, filtering and more
  • Database management, including database objects and tablespace management
  • Import/export of individual database objects or entire databases
  • Tabbed SQL editor with SQL auto-completion
  • Favorites function for easy storing and sharing of SQL snippets and scripts
  • Upload and download files directly to/from binary fields
  • A lot more useful stuff!

.

More info, online demo and download links at the website: http://www.teampostgresql.com

Enjoy!

Categories: Database, Open Source

PostgresDAC 2.12.0 meets RAD Studio XE6!

Thu, 05/01/2014 - 01:00
PostgresDAC v2.12.0 with support for Delphi XE6 and C++ Builder XE6 is available immediately! Full changelog:
  • [!] Support for Delphi XE6 and C++ Builder XE6 introduced
  • [!] Support for PostgreSQL 8.x, 9.x available
  • [!] TPSQLDump allows non-Latin characters in output file names
  • [*] "W1000 Symbol 'DefaultFields' is deprecated'" warning eliminated
  • [*] "W1030 Invalid compiler directive: 'True'" warning eliminated
Download

You're welcome to download the PostgresDAC v2.12.0 right now at: http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Categories: Database, Open Source

Database .NET 11 released!

Mon, 04/14/2014 - 01:00

Database .NET v11 is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface. Free, All-In-One, Portable, Standalone (No Installation) and Multlanguage.

New features from version 10.1 to 11.0:
  • Compatible with the latest versions of PostgreSQL.
  • Updated to Npgsql.dll 2.1.3
  • Added Support for JSON data type of PostgreSQL
  • Added Support for renaming all objects of PostgreSQL
  • Added Executing SQL Statements from a text file
  • Added Displaying Row Count of tables
  • Added Displaying Connection time
  • Added Data Editor for View objects
  • Added Search Table Data
  • Added Empty Table
  • Added New Connection Manager
  • Added New Object Navigator
  • Added Script All Table Data (INSERTs)
  • Added IntelliSense for Cross-schema table access
  • Added Selected Text to Query Builder
  • Added Dynamic Context Menu[?]
The new version is immediately available for download.
Categories: Database, Open Source

Barman 1.3.1 released

Mon, 04/14/2014 - 01:00

14 April 2014: 2ndQuadrant is proud to announce the release of version 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for concurrent backup using physical file based copy through "rsync", in conjunction with pgespresso, a new open source extension available for PostgreSQL 9.2 and 9.3. Concurrent backup allows database administrators that rely on Barman, to finally offload backup operations to a streaming replicated standby server, opening new important scenarios in disaster recovery architectures of PostgreSQL 9.2+ database servers.

The "barman diagnose" command has been implemented to print important information about the system and the configuration of Barman, allowing users to provide detailed diagnostics data in case of support requests.

Version 1.3.1 fixes an important bug on recovery that was affecting only those users having tablespaces created inside the PGDATA directory. This behaviour was introduced in version 1.3.0.

Minor bugs have also been fixed.

Many thanks for funding towards the development of this release go to Adyen (www.adyen.com).

For a complete list of changes, see the "Release Notes" section below.

Links

Release notes

  • Added support for concurrent backup of PostgreSQL 9.2 and 9.3 servers that use the "pgespresso" extension. This feature is controlled by the "backup_options" configuration option (global/server) and activated when set to "concurrent_backup". Concurrent backup allows DBAs to perform full backup operations from a streaming replicated standby.
  • Added the "barman diagnose" command which prints important information about the Barman system (extremely useful for support and problem solving)
  • Improved error messages and exception handling interface
  • Fixed bug in recovery of tablespaces that are created inside the PGDATA directory (bug introduced in version 1.3.0)
  • Fixed minor bug of unhandled -q option, for quiet mode of commands to be used in cron jobs (bug introduced in version 1.3.0)
  • Minor bug fixes and code refactoring

Download

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 backup and recovery, archiving and compression of WAL files and backups. Barman is distributed under GNU GPL 3.

Categories: Database, Open Source

Postgres Open 2014 - Opens the Call for Papers

Thu, 04/10/2014 - 01:00

Postgres Open 2014 will be held in Chicago, IL, at the Hotel Sax, September 17 - 19, 2014. It will feature two full days of multiple parallel tracks of PostgreSQL presentations (September 18 - 19th) from both local and global speakers, covering a wide range of topics. In addition we will also be offering a separate day of tutorials (Wednesday, September 17th). For more information about the conference, please see our website http://postgresopen.org/2014

The Program Committee is currently accepting proposals for presentations at the conference. We are interested in submissions from both seasoned PostgreSQL experts and people new in the community, from both locals and representatives of the global community. In short, from anybody who has an interesting story to tell about PostgreSQL, whether deeply technical or story about a successful (or failed) usage. All presentations are 45 minutes, with time for questions. Talks can be submitted via the website: http://postgresopen.org/2014/callforpapers/

Our early-bird ticket registration will open in May 19, 2014 and are available through June 30, 2014, after which tickets will go up to their regular price.

Finally, we are also looking for sponsors! We several tiers of sponsorship, to make sure there is a choice for everybody. If you are interested, please see the Postgres Open sponsor page http://postgresopen.org/2014/becomesponsor/

We look forward to seeing you in Chicago in September!

Categories: Database, Open Source