2ndQuadrant is proud to announce the release of version 1.2.1 of Barman, Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for bandwidth limitation through the "bandwidth_limit" option. This option allows administrators to set the maximum number of kilobytes per second for backup and recovery operations. Different bandwidth caps can be set for different servers.

More control on bandwidth limitations can be achieved through the "tablespace_bandwidth_limit" option that allows to cap the bandwidth usage for one or more specific PostgreSQL tablespaces.

By default, no bandwidth limitation is enforced, making Barman 1.2.1 fully compatible with configuration files from previous versions. This set of features gives administrators finer control on regular backup activities, reducing the impact of these operations on live systems.

Minor bugs have also been fixed.

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

Links

• Website
• Download
• Documentation
• Support

Release Notes

• Added the "bandwidth_limit" global/server option which allows to limit the I/O bandwidth (in KBPS) for backup and recovery operations
• Added the "tablespace_bandwidth_limit" global/server option which allows to limit the I/O bandwidth (in KBPS) for backup and recovery operations on a per tablespace basis
• Added /etc/barman/barman.conf as default location
• Bug fix: avoid triggering the minimum_redundancy check on FAILED backups (thanks to Jérôme Vanandruel)

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.

Built on top of PostgreSQL's robust and reliable Point-In-Time-Recovery technology, Barman allows database administrators to manage the backup and recovery phases of several PostgreSQL database servers from a centralised location, using an intuitive command interface. Barman is distributed under GNU GPL 3.

2ndQuadrant has launched a ‘carrier-grade’ support service for companies who require absolute mission-critical incident protection.

The company has decided to offer this level of service commitment to support the rapidly growing adoption of PostgreSQL by enterprises requiring the highest level of support services.

This new service, branded Platinum Production Support, provides the additional reassurance of a guaranteed 15-minute (human) response time, 4-hour workaround, and a fix within 24 hours for PostgreSQL production databases. With 24/7 coverage included too.

2ndQuadrant has an excellent track record of recovering databases for companies of all sizes, having provided 24/7 production support for over 8 years. Simon Riggs, CTO of 2ndQuadrant, said, “More of our major clients from financial, telecoms and internet-based sectors are increasingly requiring extraordinary levels of up-time to avoid the potentially significant costs of downtime. With the rise in PostgreSQL databases at the heart of these mission-critical operations, we've launched this new service to ensure that organisations have the best support available, and equally to provide reassurance in their choice of database. The Platinum service complements our popular Gold service, providing clients—where every minute of downtime counts—with the reassurance they need.”

PostgreSQL is becoming a default choice for many leading corporations and public sector organisations, who can see the value in open source products and the benefits of reducing the costs of fee-based database licences. 2ndQuadrant’s launch of this level of support heralds new expectations of PostgreSQL, and helps dismiss the fears amongst the sceptics that an open source database might be a higher-risk choice.

Platinum Production Support is available now from 2ndQuadrant. Find out more at http://2ndQuadrant.com/support/

Universal Database Tools

DtSQL is a FREE universal database query and editor tools for developers and database administrators to Query, Edit, Browse, and Manage Database objects such as tables, views, indexes, procedures, functions, triggers, contraints and sequences. It can access most databases and can be used on all major operating systems.

• Supported databases : Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgreSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE).
• Support Operation Systems : Windows, Linux and Mac OS. Database Browser Tools : browse schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, sequences, and so on.
• Database Tools : create, alter, view and drop database tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on.
• Database Management Tools : edit database table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete database table data. Find and replace database data, preview generated SQL. Redo or undo last table data change before update is commit.
• SQL Tools : tools to edit, format and execute SQL scripts.

  SQL Builder : help tools to build database select, insert, update, delete SQL scripts.

• Import Data : tools to import data from various formats such as CSV files, Excel files, and fixed-width files. Parse import data according to integer, date, time, timestamp, and boolean pattern.
• Export Data : tools to export database data (single table/multiple tables/query result) in various formats such as CSV files, Excel files, XML, HTML, SQL insert statements and fixed width files. Format export data according to applied integer, date, time, timestamp, and boolean pattern. Built in database

