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

Your Technical Computer Information Resource!  
     
 
Keep TACKtech.com free by purchasing something from our sponsors.
Make a financial contribution
  Open Source Technical Updates [Page: 10 of 72] @ TACKtech Corp.  

07.31.2015 - cstore_fdw 1.3 Release for Columnar Store PostgreSQL



View PostgreSQL-Press related news.

cstore_fdw is an open source columnar store extension which reduces the data storage footprint and disk I/O for PostgreSQL databases. The version 1.3 release of cstore_fdw is now available at github.com/citusdata/cstore_fdw. Release notes are available on the Citus Data blog.

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

07.28.2015 - pgCluu release 2.4 is out



View PostgreSQL-Press related news.

pgCluu 2.4 released

PostgreSQL Cluster Utilization

pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL server using psql and sar, a reports builder that will generate all HTML and charts output.

This release is a maintenance release that fix some issues. There's also some new interesting reports:

  • Transfers per second (read/write/both) on all devices from sar -b
  • Transfers per second for each device from sar -d .
  • Number of tasks created per second
  • Number of context switches per seconds.
  • Improve pg_stat_statement report by adding all shared block stats and read/write I/O timing per query when track_io_timing is enabled.
  • Add device with highest tps on overall system information.

and useful features:

  • Add --capture mode to pgcluu_collectd to be be able to build a snapshot of the PostgreSQL instance and exit. pgCluu will automatically adapt the report to this capture mode. It will use a temporary directory /tmp/pgcluu_capture to generate a tarball /tmp/pgcluu_capture.tar.gz containing the capture.
  • Add pgCluu logo and ico to the html output.
  • Add --charset option to be able to change the html charset, default: utf8.
  • Allow regular expression in database list available in reports, for example: with --db-only "p.*", only database beginning with p will be reported.
  • Allow pgcluu to parse and compute statistics from gzip compressed files.
  • pgcluu will not stop anymore if the sar file is not found, it will only show a warning message and continue.

This release also adds -r | --rotate-daily and -R | --rotate-hourly options to pgcluu_collectd be able to rotate statistic files on a daily or hourly basis. You can use -z or --compress option to compress rotated data files.

There also some code relative to next coming major release that will be used to allow a full incremental mode and a temporal selection into the collected statistics from a CGI program. This code enable caching (option -C or --cache) by dumping statistics stored in memory into binary files. With those files, data files can be removed (automatically with option -c or --clean) and report can be build later from them. This is not really useful now but this s the first stage to build incremental and cumulative reports.

See ChangeLog for a complete list of changes and bug fixes.

The goal of this project is to provide a complete PostgreSQL auditing tool that don't need any dependency to be run easily to audit a local or remote server.

If you just have a sar output file, pgCluu can be use to draw graphs about the system utilization only.

pgCluu is an original collection of tools built during my work at Dalibo. Those tools are published under the PostgreSQL License to be shared, any one is welcome to contribute.

For more information take a look at pgcluu.darold.net

View a sample report at pgcluu.darold.net/example/index.html

About:

pgCluu is created and maintained by Gilles Darold.

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

07.24.2015 - Alpha Release of 2ndQuadrant Unified Data Analytics (2UDA)



View PostgreSQL-Press related news.

2ndQuadrant is pleased to announce the alpha release of a new client platform for business intelligence - 2UDA (pronounced 'tudor').

2UDA is a data analytics application suite that unifies databases, spreadsheets, data mining and data visualisation in one seamless desktop installer.

Available to download now, 2UDA is packaged and ready to install with a choice of operating systems: Linux, OSX and Windows at http://2ndquadrant.com/2uda

Although primarily aimed at Data Analysts and Data Scientists, we encourage trial participation from developers and DBAs at this stage of the product development, to help us improve the function and user experience for all users.

More details on 2UDA at http://2ndquadrant.com/2uda

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

07.17.2015 - New ODBC Driver for PostgreSQL



