Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
     
  Server Applications Technical Updates [Page: 1 of 101] @ TACKtech Corp.  

06.24.2015 - Introducing HypoPG, hypothetical indexes for PostgreSQL



View PostgreSQL-Press related news.

Introducing HypoPG

Paris, June 24 2015

DALIBO is proud to present the first release of HypoPG, an extension that adds hypothetical indexes in PostgreSQL.

An hypothetical index is an index which doesn't exists on disk. It's thefore almost instant to create and doesn't add any IO cost, wether at creation time or at maintenance time. The goal is obviously to check if an index is useful before spending many time, I/O and disk space to create it.

With this extension, you can create hypothetical indexes, and then with EXPLAIN check if PostgreSQL would use them or not.

" What if I had an Index on this ? "

Did you ever wonder how an index would increase the performances of your server, but you couldn't afford the time to create it on disk just for the sake of trying ?

Here's how HypoPG can help:

First let's create a simple use case:

# CREATE TABLE testable AS SELECT id, 'line ' || id val FROM generate_series(1,1000000) id;
# ANALYZE testable ;

Now let's install HypoPG and create an hypothetical index on this new table

# CREATE EXTENSION hypopg;
# SELECT hypopg_create_index('CREATE INDEX ON testable (id)');

You can now use EXPLAIN (without ANALYZE) to check if PostgreSQL would use that index !

# EXPLAIN SELECT * FROM testable WHERE id = 1000 ;
                                          QUERY PLAN
-----------------------------------------------------------------------------------------------
 Index Scan using 41079_btree_testable_id on testable  (cost=0.05..8.07 rows=1 width=15)
   Index Cond: (id = 1000)
(2 rows)

Yay ! If there were an index on the 'id' column, PostgreSQL would take advantage of it !

Links

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.

http://www.dalibo.com

Full View / NID: 54793 / Submitted by: The Zilla of Zuron

06.12.2015 - PostgreSQL 9.4.4, 9.3.9, 9.2.13, 9.1.18 & 9.0.22 Released!



View PostgreSQL-Press related news.

2015-06-12 Update Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.4.4, 9.3.9, 9.2.13, 9.1.18 and 9.0.22. This release primarily fixes issues not successfully fixed in prior releases. It should be applied as soon as possible all users of major versions 9.3 and 9.4. Other users should apply at the next available downtime.

Crash Recovery Fixes

Earlier update releases attempted to fix an issue in PostgreSQL 9.3 and 9.4 with "multixact wraparound", but failed to account for issues doing multixact cleanup during crash recovery. This could cause servers to be unable to restart after a crash. As such, all users of 9.3 and 9.4 should apply this update as soon as possible.

Servers previously upgraded to PostgreSQL 9.3 using pg_upgrade, even those servers now running PostgreSQL 9.4 due to another upgrade, may experience an immediate autovacuum of all tables after applying this update. For large databases, consider a controlled manual VACUUM, before updating, to better regulate the performance consequences of this critical maintenance. Please see the release notes for details.

Other Fixes and Improvements

In addition to the above, a few other minor issues were patched in this release. These fixes include:

  • Prevent failure to invalidate relation cache init file
  • Avoid deadlock between new sessions and CREATE/DROP DATABASE
  • Improve query planning for semi-joins and anti-joins

Cumulative Releases

All PostgreSQL update releases are cumulative. As this update release fixes a number of problems inadvertently introduced by fixes in earlier update releases, we strongly urge users to apply this update, rather than installing less recent updates that have known issues. As this update release closes multiple known bugs with multixact handling, the PostgreSQL Project does not anticipate additional update releases soon.

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. See also the above note for users who used pg_upgrade with PostgreSQL version 9.3.

Links:

Full View / NID: 54615 / Submitted by: The Zilla of Zuron

06.11.2015 - PHP 5.5.26 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.26. Several bugs have been fixed as well as several security issues into some bundled libraries (CVE-2015-3414, CVE-2015-3415, CVE-2015-3416, CVE-2015-2325 and CVE-2015-2326). All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.26 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 54601 / Submitted by: The Zilla of Zuron

06.11.2015 - PHP 5.6.10 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.10. Several bugs have been fixed as well as several security issues into some bundled libraries (CVE-2015-3414, CVE-2015-3415, CVE-2015-3416, CVE-2015-2325 and CVE-2015-2326). All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.10 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 54600 / Submitted by: The Zilla of Zuron

06.11.2015 - PHP 5.4.42 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.42. Six security-related issues in PHP were fixed in this release, as well as several security issues in bundled sqlite library (CVE-2015-3414, CVE-2015-3415, CVE-2015-3416). All PHP 5.4 users are encouraged to upgrade to this version. For source downloads of PHP 5.4.42 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 54599 / Submitted by: The Zilla of Zuron

06.04.2015 - CfP for PGConf Silicon Valley Closes June 15th



View PostgreSQL-Press related news.

Submit your talk on the PGConf Silicon Valley website now. 50 minute breakout and 3 hour tutorial sessions available. November 17-18, 2015 at the South San Francisco Convention Center.

Full View / NID: 54478 / Submitted by: The Zilla of Zuron

06.04.2015 - PostgreSQL 9.4.3, 9.3.8, 9.2.12, 9.1.17 & 9.0.21 Released!



