Discuss, share, learn about the world's best open source database, PostgreSQL. News, articles, tips, scripts, forums, and more.

PostgreSQL JDBC 42.2.4 Released (Regression fix)

This is primarily a fix for a regression related to fn timestampadd(SQL_TSI_MINUTE) SQL_TSI_MINUTE seems to be acting like SQL_TSI_SECOND in 42.2.3. PR 1250

See full changelog here

Continue reading...

JDBC 42.2.3 Released

The JDBC project is proud to announce the latest version 42.2.3. This release fixes some annoyances such as:

  • Reduce the severity of the error log messages when an exception is re-thrown. The error will be thrown to caller to be dealt with so no need to log at this verbosity by pgjdbc
  • Support parenthesis in {oj ...} JDBC escape syntax
  • getString for PGObject-based types returned "null" string instead of null
  • Field metadata cache can be disabled via databaseMetadataCacheFields=0
  • Properly encode special symbols in passwords in BaseDataSource
  • Adjust date, hour, minute, second when rounding nanosecond part of a timestamp
  • Encode URL parameters in BaseDataSource

As well as some performance enhancements:

  • reduce memory allocations in query cache
  • reduce memory allocations in SQL parser

The complete changelog can be reviewed here https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.3

You can download the PostgreSQL JDBC Driver at https://jdbc.postgresql.org/download.html

The JDBC team would like to thank everyone who contributed code and reviews: contributors

Continue reading...

Announcing the release of E-Maj 2.3.0

We are very glad to announce the 2.3.0 version of E-Maj.

E-Maj is a PostgreSQL extension which enables fine-grained write logging and time travel on subsets of the database.

This new version supports from 9.2 to v11 PostgreSQL versions. It is a new step in giving more flexibility in tables groups management. In particular, it allows to add tables or sequences to groups or move tables or sequences from one group to another without being obliged to stop/restart the logging mecanism (and loose the capability to 'rollback' to a previous point in time).

Both web clients, Emaj_web and the phpPgAdmin plugin, have been enhanced to take benefit from this feature.

Two new characters mode clients have been added. Written in perl, they bring the same features as the existing php clients: launch parallel E-Maj rollback and monitor E-Maj rollbacks.

The full documentation is available on line. The core extension is available at pgxn.org or github.org.

The phpPgAdmin plugin and the Emaj_web application are also available at github.org.

Have fun with E-Maj !

Continue reading...

PostgreSQL 11 Beta 2 Released!

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 11 is now available for download. This release contains previews of all features that will be available in the final release of PostgreSQL 11 (though some details of the release could change before then) as well as bug fixes that were reported during the first beta.

In the spirit of the open source PostgreSQL community, we strongly encourage you to test the new features of PostgreSQL 11 in your database systems to help us eliminate any bugs or other issues that may exist. While we do not advise for you to run PostgreSQL 11 Beta 2 in your production environments, we encourage you to find ways to run your typical application workloads against this beta release.

Upgrading to PostgreSQL 11 Beta 2

To upgrade to PostgreSQL 11 Beta 2 from Beta 1 or an earlier version of PostgreSQL, you will to use a strategy similar to upgrading between major versions of PostgreSQL (e.g. pg_upgrade or pg_dump / pg_restore). For more information, please visit the documentation section on upgrading.

Changes to Major Features of PostgreSQL 11

The PostgreSQL 11 Beta 1 release announced "Channel Binding for SCRAM Authentication" as a major feature as it could prevent man-in-the-middle attacks when using SCRAM authentication. During the course of testing, it was determined that libpq, the client connection library for PostgreSQL, is unable force the use of channel binding.

While this functionality can be fixed in a future version of PostgreSQL, for now channel binding for SCRAM authentication will not be considered a major feature for PostgreSQL 11.

Changes Since Beta 2

