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.

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/

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!

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.

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

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.

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 :

• Download : http://dalibo.github.io/pgbadger/
• Mailing List : https://listes.dalibo.com/cgi-bin/mailman/listinfo/pgbagder

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

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!

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/

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.

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

• Website: http://www.pgbarman.org/
• Download: http://sourceforge.net/projects/pgbarman/files/
• Documentation: http://www.pgbarman.org/documentation/
• Support: http://www.pgbarman.org/support/
• pgespresso extension: https://github.com/2ndquadrant-it/pgespresso

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

• Release Notes: https://sourceforge.net/projects/pgbarman/files/1.3.1/
• Sources: http://sourceforge.net/projects/pgbarman/files/1.3.1/barman-1.3.1.tar.gz/download
• RPMs for RHEL/CentOS 5: http://sourceforge.net/projects/pgbarman/files/1.3.1/barman-1.3.1-1.rhel5.noarch.rpm/download (dependencies: https://sourceforge.net/projects/pgbarman/files/rhel5-deps/)
• RPMs for RHEL/CentOS 6: http://sourceforge.net/projects/pgbarman/files/1.3.1/barman-1.3.1-1.rhel6.noarch.rpm/download (dependencies: https://sourceforge.net/projects/pgbarman/files/rhel6-deps/)
• PyPI: http://pypi.python.org/pypi/barman/1.3.1
• pgespresso on PostgreSQL Extension framework (PGXN): http://pgxn.org/dist/pgespresso/
• pgespresso RPM/Debian packages: https://sourceforge.net/projects/pgbarman/files/pgespresso/
• Online documentation: http://www.pgbarman.org/documentation
• PDF documentation: http://sourceforge.net/projects/pgbarman/files/1.3.1/barman-tutorial.en.pdf/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.

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!