Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!
Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!
The PostgreSQL Global Development Group has released an important update with fixes for multiple security issues to all supported versions of the PostgreSQL database system, which includes minor versions 9.4.1, 9.3.6, 9.2.10, 9.1.15, and 9.0.19. This update includes both security fixes and fixes for issues discovered since the last release. In particular for the 9.4 update, there is a change to the way unicode strings are escaped for the JSON and JSONB data types.
All users should update their PostgreSQL installation at the next opportunity.Security Fixes
This update fixes multiple security issues reported in PostgreSQL over the past few months. All of these issues require prior authentication, and some require additional conditions, and as such are not considered generally urgent. However, users should examine the list of security holes patched below in case they are particularly vulnerable.
This update also fixes the previously reported problem that, during regression testing on Windows, the test postmaster process was vulnerable to unauthorized connections. This vulnerability was fixed on non-Windows platforms in the prior update releases.
More information about these issues, as well as older patched issues, is available on the PostgreSQL Security Page.JSON and JSONB Unicode Escapes
The handling of Unicode escape strings for JSON and JSONB in PostgreSQL 9.4.0 has been changed in a way which may break compatibility for some users. To fix some inconsistencies, type JSONB no longer accepts the escape sequence "\u0000". Type JSON accepts "\u0000" only in contexts where it does not need to be converted to de-escaped form. See the release notes for more detail.Other Fixes and Improvements
In addition to the above, more than 60 reported issues have been fixed in this cumulative update release. Some of them affect only version 9.4, but many of them fix problems present in older versions. These fixes include:
In addition to the fixes above, the following contrib modules and extensions have had bugs fixed in this release: pg_upgrade, auto_explain, hstore, pageinspect, pgcrypto, pg_test_fsync, tablefunc, and xml2. Also, multiple functions across several contrib modules have been modified with the correct level of volatility. There are also multiple cleanup fixes based on minor issues found by the Coverity Scan static analyzer.
This update also contains many changes to PostgreSQL's timezone files. This includes an update to tzdata release 2015a, with updates to Chile, Mexico, Caicos Islands, and Fiji. PostgreSQL now takes date into account when assigning an offset based on a timezone abbreviation for historically changeable timezones. We have also done a general cleanup on timezone abbreviations, and added "CST" as an abbreviation for China Standard Time.
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.
Layer2, one of the leading providers of codeless data integration and synchronization tools in Europe, has announced full PostgreSQL support for their Cloud Connector.
You will find more Information here:
Nordic PGDay 2015 will be held in Copenhagen, Denmark, at the Radisson Blu Falconer hotel in Fredriksberg, on March 11. It will feature a full day with a single track of PostgreSQL presentations from both Nordic and global PostgreSQL experts, covering a wide range of topics.
The schedule has now been posted, and is available on the website.
We have also opened up registration for the event. Early bird registration (before Feb 11th or the first 40 registrations) costs â‚¬40, and normal registration costs â‚¬60. There is a limited number of seats available, so we suggest you register early to make sure you get a seat.
We also still have openings for Supporter sponsorship, which includes free entrance to the conference. For more information and instant sign-up.
We look forward to seeing you in Copenhagen in March!
26 January 2015: 2ndQuadrant is proud to announce the release of version 1.4.0 of Barman, Backup and Recovery Manager for PostgreSQL.
This major release features file-level incremental backup, a kind of full periodic backup which saves only data changes from the latest full backup available in the catalogue for a specific PostgreSQL server. Depending on the context and the database workload, the data deduplication ratio might easily reach 50-70% per full backup, leading to significant reductions in both backup time and disk space.
PostgreSQL 9.4 users will transparently benefit from the integration of Barman with "pg_stat_archiver" view. In particular, any continuous archiving problem will be immediately spotted by the "barman check" command directly on the source.
Management of WAL files has been improved, by optimising the calculation of WAL statistics, tying archiving with backup and by distinctively managing WAL trashing for exclusive and concurrent backups.
Relevant efforts in unit testing have made the code more robust. Minor bugs have also been fixed.
Many thanks for funding towards the development of this release go to BIJ12 (www.bij12.nl), Jobrapido (www.jobrapido.com), Navionics (www.navionics.com), Sovon Vogelonderzoek Nederland (www.sovon.nl), and Subito.it (www.subito.it).
For a complete list of changes, see the "Release Notes" section below.
Incremental backup is a kind of full periodic backup which saves only data changes from the latest full backup available in the catalogue for a specific PostgreSQL server. The main goals of incremental backup in Barman are:
This feature heavily relies on "rysnc" and hard links, which must be therefore supported by both the underlying operating system and the file system where the backup data resides.
The main concept is that two periodic base backups will share those files that have not changed, leading to relevant savings in disk usage. This is particularly true of VLDB contexts and, more in general, of those databases containing a high percentage of read-only historical tables. Barman implements incremental backup through a global/server option, called "reuse_backup", that transparently manages the "barman backup" command. Behaviour can also be changed at runtime through the "--reuse-backup" runtime option for the "barman backup" command.
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.
Debates abounded; coffee drunk; phone calls made at 8:30am on Saturday mornings; reporting queries run (of course in PostgreSQL). After reviewing 107 submissions, we are pleased to announce the PGConf US 2015 official schedule:
PGConf US 2015 is taking place in New York City from March 25-27 at the New York Marriott Downtown. We are offering a day of trainings on March 25 in addition to the First Annual Regulated Industry Summit as well as our regular sessions on March 26-27.
There are so many cool sessions (in fact, we added on another track!) that it is hard to highlight everything, but here is a small glimpse of what to expect:
Our early-bird registration is open and tickets at the early bird rate are available through February 1, 2015. Tickets can be purchased directly from here:
PGConf US 2015 is hosted by the United States PostgreSQL Association, a nonprofit 501(c)(3) created to support PostgreSQL in the United States through user group development, conferences, educational initiatives, and fun. We would not be able to produce PGConf US without the generous support of our sponsors. We would like to highlight our Platinum and Gold sponsors:
For more information, please visit http://www.pgconf.us/
We look forward to hosting you in March!
Paris, Jan. 20 2015
DALIBO is proud to present a new release of PoWA, a performance tool for PostgreSQL.
Please also note that the project has a new dedicated mailing list, available at email@example.com (https://groups.google.com/forum/?hl=fr#!forum/powa-users)
Feel free to join and ask any question.Realtime traffic analysis and dynamic graphs
PoWA is a workload analyzer that gives a clear view of the current activity of your PostgreSQL servers with a query runtime graph and a block hit/read graph along with a chart of time consuming requests over the specified time period.
If you zoom anywhere in one of the graphs, the chart will adjust and show you which queries were running at that time. If you click on a specific query, you will get additional graphs such as read/write time, number of rows affected, local and shared hit, etc.
A bunch of PL functions are also available to access and manage the stats.New features and changed in UI
DALIBO would like to thank the users and developpers who contributed to this release, especially Ahmed Bessifi and Luis Pinto Da Costa.
PoWA is an open project available under the PostgreSQL License. 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 to firstname.lastname@example.org (https://groups.google.com/forum/?hl=fr#!forum/powa-users)Links
PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.
Code & Demo at http://dalibo.github.io/powa/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
NipData, the provider of data modeling, presentation and integration software, is very pleased to announce the release of ByteDesigner 2.3.
See the entire news here: http://www.nipdata.com/news/
ByteDesigner is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!
Its a powerful database design tool, with advanced SQL Editor, and support for all major RDBMS, that can design complex systems.
Online documentation is found here:
Supported platforms (13):
Linux (Intel and PowerPC),
Solaris(Intel and Sparc),
Mac OS X(Intel and PowerPC)
for both 32 and 64 bit.
Databases supported (9): Oracle, ODBC, SQL92, MySQL, PostgreSQL, DB2, FireBird, MS SQL, SQLBase
The latest version of DBD::Pg, the Perl driver for Postgres, has been released. This version includes a much improved ping() method, and support for the new backslash-escaped placeholders, which will make working with things such as JSON much easier. The latest version can always be found on CPAN.
The MicroOLAP team is proud to introduce Database Designer for PostgreSQL with full support for PosgreSQL 9.4, an comprehensive CASE tool with intuitive graphical interface allowing you to
You're welcome to download the Database Designer for PostgreSQL 1.10.3 right now at: http://microolap.com/products/database/postgresql-designer/download/Feedback
Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/Full changelog:
Bucardo, a multiple source, multiple target replication system, has released version 5.3.0. The 'makedelta' system has been improved, and allows setting of makedelta at the database level. Bucardo can be downloaded from the Bucardo wiki
I am happy to announce the new major release of Database .NET 14.0, 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 12.7 to 14.0:
18 DECEMBER 2014: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.4, the latest version of the world's leading open source database system. This release adds many new features which enhance PostgreSQL's flexibility, scalability and performance for many different types of database users, including improvements to JSON support, replication and index performance.Flexibility
With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can have both at the same time. JSONB supports fast lookups and simple expression search queries using Generalized Inverted Indexes (GIN). Multiple new support functions enable users to extract and manipulate JSON data, with a performance which matches or surpasses the most popular document databases. With JSONB, table data can be easily integrated with document data for a fully integrated database environment.
In 9.4, Logical Decoding supplies a new API for reading, filtering and manipulating the PostgreSQL replication stream. This interface is the foundation for new replication tools, such as Bi-Directional Replication, which supports the creation of multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.
"The main reason behind our immediate adoption of PostgreSQL 9.4 in production is the new Logical Decoding feature," said Marco Favale, Cartographic Production Manager of Navionics. "The ability to write custom and flexible output plugins will allow us to transparently collect changes on selected tables and replicate changes where we like, by removing heavier - and more complex to manage - trigger based replication solutions."
"Zalando relies on the stability and performance of hundreds of PostgreSQL database servers to continuously serve millions of customers all around Europe," said Valentine Gogichashvili, Team Lead Database Operations at Zalando Technologies. "We are excited to run time-delayed standby servers which work out of the box, and will evaluate the new bi-directional replication tools as soon as they are released."Performance
Version 9.4 also introduces multiple performance improvements which will allow users to get even more out of each PostgreSQL server. These include:
"We will definitely benefit from concurrent refresh of materialised views, delayed standby servers (which will make our disaster recovery even more robust) as well as the usual performance improvements every new release carries on," added Marco Favale.Links
PostgreSQL is the leading open source database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community on our web page.
We have finished the schedule for FOSDEM PGDay and the PostgreSQL Devroom at FOSDEM 2015 - our apologies for the delay in processing!
You will find a number of great talks both on PostgreSQL usage and development from great speakers. And of course, it will as usual feature the Hallway Track, where you can network with fellow PostgreSQL users!
We have also opened registration. Number of seats are limited, and as we sold out last year, we recommend that you make your reservation as soon as possible. Registration is â‚¬50 for all attendees for the PGDay on Friday. No registration is necessary if you only want to attend the Devroom at FOSDEM on Saturday.
Finally, we'd like to remind you that our rate with the conference hotel (Marriott Brussels) will expire on Dec 15th. Therefore, we recommend that you book your accommodations as soon as possible!
We hope to see you in Brussels in January!
The PostgreSQL Global Development Group has released 9.4 RC 1, the first release candiate for the next version of PostgreSQL. This release should be identical to the final version of PostgreSQL 9.4, excepting any fixes for bugs found in the next two weeks. Please download, test, and report what you find.
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 RC 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 this release candidate should be identical to 9.4.0, allowing you to build and test your applications against it. More information on how to test and report issues
Get the PostgreSQL 9.4 RC 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.