News

  Analyzed 5 days ago based on code collected 5 days ago.
 
Posted 7 days ago
On May 22, 2015, the PostgreSQL Global Development Group released an update to all supported versions of PostgreSQL, including versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20. This update has a bug in fsync logic which will cause some users' ... [More] PostgreSQL servers to refuse to restart after a crash, or after a restore from binary backup. Please read our FAQ on this issue before applying the update to your systems.

The PostgreSQL Project regrets the error. Another PostgreSQL update, with this issue corrected, will be released soon. [Less]
Posted 11 days ago
The PostgreSQL Global Development Group has released an update with multiple functionality and security fixes to all supported versions of the PostgreSQL database system, which includes minor versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20. The ... [More] update contains a critical fix for a potential data corruption issue in PostgreSQL 9.3 and 9.4; users of those versions should update their servers at the next possible opportunity.

Data Corruption Fix
For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where the database will fail to protect against "multixact wraparound", resulting in data corruption or loss. Users with a high transaction rate (1 million or more per hour) in a database with many foreign keys are especially vulnerable. We strongly urge all users of 9.4 and 9.3 to update their installations in the next few days.

Users of versions 9.2 and earlier are not affected by this issue.

Security Fixes
This update fixes three security vulnerabilities reported in PostgreSQL over the past few months. Nether of these issues is seen as particularly urgent. However, users should examine them in case their installations are vulnerable:

CVE-2015-3165 Double "free" after authentication timeout.
CVE-2015-3166 Unanticipated errors from the standard library.
CVE-2015-3167 pgcrypto has multiple error messages for decryption with an incorrect key.

Additionally, we are recommending that all users who use Kerberos, GSSAPI, or SSPI authentication set include_realm to 1 in pg_hba.conf, which will become the default in future versions.

More information about these issues, as well as older patched issues, is available on the PostgreSQL Security Page.

Other Fixes and Improvements
A new, non-default version of the citext extension fixes its previously undocumented regexp_matches() functions to align with the ordinary text version of those functions. The fixed version has a different return type than the old version, so users of CIText should test their applications before updating the function by running "ALTER EXTENSION citext UPDATE".

In addition to the above, more than 50 reported issues have been fixed in this cumulative update release. Most of the issues named affect all supported versions. These fixes include:

Render infinite dates and timestamps as infinity when converting to json
Fix json/jsonb's populate_record() and to_record()
Fix incorrect checking of deferred exclusion constraints
Improve planning of star-schema-style queries
Fix three issues with planning joins
Ensure correct locking with security barrier views
Fix deadlock at startup when max_prepared_transactions is too small
Recursively fsync() the data directory after a crash
Fix autovacuum launcher's possible failure to shut down
Cope with unexpected signals in LockBufferForCleanup()
Fix crash when doing COPY IN to a table with check constraints
Avoid waiting for synchronous replication of read-only transactions
Fix two issues with hash indexes
Prevent memory leaks in GIN index vacuum
Fix two issues with background workers
Several fixes to Logical Decoding replication
Fix several minor issues with pg_dump and pg_upgrade

This release includes an update to tzdata release 2015d, with updates to Egypt, Mongolia, and Palestine, plus historical changes in Canada and Chile.

9.0 EOL Soon
Version 9.0 will become End-Of-Life in September 2015. This means that this update is likely to be the next-to-last update for that version. Users of PostgreSQL 9.0 should start planning to upgrade to a more current version before then. See our versioning policy for more information about EOL dates.

Updating
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:

Download
Release Notes
Security Page [Less]
Posted 21 days ago
Paris, France - Mai 11th, 2014

DALIBO is proud to announce the release of pgBadger 7.0.

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

New ... [More] reports and support for explain.depesz.com
This major release adds more useful reports and features. One of the longest
feature request have been also implemented, support to auto_explain
extension.
EXPLAIN plan will be added together with top slowest queries when
available in
log files. Thanks to the kind authorization of depesz, a link to
automatically
open directly the explain plan on http://explain.depesz.com/ is also
available.

List of other new reports in this release:

Events (panic, fatal, error and warning) distribution per 5 minutes.
Per application details (total duration and times executed) for each
query reported in Top Queries. The details are visible from a button
called "App(s) involved".
Cumulated queries durations per user.

Three new reports to help identifying queries cancelled on secondaries
clusters:

Number of cancelled queries (graph)
Queries generating the most cancellation (N)
Queries most cancelled.

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 Mael Rimbault,
Thomas Reiss, Korriliam, rlowe and Antti Koivisto.

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://groups.google.com/forum/?hl=fr#!forum/pgbadger

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 [Less]
Posted 21 days ago
PostgreSQL Conference Europe 2015 will be held on October 27-30 in the Vienna Marriott Hotel, in Vienna, Austria. It will cover topics for PostgreSQL users, developers and contributors, as well as decision and policy makers. For more information ... [More] about the conference, please see the website.

We are now accepting proposals for talks in English or German. If you are submitting a talk in German, please write a short summary of the abstract in English in the "submission notes" field.

Each session will last 45 minutes, and may be on any topic related to PostgreSQL. Suggested topic areas include:

Developing applications for PostgreSQL
Administering large scale PostgreSQL installations
Case studies and/or success stories of PostgreSQL deployments
PostgreSQL tools and utilities
PostgreSQL hacking
Community & user groups
Tuning the server
Migrating from other systems
Scaling/replication
Benchmarking & hardware
PostgreSQL related products

Of course, we're happy to receive proposals for talks on other PostgreSQL related topics as well.

We may also have a limited number of longer, 90-minute, slots available. Please indicate clearly in your submission if you wish to make a 90-minute talk.

Finally, there will be a session of five minute lightning talks. A separate call for proposals will be made for them further on.

The submission deadline is August 7th. Selected speakers will be notified before August 24th, 2015.

Please submit your proposals by going to http://2015.pgconf.eu/callforpapers/ and following the instructions there.

The proposals will be considered by committee who will produce a schedule to be published nearer the conference date.

All selected speakers will get free entry to the conference (excluding training sessions). We do not in general cover travel and accommodations for speakers, but may be able to do that in limited cases. If you require assistance with funding to be able to attend, please make a note of this in the submission notes field.

We look forward to hearing from you, and seeing you in Vienna in October! [Less]
Posted 28 days ago
05 May 2015: 2ndQuadrant is proud to announce the release of version
1.4.1 of Barman, Backup and Recovery Manager for PostgreSQL.

This minor release fixes a few outstanding bugs and does not introduce
any new features.

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

Links

Website
Download
Documentation
Man page, section 1
Man page, section 5
Support
pgespresso extension

Release notes

