Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

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!

PostgreSQL News
Syndicate content
PostgreSQL news
Updated: 18 hours 1 min ago

PostgreSQL 9.5 Beta 1 Released

Thu, 10/08/2015 - 01:00

The PostgreSQL Global Development Group announces today that the first beta release of PostgreSQL 9.5 is available for download. This release should contain all features and APIs which will be in the final release with few, if any, changes. Users should begin testing their applications against 9.5 Beta 1 in preparation for the final release.

Changes Since Alpha2

Many bugs and issues reported by our users and contributors have been fixed since the release of Alpha2. These include:

  • significant adjustments to Row Level Security (RLS) semantics
  • deadlock with LWLock improvements
  • index corruption issue with BRIN indexes
  • couldn't connect using PGSSLMODE=require on Windows
  • various problems with commit timestamp tracking
  • hash join memory leak
  • inconsistent behavior of jsonb_set with array append

In particular, the semantics of Row Level Security have been changed to be consistent with the existing PostgreSQL GRANT-based permissions system. As an example, RLS now applies both the INSERT policies and the SELECT policies when INSERT with RETURNING is used. Users should test the RLS application of RLS policies and re-test any existing RLS configuration to ensure that there are no regressions for their use-cases. For more information, see the documentation on Create Policy and RLS.

If you reported an issue while testing PostgreSQL 9.5, please download Beta1 and test whether that issue has been fixed. If you have not yet tested version 9.5, now is the time for you to help out PostgreSQL development. Known issues which are still open are listed on the Open Items page.

Beta Schedule

This is first beta release of version 9.5, indicating that very few user-visible feature changes are expected before final release. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2015. For more information, and suggestions on how to test the 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.

Categories: Database, Open Source

2015-10-08 Security Update Release

Thu, 10/08/2015 - 01:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.4.5, 9.3.10, 9.2.14, 9.1.19 and 9.0.23. This release fixes two security issues, as well as several bugs found over the last four months. Users vulnerable to the security issues should update their installations immediately; other users should update at the next scheduled downtime. This is also the final update release for major version 9.0.

Security Fixes

Two security issues have been fixed in this release which affect users of specific PostgreSQL features:

CVE-2015-5289: json or jsonb input values constructed from arbitrary user input can crash the PostgreSQL server and cause a denial of service.

CVE-2015-5288: The crypt() function included with the optional pgCrypto extension could be exploited to read a few additional bytes of memory. No working exploit for this issue has been developed.

The PostgreSQL project thanks Josh Kupershmidt and Oskari Saarenmaa for reporting these issues.

This update will also disable SSL renegotiation by default; previously, it was enabled by default. SSL renegotiation will be removed entirely in PostgreSQL versions 9.5 and later.

Other Fixes and Improvements

In addition to the above, many other issues were patched in this release based on bugs reported by our users over the last few months. These fixes include:

  • Prevent deeply nested regex, LIKE and SIMILAR matching from crashing the server
  • Multiple other fixes with regular expression handling
  • Ensure that ALTER TABLE sets all locks for CONSTRAINT modifications
  • Fix subtransaction cleanup when a cursor fails, preventing a crash
  • Prevent deadlock during WAL insertion when commit_delay is set
  • Fix locking during updating of updatable views
  • Prevent corruption of relation cache "init file"
  • Improve performance of large SPI query results
  • Improve LISTEN startup time
  • Disable SSL renegotiation by default
  • Lower minimum for *_freeze_max_age parameters
  • Limit the maximum for wal_buffers to 2GB
  • Guard against potential stack overflows in several areas
  • Fix handling of DOW and DOY in datetime input
  • Allow regular expression queries to be canceled sooner
  • Fix assorted planner bugs
  • Fix several shutdown issues in the postmaster
  • Make anti-wraparound autovacuuming more robust
  • Fix minor issues with GIN and SP-GiST indexes.
  • Fix several issues with PL/Python, PL/Perl and PL/Tcl
  • Improve pg_stat_statements' garbage collection
  • Improve collation handling in pgsql_fdw
  • Improve libpq's handling of out-of-memory conditions
  • Prevent psql crash when there is no current connection
  • Multiple fixes to pg_dump, including file and object permissions
  • Improve handling of privileges when dumping from old PostgreSQL versions
  • Fix issues with support of Alpha, PPC, AIX and Solaris platforms
  • Fix startup issue on Windows with Chinese locale
  • Fix Windows install.bat script to handle spaces in filenames
  • Make the numeric PostgreSQL version number available to extensions

This update also contains tzdata release 2015g, with updates for Cayman Islands, Fiji, Moldova, Morocco, Norfolk Island, North Korea, Turkey, Uruguay, and the new zone America/Fort_Nelson.

Final Update for 9.0

9.0.23 is the final update for major version 9.0, which is now End-Of-Life (EOL) as scheduled. Future security updates will not include version 9.0. As such, users of that version should plan to upgrade to another major version as soon as possible. For more information about the community's support policy and EOL schedule, see the Versioning Policy.