FREE to use.

Home: http://www.dtsql.com

Devart Team is proud to introduce the new versions of dbExpress drivers with support for the latest version of Embarcadero’s RAD Studio - RAD Studio XE4. This considerable upgrade gives users an opportunity to develop their applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64 and Mac OS.

Devart dbExpress is a database-independent layer that defines common interface to provide fast access to SQL database servers from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. For each supported server, dbExpress provides a driver as an independent library that implements the common dbExpress interfaces for processing queries and stored procedures. As data-access layer is thin and simple, dbExpress provides high-performance database connectivity and is easy to deploy. Users can use drivers in the same way as the ones supplied by Embarcadero.

The new versions of dbExpress drivers provide the following improvement:

• Support for RAD Studio XE4 is implemented
  

Pricing and Availability

Price of a single license for a dbExpress driver starts at just $99.95.

Users can try out the new versions of the PostgreSQL driver here:

dbExpress driver for PostgreSQL 3.2 [ Download ]

About Devart

Devart is a recognized vendor of database connectivity solutions for Microsoft .NET and Embarcadero Delphi development platforms as well as database management software. Company's solutions support such databases as Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, and SQLite. Along with database oriented software Devart offers productivity tools for Visual Studio developers and security components for Delphi.

For additional information about Devart, visit http://www.devart.com/.

The MicroOLAP team is proud to introduce Database Designer for PostgreSQL v1.9.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 internal and architectural improvements. New compiler used as well as new exception tracer implemented. Download

You're welcome to download the Database Designer for PostgreSQL 1.9.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:

• [!] New compiler used in development
• [!] New exception tracer tool used
• [-] "Designer doesn't restore itself to maximized state after restart" bug fixed
• [-] "Modify Database ignores output script character case option" bug fixed
• [-] "Reverse Engineering warns that diagram is not empty even though it clearly is" bug fixed

DtSQL is a FREE universal database query and editor tools for developers and database administrators to Query, Edit, Browse, and Manage Database objects such as tables, views, indexes, procedures, functions, triggers, contraints and sequences. It can access most databases and can be used on all major operating systems.

1. Supported databases : Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE).
2. Support Operation Systems : Windows, Linux and Mac OS.
3. Database Browser Tools : browse schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, sequences, and so on.
4. Database Tools : create, alter, view and drop database tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on.
5. Database Management Tools : edit database table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete database table data. Find and replace database data, preview generated SQL. Redo or undo last table data change before update is commit.
6. SQL Tools : tools to edit, format and execute SQL scripts.
7. SQL Builder : help tools to build database select, insert, update, delete SQL scripts.
8. Import Data : tools to import data from various formats such as CSV files, Excel files, and fixed-width files. Parse import data according to integer, date, time, timestamp, and boolean pattern.
9. Export Data : tools to export database data (single table/multiple tables/query result) in various formats such as CSV files, Excel files, XML, HTML, SQL insert statements and fixed width files. Format export data according to applied integer, date, time, timestamp, and boolean pattern.

10. Built in database

11. FREE to use.

12. Home: http://www.dtsql.com

This important release introduces support for the RAD Studio XE4 (Delphi and C++ Builder personalities). Download

You're welcome to download the PostgresDAC v2.9.6 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/

The first beta release of PostgreSQL 9.3, the latest version of the world's best open source database, is now available. This beta contains previews of all of the features which will be available in version 9.3, and is ready for testing by the worldwide PostgreSQL community. Please download, test, and report what you find.

Major Features

The major features available for testing in this beta include:

• Writeable Foreign Tables, enabling pushing data to other databases
• pgsql_fdw driver for federation of PostgreSQL databases
• Automatically updatable VIEWs
• MATERIALIZED VIEW declaration
• LATERAL JOINs
• Additional JSON constructor and extractor functions
• Indexed regular expression search
• Disk page checksums to detect filesystem failures