Fix for WAL archival stop working if first backup is EMPTY (Closes:
#64)
Fix exception during error handling in Barman recovery (Closes:
#65)
After a backup, limit cron activity to WAL archiving only (Closes:
#62)
Improved robustness and error reporting of the "backup delete"
command (Closes: #63)
Fix computation of WAL production ratio as reported in the
"show-backup" command
Improved management of xlogb file, which is now correctly fsynced
when updated. Also, the "rebuild-xlogdb" command now operates on a
temporary new file, which overwrites the main one when finished.
Add unit tests for dateutil module compatibility
Modified Barman version following PEP 440 rules and added support of
tests in Python 3.4

Download

Release
Notes
Sources
RPMs for RHEL/CentOS
5
(dependencies)
RPMs for RHEL/CentOS
6
(dependencies)
PyPI
pgespresso on PostgreSQL Extension framework
(PGXN)
pgespresso RPM/Debian
packages
Online documentation
PDF
documentation

About

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,
incremental backup, retention policies, remote backup and recovery,
archiving and compression of WAL files and backups. Barman is
distributed under GNU GPL 3. [Less]
Posted about 1 month ago
After six successful sessions dedicated to the new features of PostgreSQL 9.0 (February 2011), to PostGIS (June 2011 & September 2014), to replication systems (February 2012), to migration from Oracle to PostgreSQL (October 2012), and to ... [More] PostgreSQL performance (March 2013), we'd like to announce that the 7th PostgreSQL Session will be held on September 24th, 2015, in Paris, France.

This year, another place, but always the same format! This day of lectures will be dedicated especially to the next version of PostgreSQL, but not exclusively!

For more information, see http://www.postgresql-sessions.org/7/about

We're launching a call for papers for this event. You may now submit your talks, in English or in French. Each talk should last 30 minutes (questions included). We are interested in any talks on the following subjects:

What's New in PostgreSQL
Use cases
Migration to PostgreSQL
Performance Tuning
Backup and Restore
High-Availibity
Data Warehouse / Big Data
PostGIS

Talks can be either: a case study, a Proof of Concept, a tutorial, a benchmark, a presentation of a new feature, etc. Of course, we're open to propositions on any other migration related topics (monitoring, hardware, replication, etc.) !

The submission deadline is June 15, 2015.

You can now send your proposals to call-for-paper@postgresql-sessions.org

Please give us a little information about yourself and your talk, such as:

First Name and Last Name
Twitter Account (if any)
Company
Short Biography (contributions to the PostgreSQL community)
Talk title
Talk abstract
Any specific needs

Slides should have a free licence (Creative Commons BY-ND 3.0 or compatible), and sent to Dalibo.

This day will be filmed, and all the lectures will be recorded and published after the Session. By sending a proposal, you agree to be recorded and waive any compensation for it.

The selected speakers not living in France will be reimbursed for travel and one night accomodation.

See you in Paris in September!

About the PostgreSQL Sessions:

The PostgreSQL sessions are designed to be a time to discover and meet the PostgreSQL community. Each session is a single day consisting of lectures, organized around a specific theme and a guest. The proposed talks aimed at all levels and all profiles: Developer, Administrator, Project Managers, IT Managers, ...

Entry is free and open to all, within the limits of available seats.

About Dalibo:

Since 2005, Dalibo is the leading French PostgreSQL company and provides its experience and expertise to its clients in Europe. The company
delivers a full range of PostgreSQL services: Training, Development, Performance Tuning, High Availibilty setup, Oracle to
PostgreSQL migration, Troubleshooting, and PostgreSQL support. [Less]
Posted about 1 month ago
SQL Maestro Group announces the release of PostgreSQL Maestro 15.4, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top ... [More] 10 new features:

Tablespace Editor now displays objects belonging to the tablespace.
SQL Formatter now supports WITH queries, queries with the RETURNING clause and LATERAL JOINs.
Adding new values to existing ENUM types.
ALTER SYSTEM statement on changing the value of a server variable.
Executing custom SQL scripts in all database connections established by the software.
Support for a number of new encryption algorithms in data grids.
Colored tabs and more informative tab hints.
Updated Data Export and Data Import tools.
Improved Data Input Form.
Some performance and usability improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website. [Less]
Posted 2 months ago
SQL Maestro Group announces the release of PostgreSQL Data Sync 15.3, a powerful and easy-to-use tool for PostgreSQL database contents comparison and synchronization.

The new version is immediately available ... [More] at
http://www.sqlmaestro.com/products/postgresql/datasync/.

Top 5 new features:

An ability to select or disable certain synchronization operations (Insert, Update, and Delete) has been implemented. The corresponding command line switches have been added as well.
Now it is possible to specify SQL scripts to be executed before and/or after synchronizing data of each table.
Synchronization script file name and log file name are now stored in the project file. These settings can be overwritten with the appropriate command line options.
The first page of the wizard has been redesigned in order to provide more comfortable access to recently opened projects and display the latest company news.
The progress windows are redesigned in the modern style and become more informative.

There are also some other useful things. Full press release is available at the SQL Maestro Group website. [Less]
Posted 3 months ago
The Call For Papers for PostgresOpen 2015, being held in Dallas, Texas from September 16th to 18th, is now open!

If you are working with PostgreSQL, please visit and submit a talk!

We're looking for presentations on any topic ... [More] related to PostgreSQL including, but not limited to, case studies, experiences, tools and utilities, migration stories, existing features, new feature development, benchmarks, performance tuning, and more!

We look forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to the first multi-day PostgreSQL conference in Texas!

Anyone and everyone in the PostgreSQL community is encouraged to submit a talk. Talks will be accepted up until May 17th, Anywhere on Earth (AoE), also known as: 2015-05-17 23:59:59-12:00.

Speakers will be notified by June 1, 2015 AoE, with the schedule to be published once selected speakers have confirmed.

Early Bird registration for PostgresOpen 2015 will start on May 4th.

We look forward to seeing everyone in Dallas!

Any questions? Please contact: program2015@postgresopen.org. [Less]
Posted 3 months ago
If you've waited until the last minute to come to PGConf US 2015, that minute has arrived.

In only a week, registration will be closed for PGConf US 2015. PGConf US 2015 is taking place from March 25 - 27 and the New York Marriott Downtown ... [More] in New York City, and is hosted by the United States PostgreSQL Association.

If you have not already, we invite you to review our schedule at http://www.pgconf.us/2015/schedule/. This year we have 4 tracks of talks, including a track focusing just on PostGIS and its applications.

We could not produce PGConf US 2015 without the generous support of our sponsors, including our platinum sponsors EnterpriseDB, 2ndQuadrant, and Citus Data, and our gold sponsors Amazon Web Services and Airfacts.

We hope to see you in a week! [Less]