All PostgreSQL update releases are cumulative. 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.

Categories: Database, Open Source

Barman 1.5.0 released

Mon, 09/28/2015 - 01:00

2ndQuadrant is proud to announce the release of version 1.5.0 of Barman, Backup and Recovery Manager for PostgreSQL.

This major release features the get-wal command, which turns Barman into a WAL mine from which you can extract any transaction log file you need. Barman can now be easily integrated with any PostgreSQL standby server as a fallback method for WAL synchronisation.

Another important new feature is retry hook scripts that can be executed before or after a backup command or the archive of a WAL file. Differently from a standard hook script, already available in Barman, a retry hook script is executed indefinitely until it succeeds.

With version 1.5.0, Barman enhances its robustness, by adding checks on "wal_level" settings, by forbidding the deletion of a running backup, by requesting a successful "check" before initiating a backup, etc.

Barman now checks for conflicting paths, making sure that the same directory cannot be shared by more than a target (i.e. base backups, WAL archive, incoming directory, etc.), even across different servers within the same installation.

In terms of user experience, the "active" option grants users to temporarily disable a server in Barman, for operational purposes, while still accessing its catalogue.

Minor bugs have also been fixed.

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

Features in detail

Barman get-wal : No more standby servers that fall out of synchronisation with the master server, thanks to Barman's "get-wal" command. Design complex HA and DR architectures of PostgreSQL databases, knowing that you can now rely on an 'infinite' source of WAL files for any of your servers. Look at the "barman-wal-restore" script for an idea on how you can integrate "get-wal" with your PostgreSQL standby servers.

Retry hook scripts : You can now extend Barman by plugging your custom scripts before and after taking a backup operation or archiving a WAL file, knowing that Barman will repeat them until they succeed. You can now build your own pipeline around Barman, for example by storing a WAL in the cloud once it reaches Barman.