In 9.3, PostgreSQL has greatly reduced its requirement for SysV shared memory, changing to mmap(). This allows easier installation and configuration of PostgreSQL, but means that we need our users to rigorously test and ensure that no memory management issues have been introduced by the change. We also request that users spend extra time testing the improvements to Foreign Key locks.

Additional Features

Additional features included in this release are:

• Fast failover to replicas for high availability
• Streaming-only remastering of replicas
• Performance and locking improvements for Foreign Key locks
• Parallel pg_dump for faster backups
• Directories for configuration files
• pg_isready database connection checker
• COPY FREEZE for reduced IO bulk loading
• User-defined background workers for automating database tasks
• Recursive view declaration
• lock_timeout directive

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

Test 9.3 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.3 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.3 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.

Navicat version 11 is a new major version which supports the latest version of PostgreSQL.

New key features in version 11 of Navicat database management and design tools are:

• Native 64-bit version
• Brand new UI design
• Multi-cell Edit and Box Selection
• Smart Find and Replace
• Enhanced SSH Manager
• Docking system, support Aero Snap
• Enhanced Connection Tree with filter
• Over 100 new features and improvements

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database administration and modeling.

Download a trial version

Database .NET 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.

Supported Features:

• Support for PostgreSQL 8.x/9.x
• Browsing and Search All Objects
• Table, Constraint and Index Editor
• Data, Cell, Form and XML Editor
• SQL Editor (AutoComplete/Syntax Highlighting)
• Generating scripts: DDL, SCRIPT AS, All Objects
• Data Visualization and Database Diagram
• Connection Profile and Manager
• Export to CSV/XML/TXT/XLS/XLSX/SQL/HTM/JSON
• Print SQL statements and query results
• Free, Portable, All-In-One, Easy to Use and Multlanguage.
• ...and more: http://fishcodelib.com/Database.htm

The AXLE Consortium are pleased to announce the start of the AXLE database research project, funded by European Union under FP7 grant. axleproject.eu

The objectives of the AXLE project are to greatly improve the speed and quality of decision making on real-world data sets. AXLE aims to make these improvements generally available through high quality open source implementations via the PostgreSQL database and Orange data visualisation and data mining tools.

AXLE project members are

• Barcelona Supercomputing Centre (BSC)
• Portavita
• University of Manchester
• University of Ljubljana
• Coordinated by 2ndQuadrant

Areas of research will include data analysis algorithms for Big Data, advanced hardware architectures, data visualisation and security. Target environments are real-world data in the 10-100 TB range.

"Real world data needs good security too, so we'll be making sure we have high grade security that works well even with high performance requirements", says Simon Riggs, CTO of 2ndQuadrant and Principal Investigator for the AXLE project. "We're very happy that the European Union has recognised the potential of the PostgreSQL database to provide effective database analytics for a broad range of business, research and public services."

First deliverables from the project will be submitted to PostgreSQL version 9.4, available in 2014 and will continue in later releases.

Project updates will be available regularly here as work continues.

Sprout is a project dedicated to a nested key-value pair programming language native to the Entity Attribute Value database model. Its environment is a Relational Database Management System, specifically Postgres 9. It is implemented with Procedural SQL and employs a key-value translator vernacular to EAV data model. The model provides storage of objects, object metadata definitions and program code. Sprout executes requests via SQL client interface and returns objects of various types. It has characteristics of a column-oriented database.

Check it out!

Paris, April 9th 2013

Dalibo is proud to announce the release of Ora2Pg 11.1. This major release adds support to multiprocessing so that you can now export data in parallel mode. Importing data from an Oracle database is now ten times faster. With this new feature, Ora2Pg performances are closer to the ones you'd get with any ETL.

Since 2001, Ora2Pg is the best solution to migrate data from Oracle to PostgreSQL and is used by thousands of companies around the world to switch from the most expensive proprietary RDBMS to the most advanced Open Source RDBMS!

Ora2pg 11.1 also brings important improvements :