View PostgreSQL-Press related news.

Devart team announced a release of a bran-new product - ODBC Driver for PostgreSQL. It provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, Linux, MacOS, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy.

The list of key features include:

  • Direct Connection. Database applications based on our solution get an opportunity to establish connection to PostgreSQL in Direct Mode. Direct Mode gives your applications an unrivalld advantage - connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application.

  • Development Platforms Variety. ODBC driver for PostgreSQL doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, Linux, Mac OS X, both 32-bit and 64-bit. So you can develop both 32-bit and 64-bit cross-platform applications.

  • ODBC Conformance. Our ODBC driver provides full support for common ODBC interface - ODBC Data Types support and ODBC API Functions support. In addition, we provide support for Advanced Connection String parameters. Thus allowing any desktop and web applications to connect to PostgreSQL from various environments and platforms, that support ODBC.

  • DB Compatibility. Our driver is compatible with major and the latest PostgreSQL server versions since 7.1 up to 9.4.

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

07.11.2015 - pgBadger 7.1 is out



View PostgreSQL-Press related news.

Paris, France - July 11th, 2015

DALIBO is proud to announce the release of pgBadger 7.1.

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

This new release fixes some issues and adds a new report:

  • Distribution of sessions per application

It also adds Json operators to SQL Beautifier.

For the complete list of changes, please checkout the release note on the changeLog

IMPORTANT: Note that new official releases must now be downloaded from GitHub and no more from SourceForge. Download at github.com/dalibo/pgbadger/releases

===== Links & Credits =====

DALIBO would like to thank the developers who submitted patches and the users who reported bugs and feature requests, especially Olivier Schiavo, Keith Fiske, Hubert Depesz Lubaczewski, Tom Burnett, Steve Crawford, Cyril Bouthors and Nicolas Thauvin.

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 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 dalibo.github.io

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

07.10.2015 - PHP 5.5.27 released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.5.27. Several bugs were fixed in this release as well as CVE-2015-3152. All PHP 5.5 users are encouraged to upgrade to this version. According to our release calendar, this PHP 5.5 version is the last planned release that contains regular bugfixes. All the consequent releases will contain only security-relevant fixes, for the term of one year. PHP 5.5 users that need further bugfixes are encouraged to upgrade to PHP 5.6. For source downloads of PHP 5.5.27 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: 55007 / Submitted by: The Zilla of Zuron

07.10.2015 - PHP 5.6.11 is available



View PHP related news. The PHP development team announces the immediate availability of PHP 5.6.11. Five security-related issues in PHP were fixed in this release, including CVE-2015-3152. All PHP 5.6 users are encouraged to upgrade to this version. For source downloads of PHP 5.6.11 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: 55006 / Submitted by: The Zilla of Zuron

07.09.2015 - PHP 5.4.43 Released



View PHP related news. The PHP development team announces the immediate availability of PHP 5.4.43. Five security-related issues in PHP were fixed in this release, including CVE-2015-3152. All PHP 5.4 users are encouraged to upgrade to this version. For source downloads of PHP 5.4.43 please visit our downloads page, Windows binaries can be found on windows.php.net/download/. The list of changes is recorded in the ChangeLog. Please note that PHP 5.4 branch is nearing the end of its support timeframe. If your PHP installations is based on PHP 5.4, it may be a good time to start making the plans for the upgrade.
Full View / NID: 54987 / Submitted by: The Zilla of Zuron

07.07.2015 - Open-Source Streaming-SQL Database PipelineDB Now Available



View PostgreSQL-Press related news.

PipelineDB, an open-source relational streaming-SQL database, publicly released version (0.7.7) today and made the product available as open-source via their website and GitHub. PipelineDB is based on, and is wire compatible with, PostgreSQL 9.4 and has added functionality including continuous SQL queries, probabilistic data structures, sliding windowing, and stream-table joins. For a full description of PipelineDB and its capabilities see their technical documentation.

