The PostgreSQL Project has recently discovered an issue which can cause minor data loss for some users of streaming replication on very recent releases. Details on this issue are explained on the November 2013 Replication Data Loss Issue page, as well as steps to protect yourself until the next update release is available.
We apologize for any disruption caused by this issue. We expect to have an update available which fixes this issue in less than 2 weeks.
Intelligent Converters has extended their product line with new tools to migrate between Microsoft SQL and SQL Azure databases and PostgreSQL.
For more information, please visit the product pages list below:
Paris, France - October 31th, 2013
DALIBO is proud to announce the release of pgBadger 4, a PostgreSQL performance analyzer, built for speed with fully detailed reports based on your Postgres log files.
This major version comes with a bunch of new features including a complete overhaul for the HTML reports, some new statistics, compatiblity with PostgreSQL 9.3 and Time Period Exclusion...Better Reports / Improved user experience
With a full rewrite of its graphic design, pgBadger has now turned the HTML reports into a more intuitive user experience and professional look.
Every statistic report now include a key value section that shows you immediately some of the relevant informations. Pie charts have also been separated from their data tables using two tabs, one for the chart and the other one for the data.
Tables reporting hourly statistic have been moved to a multiple tabs report following the data. This is used with General (queries, connections, sessions), Checkpoints (buffer, files, warnings), Temporary file and Vacuums activities.PostgreSQL 9.3 compatibility and new stats
Recent PostgreSQL versions add additional information about checkpoint, the number of synced files, the longest sync and the average of sync time per file. pgBadger collects and shows these informations in the Checkpoint Activity report.
There's also some new reports:
- Prepared queries ratio (execute vs prepare)
- Prepared over normal queries
- Queries (select, insert, update, delete) per user/host/application
- Pie charts for tables with the more tuples and pages removed during vacuum. The vacuum report will now highlight the costly table during a vacuum or analyze of a database.
The errors are now highlighted by a different color following the level. A LOG level will be green, HINT will be yellow, WARNING orange, ERROR red and FATAL dark red.
Some changes in the binary format are not backward compatible and option --client have been remove as it was replaced by --dbclient for a long time now.Time Period Exclusion
If you are running a pg_dump or some batch process with very slow queries your report analyze will be annoyed by those queries taking too much place in the report. Before that release it was a pain to exclude those queries from the report. Now you can use the --exclude-time command line option to exclude all traces matching the given time regexp from the report. For example, let's say you have a pg_dump at 13:00 each day during half an hour, you can use pgbadger as follow:
pgbadger --exclude-time "2013-09-.* 13:.*" postgresql.log
If your are also running a pg_dump at night, let's say 22:00, you can write it as follow:
pgbadger --exclude-time '2013-09-\d+ 13:[0-3]' --exclude-time '2013-09-\d+ 22:[0-3]' postgresql.log
or more shortly:
pgbadger --exclude-time '2013-09-\d+ (13|22):[0-3]' postgresql.log
Exclude time always require the iso notation yyyy-mm-dd hh:mm:ss, even if log format is syslog. This is the same for all time related options. Take care that this option has a high cost on the parser performances.Links & Credits
DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Keith Fiske, Marco Baringe, Herve Werner, Den Untevskiy and Mael Rimbault. The new HTML report was designed by Art Is Code.
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.
- Download : http://dalibo.github.io/pgbadger/
- Mailing List : https://listes.dalibo.com/cgi-bin/mailman/listinfo/pgbagder
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/
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
Version 3.0.1 is a major milestone in DbWrench development and the first release of version 3.
This release focused on significant enhancements to the diagram editor. These enhancements include:
- Diagram lines are now movable. - A new right angle linking algorithm to reduce line collisions and overlap with glyphs. - A new diagram glyph color fill algorithm to make diagram glyphs more readable. - Improved memory management to further improve performance.
A free trial download of this latest version is available at www.dbwrench.com.
Screen shots can be viewed here.More About DbWrench
DbWrench is designed to increase the productivity of database developers by making creating and modifying databases much easier.
It's features include:
- Graphic entity relation diagram (ERD) designer - Forward engineer database designs with automatic SQL DDL script generation - Reverse engineer and visualize existing databases - A built in syntax highlighting SQL query editor - Runs on Windows, Mac OSX and Linux all in a single license
E-Maj is an Open Source extension for PostgreSQL. It contains functions to log updates performed on one or several sets of tables, and cancel ("rollback") these updates if needed, resetting a tables set to a predefined stable state. A dedicated plugin for phpPgAdmin also brings a nice GUI to these features.
The main improvement of this 1.1.0 version resides in the E-Maj rollback mechanism. It has been largely improved in order to get better performance and to allow administrator to monitor in progress operations. Functions that generate sql scripts from logged updates have been also enhanced.
The documentation and the CHANGES file supplied with the extension give all the details about the E-Maj features and usage and the latest improvements.
E-Maj 1.1.0 supports postgres version 8.3 to 9.3.
All E-Maj users working with previous versions are invited to upgrade (supplied migration scripts may help in performing this operation).
Have fun with E-Maj !
The PostgreSQL Global Development Group has released a bug-fix update to all current versions of the PostgreSQL database system, including versions 9.3.1, 9.2.5, 9.1.10, 9.0.14, and 8.4.18. This release fixes many minor issues reported by our community over the last six months. All users should update their PostgreSQL installations at the next regular maintenance window.
In this release are fixes for the recently-released version 9.3, including:
- Update hstore extension with JSON functionality
- Prevent memory leak when creating range indexes
- Fix libpq SSL deadlock bug
In addition to the above, there are a few dozen minor bug fixes for older versions. These patches were already included in 9.3.0 when released. Among them are:
- Guarantee transmission of all WAL files before replica failover
- Prevent downcasing of non-ASCII identifiers
- Fix several minor memory leaks
- Correct overcommit behavior when using more than 24GB of work memory
- Improve planner cost estimates for choosing generic plans
- Fix estimates of NULL rows in boolean columns
- Make UNION ALL and inheritance query plans recheck parameterized paths
- Correct pg_dump bugs for foreign tables, views, and extensions
- Prevent a parallel pg_restore failure on certain indexes
- Make REINDEX revalidate constraints
- Prevent two deadlock issues in SP-GIST and REINDEX CONCURRENTLY
- Prevent GiST index lookup crash
- Fix several regular expression failures
- Allow ALTER DEFAULT PRIVILEGES to work on all schemas
- Loosen restrictions on keywords
- Allow various spellings of infinity
- Expand ability to compare rows to records and arrays
- Prevent psql client crash on bad PSQLRC file
- Add spinlock support for ARM64
Note that users of the hstore extension on version 9.3 must take an additional, post upgrade step of running "ALTER EXTENSION hstore UPDATE" in each database after update.
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.
OpenSCG is pleased to announce the release of PostgreSQL Studio 1.0. PostgreSQL Studio is an open-source, web-based GUI for PostgreSQL. It allows users to manage and query their database from a browser.
Version 1.0 of PostgreSQL Studio is distributed under the PostgreSQL License. Some of its key features include:
- Easy to use AJAX web interface
- Secure access over HTTPS
- Robust object wizards
- Query editor with syntax highlighting
- Cross platform and easy to install
You can find more information about PostgreSQL Studio at www.postgresqlstudio.org
- [!] PostgreSQL 9.3 support added
- [!] Delphi XE5 and C++ Builder XE5 support introduced
- [!] OpenSSL 1.0.1e libraries added
- [+] EPSQLDatabaseError.ErrorSchemaName property added
- [+] EPSQLDatabaseError.ErrorTableName property added
- [+] EPSQLDatabaseError.ErrorColumnName property added
- [+] EPSQLDatabaseError.ErrorDatatypeName property added
- [+] EPSQLDatabaseError.ErroConstraintName property added
- [-] “Filtering DateTime field not working in early versions Delphi” bug fixed
You're welcome to download the PostgresDAC v2.10.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/
SQL Maestro Group announces the release of PostgreSQL Code Factory 13.9, a premier GUI tool for querying PostgreSQL database and managing the data.
The new version is immediately available for download.Top 10 new features:
- Improved SQL Editor.
- Updated SQL Dump wizard.
- Keyboard-interactive SSH authentication.
- New Start Page with quick access to recently connected databases.
- Data import from several files to a single table.
- Data export to the JSON format.
- Enhanced data grids.
- The Script Runner tool.
- Colored profiles in Database Explorer.
- New modern progress windows.
Full press release is available at the SQL Maestro Group website. There are also versions for MySQL, MS SQL Server, Oracle, SQLite, Firebird, DB2, SQL Anywhere and MaxDB.
The PostgreSQL Global Development Group announces the release of PostgreSQL 9.3, the latest version of the world's leading open source relational database system. This release expands PostgreSQL's reliability, availability, and ability to integrate with other databases. Users are already finding that they can build applications using version 9.3 which would not have been possible before.
"PostgreSQL 9.3 provides features that as an app developer I can use immediately: better JSON functionality, regular expression indexing, and easily federating databases with the Postgres foreign data wrapper. I have no idea how I completed projects without 9.3," said Jonathan S. Katz, CTO of VenueBook.Writable External Data
Version 9.3 makes PostgreSQL's Foreign Data Wrappers writable, enabling two-way data interchange between systems. Today's complex IT environments involve multiple databases and semi-structured data sources, and PostgreSQL helps you integrate them into a coherent stack. The project has also released postgres_fdw, a higher-performance, read/write PostgreSQL-to-PostgreSQL federation driver.
"Writable foreign data wrappers enable us to plug in and seamlessly test various backend alternatives, allowing us to address different needs quickly and prototype intelligently," explained Lee Holloway, Co-founder and Lead Engineer at CloudFlare. "It is exciting to conceive and toss up new data stores (including our in-house experimental ones written in Go) and then watch them read, write, and even transact each other."Enhanced Reliability and Availability
"Postgres has been my favorite choice for its well known stability, robustness, strong coherency, safety, ACID, and SQL conformance," said Pascal Bouchareine, director of research and development at Gandi.net. "I'm especially excited to hear more about the fast failover coming in 9.3."
This new release includes features to further improve and extend PostgreSQL's well-known reliability and availability:
- Data Page Checksums: help administrators quickly detect failing disks and bad hardware that corrupts data
- Fast Failover: enables sub-second switchoffs from master to replica, supporting "carrier-grade" availability
- Streaming-Only Remastering: easier, faster reconfiguration of cascading replicas after failover
As with every annual release, PostgreSQL 9.3 includes many features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects. These features include:
- Additional JSON constructor and extractor methods
- Automatically updatable VIEWs
- Parallel pg_dump to speed backups of large databases
- LATERAL JOINs
Further, PostgreSQL 9.3's User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator. One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.Links
2ndQuadrant is proud to announce the release of version 1.2.3 of Barman, Backup and Recovery Manager for PostgreSQL.
This minor release adds compatibility with PostgreSQL 9.3.
It also introduces support for the "--target-name" recovery option, which allows to restore to a named point previously specified with pg_create_restore_point (only for PostgreSQL 9.1 and above users).
Experimental compatibility with Python 3 has also been added. We encourage Python 3 users to test this version of Barman and report any feedback to our development team.
Minor bugs have also been fixed.
For a complete list of changes, see the "Release Notes" section below.Links
- Added support for PostgreSQL 9.3
- Added support for the "--target-name" recovery option, which allows to restore to a named point previously specified with pg_create_restore_point (only for PostgreSQL 9.1 and above users)
- Fixed bug #27 about flock() usage with barman.lockfile - many thanks to Damon Snyder (damonsnyder at users.sf.net)
- Introduced Python 3 compatibility
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.
Yohz Software announces the release of SQL Select 184.108.40.206 on August 29, 2013, and is available for immediate download. SQL Select supports PostgreSQL 7.1 to 9.2, without the need for any additional database drivers.Changes in this release:
- Improved display of binary/blob fields in result grid. SQL Select now identifies the data type where possible, and display the type and data size accordingly.
- Fixed bug with exporting multiple result sets to text files.
- Fixed bug with not saving Excel header options correctly.
- Fixed bug with running queries against ODBC connections.
For more details about SQL Select, visit the product page here.
Release Candidate 1 of the next version of PostgreSQL is now available. All of the features of version 9.3 should be available and stable in the this release. We need your assistance to verify that all of these features are bug free.
Information on these features can be found at:
Please download 9.3rc1 as soon as possible and report any bugs, deficiencies, missing documentation, or regressions you find. We're hoping to have a trouble-free 9.3.0 release in just a few weeks, but that depends on your testing. Report any issues you find to email@example.com, or using our bug reporting form.
Source code and binary installers for most platforms are available from our downloads page.