• You can now generate XML transformation files for Kettle (see http://kettle.pentaho.com/).
• Faster scan of Oracle databases containing huge number of objects.
• Faster partition data export with direct import to tables partition.
• Bug fixes on RAW or LONG RAW data export.
• PL/SQL to PL/PGSQL code rewrite.

Gilles Darold, the project leader and main developer of Ora2Pg, explains: "The development of ora2pg is really fast because more and more companies are moving from Oracle to PostgreSQL. This new version brings speed improvements to migrate multi-terabyte databases faster. For most users, lowering the migration time is critical because it means less downtime during the switch from Oracle to PostgreSQL."

These performance enhancements were developed by Dalibo in collaboration with Photobox, Europe's largest online photo processing service and Bouygues Telecom, a major mobile network operator and ISP in France.

Dalibo would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially : Dominique Fourdrinoy, Ludovic Penet, Thomas Ogrisegg, Alex Delianis, Pierre-Marie Petit and mrojasaquino. Ora2Pg is an open project. Any contribution to build a better tool is welcomed. You just have to send your ideas, features requests, or patches using the GitHub tools at https://github.com/darold/ora2pg.

Useful Links:

• Website: http://ora2pg.darold.net/
• Download: http://sourceforge.net/projects/ora2pg/
• Development: https://github.com/darold/ora2pg
• Changelog: https://github.com/darold/ora2pg/blob/master/changelog

About Ora2Pg :

Ora2Pg is an easy and reliable tool to migrate data from Oracle to PostgreSQL. It is developed since 2001 by Gilles Darold, also author of pgBadger, a PostgreSQL performance tool. Ora2Pg can export most of the Oracle objects (table, view, tablespace, sequence, indexes, trigger, grant, function, procedure, package, partition, data, blob and external table).

Ora2Pg works on any platform and is available under the GPL v3 licence.

Docs, Download & Support at http://ora2pg.darold.net/

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.com

The PostgreSQL project has again been selected to take part in Summer of Code for 2013. Google will be funding several students to work with mentors from our project in order to hack PostgreSQL code for the summer.

Applications for students open April 22nd. Our Summer Of Code page has all the information you need about applying this year.

If you are connected with a university, please make sure that students know about this opportunity. If you are a student, please apply!

The PostgreSQL Global Development Group has released a security update to all current versions of the PostgreSQL database system, including versions 9.2.4, 9.1.9, 9.0.13, and 8.4.17. This update fixes a high-exposure security vulnerability in versions 9.0 and later. All users of the affected versions are strongly urged to apply the update immediately.

A major security issue fixed in this release, CVE-2013-1899, makes it possible for a connection request containing a database name that begins with "-" to be crafted that can damage or destroy files within a server's data directory. Anyone with access to the port the PostgreSQL server listens on can initiate this request. This issue was discovered by Mitsumasa Kondo and Kyotaro Horiguchi of NTT Open Source Software Center.

Two lesser security fixes are also included in this release: CVE-2013-1900, wherein random numbers generated by contrib/pgcrypto functions may be easy for another database user to guess, and CVE-2013-1901, which mistakenly allows an unprivileged user to run commands that could interfere with in-progress backups. Finally, this release fixes two security issues with the graphical installers for Linux and Mac OS X: insecure passing of superuser passwords to a script, CVE-2013-1903 and the use of predictable filenames in /tmp CVE-2013-1902. Marko Kreen, Noah Misch and Stefan Kaltenbrunner reported these issues, respectively.

We are grateful for each developer's efforts in making PostgreSQL more secure.

This release also corrects several errors in management of GiST indexes. After installing this update, it is advisable to REINDEX any GiST indexes that meet one or more of the conditions described below.

This update release also contains fixes for many minor issues discovered and patched by the PostgreSQL community in the last two months, including:

• Fix GiST indexes to not use "fuzzy" geometric comparisons for box, polygon, circle, and point columns
• Fix bugs in contrib/btree_gist for GiST indexes on text, bytea, bit, and numeric columns
• Fix bugs in page splitting code for multi-column GiST indexes
• Fix buffer leak in WAL replay causing "incorrect local pin count" errors
• Ensure crash recovery before entering archive recovery during unclean shutdown when recovery.conf is present
• Avoid deleting not-yet-archived WAL files during crash recovery
• Fix race condition in DELETE RETURNING
• Fix possible planner crash after adding columns to a view depending on another view
• Eliminate memory leaks in PL/Perl's spi_prepare() function
• Fix pg_dumpall to handle database names containing "=" correctly
• Avoid crash in pg_dump when an incorrect connection string is given
• Ignore invalid indexes in pg_dump and pg_upgrade
• Include only the current server version's subdirectory when backing up a tablespace with pg_basebackup
• Add a server version check in pg_basebackup and pg_receivexlog
• Fix contrib/dblink to handle inconsistent settings of DateStyle or IntervalStyle safely
• Fix contrib/pg_trgm's similarity() function to return zero for trigram-less strings
• Enable building PostgreSQL with Microsoft Visual Studio 2012
• Update time zone data files for DST law changes in Chile, Haiti, Morocco, Paraguay, and some Russian areas

As always, update releases only require installation of packages and a database system restart. You do not need to dump/restore or use pg_upgrade for this update release. Users who have skipped multiple update releases may need to perform additional, post-update steps; see the Release Notes for details.

Links:

• Download
• Release Notes
• Release FAQ

PGConf.EU 2013 will be held on Oct 29-Nov 1, in at the Conrad Hotel in downtown Dublin, Ireland.

The format will be the same as previous years - one day of training before the main event consisting of three days fully packed with sessions about PostgreSQL.

We are hard at work to get our sponsorship campaign ready and intend to launch it within April. Also we are working on the call for papers and opening the registrations. So, please stay tuned and think about possible talk submissions!

So for now - mark your calendars, and start planning your trip! Follow the RSS feed from the website or our twitter feed for updates as soon as we know more details!

We look forward to seeing you this autumn on the Emerald Isle.

The PostgreSQL Global Development Group will be releasing a security update for all supported versions on Thursday April 4th, 2013. This release will include a fix for a high-exposure security vulnerability. All users are strongly urged to apply the update as soon as it is available.

We are providing this advance notice so that users may schedule an update of their production systems on or shortly after April 4th.

As always, update releases only require installation of packages and a database system restart. You do not need to dump/restore or use pg_upgrade for this update release.

Registration for PGCon 2013 is now open. Have a look at our list of speakers. Please be sure to book your accommodation right away. Some hotels will be sold out within a few weeks. We have an accommodation page which will help you find somewhere to stay.

Database .NET is an innovative, powerful and intuitive multiple database management tool, you can Browse objects, Design tables, Edit rows, Export data and run Queries with a consistent interface.

This is a major version release and contains a lot of new features and improvements:

• Added Script all database objects
• Added Form Editor
• Added Form Viewer
• Added Quick Button
• Added DateTime Picker
• Added New export formats: .json/.xlsx
• Improved Data Editor and Cell Editor
• Improved Table Editor
• Improved Database Diagram
• Improved SQL Profiler
• Improved Code Manager
• Improved AutoComplete and IntelliSense
• … and much more.

Free, Portable, All-In-One, Easy to Use and Multlanguage.

More Info: http://fishcodelib.com/Database.htm

Datanamic has released a new version of Datanamic DataDiff for PostgreSQL. Datanamic DataDiff allows the user to compare the data in two databases, view the differences, automatically generate safe data change scripts or apply the changes to the destination database directly.

Version 4 is almost completely re-designed with a new modern user interface, an improved comparison engine and new comparison options. Three (3) editions support PostgreSQL: the MultiDB edition, the PostgreSQL edition and the CrossDB edition. The CrossDB edition allows you to synchronize data between different database platforms (including PostgreSQL).

More information can be found on the Datanamic DataDiff for PostgreSQL product pages.