Links Release notes
  • Add support for the "get-wal" command which allows users to fetch any WAL file from the archive of a specific server
  • Add support for retry hook scripts, a special kind of hook scripts that Barman tries to run until they succeed
  • Add "active" configuration option for a server to temporarily disable the server by setting it to "False"
  • Add "barman_lock_directory" global option to change the location of lock files (by default: 'barman_home')
  • Execute the full suite of checks before starting a backup, and skip it in case one or more checks fail
  • Forbid to delete a running backup
  • Analyse include directives of a PostgreSQL server during "backup" and "recover" operations
  • Add check for conflicting paths in the configuration of Barman, both intra (by temporarily disabling a server) and inter-server (by refusing any command, to any server).
  • Add check for "wal_level"
  • Add "barman-wal-restore" script to be used as "restore_command" on a standby server, in conjunction with "barman get-wal"
  • Implement a standard and consistent policy for error management
  • Improved cache management of backups
  • Improved management of configuration in unit tests
  • Tutorial and man page sources have been converted to Markdown format
  • Add code documentation through Sphinx
  • Complete refactor of the code responsible for managing the "backup" and the "recover" commands
  • Changed internal directory structure of a backup
  • Introduce "copy_method" option (currently fixed to "rsync")
  • Bug fixes:
    • Manage options without '=' in PostgreSQL configuration files
    • Preserve Timeline history files (Fixes: #70)
    • Workaround for rsync on SUSE Linux (Closes: #13 and #26)
    • Disables dangerous settings in (Closes: #68)
    • Fixed error in WAL rate calculation
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.

Categories: Database, Open Source

JDBC 1203 released

Thu, 09/24/2015 - 01:00

This release is primarily a bug fix for 1202 which focussed on performance and optimization. One notable feature was the addition of statement caching! The full changelog can be found here:

For more information please visit:

Categories: Database, Open Source

PostgresDAC meets RAD Studio 10 Seattle!

Tue, 09/22/2015 - 01:00
PostgresDAC v3.0.3 with support for Delphi and C++ Builder 10 Seattle is available immediately! Download

You're welcome to download the PostgresDAC v3.0.3 right now at: or login to your private area on our site at


Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at

Categories: Database, Open Source

dbMigration .NET 1.0 released

Sun, 08/23/2015 - 01:00

dbMigration .NET is a simple, easy and intuitive multiple database migration tool, With it you can easily migrate schema and data between different databases without complicated procedure. Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro...etc.

Major features:

  • Automatic column matching
  • SQL preview
  • Filter source data
  • Show target results
  • Integrated with Database .NET
  • BLOB type support
  • Command-Line support

For more information please visit

Categories: Database, Open Source

SQL Relay 0.62 release announcement

Thu, 08/20/2015 - 01:00

SQL Relay 0.62 is now generally available.

SQL Relay is a connection pool, load balancer, query router, and database proxy. It supports many databases, including PostgreSQL and provides API's for most popular programming languages and database abstraction layers.

Categories: Database, Open Source

2UDA Alpha 2 Release Available

Wed, 08/19/2015 - 01:00

Enhanced alpha release of new data analytics application available.

2ndQuadrant is pleased to announce further enhancements to 2UDA (pronounced 'Tudor'), our new data analytics application suite currently under development, and available to try now.

This second alpha release brings a number of enhancements and product updates, based on user feedback and the continuous development of the core applications 2UDA unifies:

  • PostgreSQL server daemon is now an OS service (named "org.2ndQ.2UDA.postgres-9.5") on OS X
  • PostgreSQL server daemon is now an OS service (named "2uda-postgresql-9.5") on Linux (tested on Ubuntu 14.04, CentOS 7, openSUSE 13.2, & Fedora 22)
  • Windows installer is now certified from Microsoft and signed digitally
  • Latest PostgreSQL 9.5 after its Alpha 2 release has been included. Details of changes are listed
  • Latest Orange 3 has been included. This version uses the new tablesample patch in PostgreSQL rather than relying on blocksample extension.
  • Latest LibreOffice 5 has been included.
  • The installer now checks for server readiness before loading sample database. This prevents a bug where sample data got loaded while the server was still consolidating its connections.
  • Other small bugs and tweaks.

Download a copy now and let us know what you think:

Categories: Database, Open Source

CitusDB 4.1 Released

Mon, 08/17/2015 - 01:00

CitusDB 4.1, which is based on the new PostgreSQL 9.4.4 release, is now GA. CitusDB is a scalable PostgreSQL database with massively parallel query processing for real-time Big Data applications. The 4.1 release is focused on improving usability and adding some of the most requested SQL features.

Categories: Database, Open Source

PostgreSQL FTS for Drupal project started

Sat, 08/08/2015 - 01:00

PostgreSQL Full Text Search for Drupal has been launched as a project. This project will allow the use of full Tsearch2 capabilities within Drupal-based websites. Currently supported features include:

  • Create and maintain PostgreSQL FTS indexes (also called field indexes in this module)
  • Indexes are based on columns and instance combinations
  • Indexes maintain themselves (act on CRUD actions of field data)
  • Basic Views integration (full text search filter handler per index)

If you use Drupal with PostgreSQL, join the project to help out.

Categories: Database, Open Source

PostgreSQL 9.5 Alpha 2 Released

Thu, 08/06/2015 - 01:00

The PostgreSQL Global Development Group announces today that the second alpha release of PostgreSQL 9.5 is available for download. 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.

Changes Since Alpha1

Many bugs and issues reported by our users and contributors have been fixed since the release of Alpha1. These include:

  • Make pg_rewind work with symlinks
  • Fix several issue with locking
  • Numerous changes and improvements to Row Level Security
  • Make pg_dump back up RLS policies
  • Correct some oversights in BRIN indexes
  • Fix behavior of JSON negative array subscripts
  • Correct strxfrm() behavior on buggy platforms
  • Multiple documentation changes and additions

If you reported an issue while testing PostgreSQL 9.5, please download Alpha2 and test whether that issue has been fixed. If you have not yet tested version 9.5, now is the time for you to help out PostgreSQL development.

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 another alpha or beta in September, and then periodically release alphas or 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.

Categories: Database, Open Source

Devart Released a new version of dotConnect for PostgreSQL

Tue, 08/04/2015 - 01:00

Devart released the new version of ADO.NET data provider dotConnect for PostgreSQL. The new version has a support for the latest Visual Studio 2015.

Now the product is available for using in projects targeted for the newest .NET Framework 4.6 and getting benefits from the latest Visual Studio features, such as shared projects, new and updated debugging and diagnostics tools, and many others.

The product has free and commercial editions both. To learn more about this release visit dotConnect for PostgreSQL homepage.

Categories: Database, Open Source

cstore_fdw 1.3 Release for Columnar Store PostgreSQL

Fri, 07/31/2015 - 01:00

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 Release notes are available on the Citus Data blog.

Categories: Database, Open Source

pg_shard 1.2 Released for Scaling Out PostgreSQL

Fri, 07/31/2015 - 01:00

pg-shard is an open source extension for sharding and scaling out PostgreSQL across a cluster of high availability servers. The version 1.2 release is now available for download on the Citus Data pg-shard GitHub page.

Categories: Database, Open Source

pgCluu release 2.4 is out

Tue, 07/28/2015 - 01:00
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

View a sample report at


pgCluu is created and maintained by Gilles Darold.

Categories: Database, Open Source

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

Fri, 07/24/2015 - 01:00

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

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

Categories: Database, Open Source

New ODBC Driver for PostgreSQL

Fri, 07/17/2015 - 01:00

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.

Categories: Database, Open Source

pgBadger 7.1 is out

Sat, 07/11/2015 - 01:00

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

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

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

Categories: Database, Open Source

Open-Source Streaming-SQL Database PipelineDB Now Available

Tue, 07/07/2015 - 01:00

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:


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.

Categories: Database, Open Source

PostgreSQL 9.5 Alpha 1 Released

Thu, 07/02/2015 - 01:00

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.

Categories: Database, Open Source