There have been many bug fixes for PostgreSQL 11 reported during the Beta 1 period and applied to the Beta 2 release. Several bug fixes reported for version 10 or earlier that also affected version 11 are included in the Beta 2 release. These fixes include:

  • Several fixes for XML support, including using the document node as the context for XPath queries as defined in the SQL standard, which affects the xpath and xpath_exists functions, as well as XMLTABLE
  • Several fixes related to VACUUM, including potential data corruption issues
  • Fixes for partitioning, including ensuring partitioning works with temporary tables, eliminating a needless additional partition constraint checks on INSERTs and generating incorrect paths for partitionwise aggregates
  • Fix for potential replica server crashes where a replica would attempt to read a recycled WAL segment
  • Fixes for pg_replication_slot_advance including returning NULL if slot is not advanced and changes for how the slot is updated depending on if it is a physical or logical replication slot
  • Ensure pg_resetwal works with relative paths to data directory
  • Fixes for query parallelism, including preventing a crash by ignoring "parallel append" for parallel unsafe paths in a query plan
  • Fix returning accurate results with variance and similar aggregate functions when executed using parallel query
  • Fix issue where COPY FROM .. WITH HEADER would drop a line after every 4,294,967,296 lines processed
  • Ensure the "B" (bytes) parameter is accepted by all memory-related configuration parameters
  • Several fixes for the JSONB transform in PL/Python and PL/Perl
  • Fix for plpgsql checking statements where it needs to check original write statement before rewrite, could cause crash
  • Fix for SHOW ALL to display superuser configuration settings to roles that are allowed to read all settings
  • Fix for pg_upgrade that ensures defaults are written when using the "fast ALTER TABLE .. ADD COLUMN" feature with a non-NULL default
  • Several fixes for memory leaks
  • Several fixes specific to the Windows platform

This update also contains tzdata release 2018e, with updates for North Korea. The 2018e also reintroduces the negative-DST changes that were originally introduced in 2018a, which affects historical and present timestamps for Ireland (1971-), as well as historical timestamps for Namibia (1994-2017) and the former Czechoslovakia (1946-1947). If your application is storing timestamps with those timezones in the affected date ranges, we ask that you please test to ensure your applications behave as expected.

Testing for Bugs & Compatibility

The stability of each PostgreSQL release greatly depends on you, the community, to test the upcoming version with your workloads and testing tools in order to find bugs and regressions before the release of PostgreSQL 11. As this is a Beta, minor 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 please test in the near future. The quality of user testing helps determine when we can make a final release.

A list of open issues is publicly available in the PostgreSQL wiki. You can report bugs using this form on the PostgreSQL website:


Beta Schedule

This is the second beta release of version 11. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release in late 2018. For further information please see the Beta Testing page.


Continue reading...

RazorSQL 8 SQL Editor and Database Query Tool Released

RazorSQL 8, an SQL editor, database query tool, database browser, and database administration tool, is now available for Windows, Mac, and Linux. Using RazorSQL, users can query, edit, browse, and manage dozens of databases from one tool. RazorSQL supports over 40 databases, including PostgreSQL. Connect to other databases via JDBC or ODBC (Windows only). Users can also use the built in relational database engine for their database needs.

Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects such as tables, views, indexes, procedures, functions, and triggers; tools for importing and exporting data in various formats such as MS Excel, delimited files, SQL insert statements, HTML, XML, JSON, and text; a database browser for the viewing of database objects and structures; search tools for searching for database objects and database data, tools for building SQL queries and generating SQL and DDL, a SQL formatting tool, SQL history tracking and and SQL favorites tool for storing frequently used SQL statements, and a programming editor and query tool with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and many other programming languages that features tools for searching and replacing data, programmable macros, coding sidekicks for various programming languages, a file system browser, function and method browsers, and much more.

New features in version 8 include database conversion support from Firebird to nine different databases including PostgreSQL.

Versions of RazorSQL are available for Windows, macOS, Mac OS X, Linux, and Solaris.

RazorSQL 8 is available for immediate download at https://razorsql.com/

Pricing of RazorSQL starts at $99.95 USD for a single user, and tiered discounts are offered for multiple license purchases.

More Info: https://razorsql.com/

Download URL: https://razorsql.com/download.html

Change Log: https://razorsql.com/updates.html

Continue reading...