View PostgreSQL-Press related news.

2015-06-04 Update Release

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.4.3, 9.3.8, 9.2.12, 9.1.17 and 9.0.21. This release primarily fixes a startup failure problem created by the prior update release, and should be installed by all users who applied that release.

File Permissions Fix

The 2015-05-22 update release added an anti-corruption step which will fsync all files in the data directory on restart after a crash. This caused PostgreSQL to fail to start if it encountered any file permissions issues. The problem is now fixed. Find out more on the PostgreSQL wiki.

Other Fixes and Improvements

In addition to the above, a few other minor issues were patched in this release. These fixes include:

  • Have pg_get_functiondef() show the LEAKPROOF property
  • Make pushJsonbValue() function push jbvBinary type
  • Allow building with threaded Python on OpenBSD

Update Release Schedule

The PostgreSQL developers are currently working hard to fix a few known issues discovered in the past couple of weeks. As such, we expect to release another update once a solution for those issues is complete and tested. The PostgreSQL project apologizes for any inconvenience from the frequent releases. We are prioritizing getting important fixes to our users as soon as possible.

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:

Full View / NID: 54477 / Submitted by: The Zilla of Zuron

06.03.2015 - Bi-Direction Replication, version 0.9.1 released



View PostgreSQL-Press related news.

June 01 2015

2ndQuadrant is pleased to announce the release of Bi-Direction Replication, version 0.9.1

This new version (0.9.1) is a maintenance release focused on stability and performance.

For a complete list of changes, see the "Release Notes" in "More information" below.

Featured release notes

  • Rename 'bdr' reserved db to 'bdr_supervisordb', prevent users from connecting, and protect against drop

  • Bug fixes in bdr_init_copy handling of connection strings

  • Fixes for UNLOGGED tables in the command filter

  • Permit fast shutdown when replication is paused

  • Remove slots when parting a node

  • bdr.table_set_replication_sets no longer requires permit_unsafe_ddl_commands

More information

Bi-Directional Replication (BDR) is an asynchronous multi-master replication system for PostgreSQL, specifically designed to allow geographically distributed clusters. Supporting up to 48 nodes (and possibly more in future releases) BDR is a low overhead, low maintenance technology for distributed databases. For more information visit http://2ndquadrant.com/bdr

Full View / NID: 54451 / Submitted by: The Zilla of Zuron

05.26.2015 - Advisory on May 22 Update Release



View PostgreSQL-Press related news.

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

Full View / NID: 54308 / Submitted by: The Zilla of Zuron

05.22.2015 - PostgreSQL 9.4.2, 9.3.7, 9.2.11, 9.1.16, and 9.0.20 released!



View PostgreSQL-Press related news.

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

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 of the CIText extension need to run a command. Users who have skipped multiple update releases may need to perform additional post-update steps; see the Release Notes for details.

Links:

Full View / NID: 54283 / Submitted by: The Zilla of Zuron

05.15.2015 - PHP 5.6.9 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.9. Several bugs have been fixed. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.9 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 54175 / Submitted by: The Zilla of Zuron

05.14.2015 - PHP 5.5.25 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.25. Several bugs have been fixed. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.25 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 54159 / Submitted by: The Zilla of Zuron

05.14.2015 - PHP 5.4.41 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.41. Seven security-related issues were fixed in this version. All PHP 5.4 users are encouraged to upgrade to this version. For source downloads of PHP 5.4.41 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 54158 / Submitted by: The Zilla of Zuron

05.12.2015 - pgBadger 7.0 released !



View PostgreSQL-Press related news.

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


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

Full View / NID: 54107 / Submitted by: The Zilla of Zuron

05.12.2015 - Call for Papers - PostgreSQL Conference Europe 2015



View PostgreSQL-Press related news.

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 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!

Full View / NID: 54098 / Submitted by: The Zilla of Zuron

05.05.2015 - Barman 1.4.1 released



View PostgreSQL-Press related news.

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 complete list of changes, see the "Release Notes" section below.

Links

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

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.

Full View / NID: 54000 / Submitted by: The Zilla of Zuron

04.20.2015 - Call for Papers, PostgreSQL Session #7, September, 24th



View PostgreSQL-Press related news.

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

Full View / NID: 53796 / Submitted by: The Zilla of Zuron

04.16.2015 - PHP 5.5.24 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.24. Several bugs have been fixed some of them beeing security related, like CVE-2015-1351 and CVE-2015-1352. All PHP 5.5 users are encouraged to upgrade to this version. For source downloads of PHP 5.5.24 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 53750 / Submitted by: The Zilla of Zuron

04.16.2015 - PHP 5.6.8 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.8. Several bugs have been fixed some of them beeing security related, like CVE-2015-1351 and CVE-2015-1352. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.8 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 53749 / Submitted by: The Zilla of Zuron

04.16.2015 - PHP 5.4.40 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.40. 14 security-related bugs were fixed in this release, including CVE-2014-9709, CVE-2015-2301, CVE-2015-2783, CVE-2015-1352. All PHP 5.4 users are encouraged to upgrade to this version. For source downloads of PHP 5.4.40 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog.
Full View / NID: 53748 / Submitted by: The Zilla of Zuron
  Most Viewed  
  Quick Links  
  Top Affiliates  
.......