PipelineDB’s fundamental abstraction is what is called a continuous view. These are much like regular SQL views, except that their defining SELECT queries can include streams as a source to read from. The most important property of continuous views is that they only store their output in the database. That output is then continuously updated incrementally as new data flows through streams, and raw stream data is discarded once all continuous views have read it. Let's look at a canonical example:

   CREATE CONTINUOUS VIEW v AS SELECT COUNT(*) FROM stream

Only one row would ever physically exist in PipelineDB for this continuous view, and its value would simply be incremented for each new event ingested.

For more information on PipelineDB as a company, product and for examples and benefits, please check out their first blog post on their new website.

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

07.02.2015 - PostgreSQL 9.5 Alpha 1 Released



View PostgreSQL-Press related news.

The PostgreSQL Global Development Group announces that the alpha release of PostgreSQL 9.5, the latest version of the world's leading open source database, is available today. This release contains previews of all of the features which will be available in the final release of version 9.5, although some details will change before then. Please download, test, and report what you find.

Major Features

Among new major features available for testing in this alpha are:

  • Block-Range Indexes (BRIN) which enable compact indexing of very large tables
  • Large speed improvements in in-memory sorting and hashing
  • Automated management of transaction log size
  • INSERT ON CONFLICT UPDATE, otherwise known as "UPSERT"
  • Grouping Sets, CUBE and ROLLUP analytic operations
  • Row-Level Security (RLS) support
  • More JSONB data manipulation functions and operators
  • Added the pg_rewind tool and other high availability improvements to replication
  • Multiple enhancements to Foreign Data Wrappers, including IMPORT FOREIGN SCHEMA
  • Large increases in multi-core and large memory scalability

These features expand the capabilities of PostgreSQL, and introduce new syntax, APIs, and management interfaces. Of course, there are many more features detailed in the release notes, some of which may be more exciting to you than the above. Please test every one you can.

Help Test for Bugs

As with other major releases, the improvements in PostgreSQL include changes to large amounts of code. We count on you to test the altered version with your workloads and testing tools in order to find bugs and regressions before the release of PostgreSQL 9.5.0. In addition to testing that the new features work as documented, consider testing the following:

  • Do the improvements in sorting and general performance actually increase performance in your application?
  • Do our code changes cause PostgreSQL to not function on your platform?
  • We've made changes to the transaction log, including compression. Does failover and disaster recovery still work as expected?
  • Do the changes in operator precedence change the results of your queries?
  • Does RLS work correctly to secure your data?

As this is an Alpha, changes to database behaviors, feature details, and APIs are still possible. Your feedback and testing will help determine the final tweaks on the new features, so test soon. The quality of user testing helps determine when we can make a final release.

Alpha and Beta Schedule

This is the alpha release of version 9.5, indicating that some changes to features are still possible before release. The PostgreSQL Project will release 9.5 beta 1 in August, and then periodically release additional betas as required for testing until the final release in late 2015. For more information, and suggestions on how to test the alpha and betas, see the Beta Testing page.

Full documentation and release notes of the new version is available online and also installs with PostgreSQL. Also see the What's New page for details on some features.

Links

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

06.28.2015 - Database .NET v16 released



View PostgreSQL-Press related news.

I am happy to announce the new major release of Database .NET v16, 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, Single executable file and Multi-language.

Major New features from version 14.8 to 16.0:

  • Added Group by Connection
  • Added Single-click button
  • Added Displaying Data Types on the column header
  • Added Search Connection Explorer
  • Added Importing and Exporting specific fields
  • Added Changing the column order of an existing table
  • Added Displaying Data Types on the column header
  • Support for SQL Decimal handling
  • Generating scripts: Auto Order by referenced tables
  • New AutoComplete and IntelliSense
  • New Connection Properties
  • ...and more

The new version is immediately available for download.

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

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
  Most Viewed  
  Quick Links  
  Top Affiliates  
........