Jelenlegi hely

PostreSQL.org

Feliratkozás PostreSQL.org hírcsatorna csatornájára
PostgreSQL news
Frissítve: 2 nap 17 óra

OmniDB 2.8 Available - Now with Support for 3rd Generation Postgres-BDR

2018, május 17 - 02:00

Oxford, United Kingdom — May 17, 2018

2ndQuadrant announced today the release of OmniDB 2.8. OmniDB is an interactive and powerful, yet lightweight, browser-based database management tool. OmniDB 2.8 allows users to manage multiple databases in a unified workspace with a user-friendly and fast-performing interface.

This new release presents important performance improvements: OmniDB is capable of connecting and identifying main structures such as tables, keys, indexes, and constraints in an impressive response time averaging less than 0.1 seconds.

OmniDB 2.8 introduces the following new features:

  • Support for BDR 3.0. OmniDB now manages BDR groups, allowing the user to view/add/remove nodes from groups and perform all tasks in every node.
  • Connection to any database via SSH tunnels. When connecting to a remote database through the Internet, SSH tunnels provide improved security to the database connection.

This release presents improvements including:

  • Backslash commands supporting PostgreSQL 10 partitioned tables and partitions.
  • DDL for PostgreSQL 10 partitioned tables and partitions.
  • Tree view shows PostgreSQL 10 partitioned tables and partitions with different icons.
  • Improvements to the OmniDB app window container.

The bug fixes included in this release are:

  • Fixed displaying table data in treeview when using MySQL 5.7.
  • Fixed column autocomplete when using MySQL and MariaDB.
  • Fixed JSON and JSONB editing.

For a complete list of updates, read the OmniDB change tracker here.

OmniDB 2.8 is available for download here and installation instructions are available here.

For more information, please email info@2ndQuadrant.com

Kategóriák: Informatika

Call for papers - PostgresOpen 2018, September 5-7 in San Francisco, CA

2018, május 14 - 02:00
The Call For Papers for PostgresOpen SV 2018 is now open!

PostgresOpen, the U.S. PostgreSQL community conference, is back this year taking place in downtown San Francisco from September 5th to 7th.

If you are working with PostgreSQL, please go here and submit a talk!

Presentations can be on any topic related to PostgreSQL, including, but not limited to:

  • Case studies
  • Experiences
  • Tools and utilities
  • Migration stories
  • Existing features
  • New feature development
  • Benchmarks
  • Performance tuning
  • Data science

The 2018 PostgresOpen Committee looks forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to San Francisco! We're only able to do that with support from our great sponsors!

PostgresOpen would not be possible without the support of our sponsors, a special thanks to our sponsors:

If you are interested in sponsoring, please visit our sponsor prospectus here

Anyone and everyone in the PostgreSQL community is encouraged to submit a talk. Talks will be accepted up until June 12th. Speakers will be notified by June 19th, with the schedule to be published once selected speakers have confirmed. Join us in celebrating our 8th conference year! We look forward to seeing everyone in San Francisco!

Any questions? Please contact: program2018(at)postgresopen(dot)org

Kategóriák: Informatika

PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18, and 9.3.23 released!

2018, május 10 - 02:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.4, 9.6.9, 9.5.13, 9.4.18, 9.3.23. This release fixes one security issue as well as several bugs reported over the last three months. Users should plan to update at the next convenient downtime.

Please see the "Updating" section for post-installation steps for the security fix and the "incorrect volatility and parallel-safety markings" fix.

Please note that PostgreSQL changed its versioning scheme with the release of version 10.0, so updating to version 10.4 from 10.0, 10.1, 10.2, or 10.3 is considered a minor update.

Security Issues

One security vulnerability has been closed by this release:

  • CVE-2018-1115: Too-permissive access control list on function pg_logfile_rotate()

Please see the "Updating" section below for post-update steps.

Bug Fixes and Improvements

This update also fixes over 50 bugs reported in the last several months. Some of these issues affect only version 10, but many affect all supported versions.

These fixes include:

  • Fix incorrect volatility and parallel-safety markings on several built-in functions to ensure correct query planning optimizations
  • Several fixes for partitioning, including potential crashes as well as allowing TRUE and FALSE to be used as partition bounds
  • Fix where a new TOAST value could be assigned to a dead-but-not-yet-vacuumed TOAST OID, which would result in an error similar to "unexpected chunk number 0 (expected 1) for toast value nnnnn"
  • Fix "CREATE TABLE ... LIKE" with bigint identity columns on 32-bit platforms
  • Fix memory leak within the runtime of a query that repeatedly executes hash joins
  • Several crash fixes around queries using GROUPING SET
  • Avoid failure if a query-cancel or session-termination interrupt occurs while committing a prepared transaction
  • Reduce locking during autovacuum worker scheduling, which prevents loss of potential worker concurrency
  • Fix possible slow execution of REFRESH MATERIALIZED VIEW CONCURRENTLY
  • Several fixes around query plans that use "index-only" scans
  • Avoid deadlocks in concurrent CREATE INDEX CONCURRENTLY commands that are run under SERIALIZABLE or REPEATABLE READ transaction isolation
  • Several fixes for SP-GiST indexes, including one collation-aware searches on text columns
  • Fixes related to counting the number of tuples in partial GiST, SP-GiST, and Bloom indexes
  • Several fixes for logical decoding and replication
  • Fix misquoting of values for list-valued GUC variables (e.g. local_preload_libraries, session_preload_libraries, shared_preload_libraries, temp_tablespaces) in dumps
  • Several fixes for pg_stat_activity
  • Several fixes for ecpg
  • Fix for pg_recvlogical to ensure compatibility with PostgreSQL versions released before 10
  • Several fixes for pg_rewind

This update also contains tzdata release 2018d, with updates for Palestine and Antarctica (Casey Station), plus historical corrections for Portugal and its colonies, as well as Enderbury, Jamaica, Turks & Caicos Islands, and Uruguay.

Updating

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 to apply this update release (though for this release, please see the note about "volatility and parallel-safety markings"); you may simply shut down PostgreSQL and update its binaries.

Users who have skipped one or more update releases may need to run additional, post-update steps; please see the release notes for earlier versions for details.

Post-Installation Steps for CVE-2018-1115

If you installed "adminpack" in any PostgreSQL 9.6 or 10 release you will need to have your database administrator run the following command in every database that "adminpack" is installed in:

ALTER EXTENSION adminpack UPDATE; Post-Installation Steps for Function Markings

Functions that should be marked "volatile"

  • cursor_to_xml
  • cursor_to_xmlschema
  • query_to_xml
  • query_to_xml_and_xmlschema
  • query_to_xmlschema

Functions that should be marked "parallel-unsafe"

  • binary_upgrade_create_empty_extension,
  • brin_desummarize_range
  • brin_summarize_new_values
  • brin_summarize_range
  • cursor_to_xml
  • cursor_to_xmlschema
  • gin_clean_pending_list
  • pg_import_system_collations
  • ts_rewrite
  • ts_stat

If you use any of the above functions, you can update the markings in the following ways:

Option 1: Update the markings manually in the "pg_proc" table in each database you use

these functions. You can achieve this by executing the following commands as a database superuser:

/* Functions that should be marked "volatile" */ ALTER FUNCTION pg_catalog.cursor_to_xml(refcursor, int, boolean, boolean, text) VOLATILE; ALTER FUNCTION pg_catalog.cursor_to_xmlschema(refcursor, boolean, boolean, text) VOLATILE; ALTER FUNCTION pg_catalog.query_to_xml(text, boolean, boolean, text) VOLATILE; ALTER FUNCTION pg_catalog.query_to_xml_and_xmlschema(text, boolean, boolean, text) VOLATILE; ALTER FUNCTION pg_catalog.query_to_xmlschema(text, boolean, boolean, text) VOLATILE; /* Functions that should be marked "parallel-unsafe" */ ALTER FUNCTION pg_catalog.binary_upgrade_create_empty_extension(text, text, bool, text, _oid, _text, _text) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.brin_desummarize_range(regclass, bigint) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.brin_summarize_new_values(regclass) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.brin_summarize_range(regclass, bigint) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.cursor_to_xml(refcursor, int, boolean, boolean, text) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.cursor_to_xmlschema(refcursor, boolean, boolean, text) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.gin_clean_pending_list(regclass) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.pg_import_system_collations(regnamespace) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.ts_rewrite(tsquery, text) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.ts_stat(text) PARALLEL UNSAFE; ALTER FUNCTION pg_catalog.ts_stat(text, text) PARALLEL UNSAFE;

Option 2: Run a pg_upgrade to a version containing the correct marking data (e.g. 10.4 and above)

Links
  • Download: https://www.postgresql.org/download/
  • Release Notes: https://www.postgresql.org/docs/current/static/release.html
  • Security Page: https://www.postgresql.org/support/security/
  • Versioning Policy: https://www.postgresql.org/support/versioning/
  • Follow @postgresql on Twitter: https://twitter.com/postgresql
Kategóriák: Informatika

pgBackRest 2.02 Released

2018, május 8 - 02:00

May 8, 2018: Crunchy Data announces the release of pgBackRest 2.02, the latest version of the simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.

pgBackRest 2.02 continues advancing in performance and configurability by introducing parallel asynchronous archive-get and a configuration include directory that allows configuration to be split into smaller fragments for easier management.

pgBackRest supports a robust set of features for managing your backup and recovery infrastructure, including: parallel backup/restore, full/differential/incremental backups, delta restore, parallel asynchronous archiving, per-file checksums, page checksums (when enabled) validated during backup, compression, encryption, partial/failed backup resume, backup from standby, tablespace and link support, S3 support, backup expiration, local/remote operation via SSH, flexible configuration, and more.

You can install pgBackRest from the PostgreSQL Yum Repository or the PostgreSQL APT Repository. Source code can be downloaded from Releases.

Links New Features Parallel Asynchronous Archive Get

The asynchronous archive-get command maintains a local queue of WAL to improve replay throughput. If a WAL segment is not found in the queue it is fetched from the repository along with enough consecutive WAL to fill the queue. Additional WAL is also fetched asynchronously when the queue is less than half full. Enabling parallelism increases throughput even more, especially for higher-latency connections and storage (such as S3).

Documentation

Configuration Includes

Configuration fragments can be dropped in the configuration includes directory (defaults to /etc/pgbackrest/conf.d) and they will be loaded along with the main configuration file, if it exists. For example, each stanza can be in a separate configuration fragment and general host settings in the main configuration file. This feature makes it easier to automate pgBackRest configuration with your favorite configuration management tool.

Documentation

Kategóriák: Informatika

Announcing The Release of repmgr 4.0.5

2018, május 3 - 02:00

Oxford, United Kingdom - May 3, 2018

2ndQuadrant today announced the release of repmgr 4.0.5. repmgr is the most popular tool for PostgreSQL replication and failover management. It enhances and complements the built-in replication capabilities in PostgreSQL, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations. The repmgrd daemon provides automatic failover capability to maximize database uptime, and can easily be integrated with other tools such as PgBouncer for high application availability.

This release is the first to provide packages via 2ndQuadrant’s new public RPM and APT repositories; for more details view the installation packages document here.

repmgr 4.0.5 includes usability enhancements related to pg_rewind usage, recovery.conf generation, and, in repmgrd, handling of various corner-case situations. These enhancements are:

  • Poll demoted primary after restart as a standby during a switchover operation
  • Add configuration parameter config_directory.
  • Add sanity check if --upstream-node-id not supplied when executing repmgr standby register.
  • Enable pg_rewind to be used with PostgreSQL 9.3/9.4
  • When generating replication connection strings, set dbname=replication if appropriate.
  • Enable provision of archive_cleanup_command in recovery.conf.
  • Check actively for node to rejoin cluster.
  • Set connect_timeout=2 in repmgrd if not explicitly set, when pinging a server.
  • Various documentation improvements, with particular emphasis on the importance of setting appropriate service commands instead of relying on pg_ctl.

This release contains the following bug fixes:

  • Fix display of conninfo parsing error messages.
  • Fix minimum accepted value for degraded_monitoring_timeout.
  • Fix superuser password handling.
  • Fix parsing of archive_ready_critical configuration file parameter.
  • Fix repmgr_cluster_crosscheck output.
  • Fix memory leaks in witness code.
  • Handle pg_ctl promote timeout in repmgrd.
  • Handle failover situation in repmgrd with only two nodes in the primary location, and at least one node in another location .
  • Prevent standby connection handle from going stale in repmgrd.

For a detailed list of all changes, please read the full release notes here.

We highly recommend upgrading to repmgr 4.0.5 at the earliest opportunity available. For this release, a simple package upgrade from repmgr 4.0 - 4.0.4 is required; repmgrd (if running) should be restarted.

Source files can be downloaded here and installation instructions are available here.

repmgr is developed and maintained by 2ndQuadrant - your diligent team of PostgreSQL experts.

repmgr is distributed under GPL v3.

For more information, please send an email to info@2ndQuadrant.com

Kategóriák: Informatika

Announcing the release of AgensGraph 1.3

2018, április 25 - 02:00

The AgensGraph Development Team are pleased to announce the release of AgensGraph v1.3.

AgensGraph is a new generation multi-model graph database based on PostgreSQL for highly connected data.
AgensGraph offers the graph analysis environment in which users can write, edit, and execute
SQL and Cypher query together at the same time. AgensGraph comes along with PostgreSQL compatibility
and PostgreSQL Extensions. With AgensGraph, a PostgreSQL for graph database, PostgreSQL users are free
from the pain of data migration and easily develop services which provide advanced data analysis.

This release of AgensGraph v1.3 includes the bug fixes and of course, many improvements.
For more details please see the release notes.

Major Improvements and Bug Fixes:
  • Improvements
  • Enhanced Query Plan Performance
  • Supports for More Cypher Expressions
  • Enhanced Supports for External Module
  • Improved Usability
  • Optimized Memory Usage (v1.3.1)
  • Bug Fixes
  • Fixed Bugs Related to Using Multiple Cypher Keywords
  • Fixed Memory Leak in Loading Data
  • Fixed Bugs Related to Vertex Reference
The new version is immediately available for download.
Kategóriák: Informatika

Pgpool-II 3.7.3, 3.6.10, 3.5.14, 3.4.17 and 3.3.21 are now officially released.

2018, április 17 - 02:00
What is Pgpool-II?

Pgpool-II is a tool to add useful features to PostgreSQL, including:

  • connection pooling
  • load balancing
  • automatic fail over and more.
Minor releases

Pgpool Global Development Group is pleased to announce the availability of following versions of Pgpool-II:

  • 3.7.3
  • 3.6.10
  • 3.5.14
  • 3.4.17
  • 3.3.21

These are the latest stable minor versions of each major versions of Pgpool-II. Release notes for versions prior 3.6 are no longer included in the source code.

Please take a look at release notes.

You can download the source code and RPMs.

Kategóriák: Informatika

pgAdmin 4 v3.0 released!

2018, április 13 - 02:00

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.0. This release of pgAdmin 4 includes over 100 bug fixes and new features. For more details please see the release notes.

pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see the website.

Notable changes in this release include:

  • The desktop runtime now runs as a system tray application and utilises the browser on the system to display pgAdmin. This resolves numerous bugs and issues caused by QtWebKit/QtWebEngine.
  • Data can now be sorted in edit mode in the Query Tool.
  • Keyboard navigation with configurable shortcuts for many operations has been added to allow use of pgAdmin without a mouse.
  • Dashboard tables and charts can be enabled/disabled.
  • Server and database statistics, functions, partitions, external tables and EXPLAIN are now supported on Greenplum.
  • Support for pg_service.conf files has been added.
  • The Docker Container distribution is vastly slimmed down, having move to Alpine Linux with Gunicorn to host the pgAdmin web application.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container and source code tarball from the download area.

RPM and DEB packages are expected to be available on the postgresql.org repositories within the next few days.

Kategóriák: Informatika

Announcing the release of Citus 7.3

2018, április 5 - 02:00

The Citus 7.3 extension to Postgres now includes broader SQL coverage, support for TopN extension, and integration with Tableau. Developers building real-time analytics dashboards and multi-tenant applications will benefit the most.

You can find more information in the Citus 7.3 release notes.

Citus 7.3 is compatible with PostgreSQL 9.6 and 10. You can try Citus 7.3 by following the download instructions or one-click deploy through the Citus Cloud console.

Kategóriák: Informatika

Database .NET v24.5 released

2018, március 31 - 02:00

Database .NET v24.5 is an innovative, powerful and intuitive multiple database management tool. (Full support for PostgreSQL 8/9/10)

Free, All-In-One, Portable, Single executable file and Multi-language.

Major New features from version 23.2 to 24.5:

  • Startup, closing data import and export performance improvements
  • Added support for macaddr8 in PostgreSQL 10
  • Added Description for connections
  • Added DateTime default value Selector
  • Added Displaying a progress indicator in a taskbar button
  • Added Duplicating Tables
  • Added Generating UPDATE and DELETE statements from results
  • Added Generating the command-line to Clipboard
  • Added Restoring recently closed tabs
  • Added Copying Script to Clipboard
  • Improved Query Builder
  • Improved Query Reverse Engineering
  • Improved Database Diagram
  • Improved Visual Execution Plan
  • Improved Table Designer
  • Improved Data Editor
  • Improved SQL Editor
  • Improved AutoComplete and IntelliSense
  • Improved Data Import and Export
  • Improved Connection List
  • Improved Command-Line
  • ...and more
The new version is immediately available for download.
Kategóriák: Informatika

pgBackRest 2.01 Released

2018, március 28 - 02:00

March 28, 2018: Crunchy Data announces the release of pgBackRest 2.01, the latest version of the simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.

pgBackRest 2 brings significant improvements to performance. The pgbackrest executable and asynchronous archive-push command are now written in C, which significantly reduces the time required for PostgreSQL to acknowledge WAL segments pushed by the asynchronous process.

pgBackRest supports a robust set of features for managing your backup and recovery infrastructure, including: parallel backup/restore, full/differential/incremental backups, delta restore, parallel asynchronous archiving, per-file checksums, page checksums (when enabled) validated during backup, compression, partial/failed backup resume, backup from standby, tablespace and link support, backup expiration, local/remote operation via SSH, and more.

You can download pgBackRest from the PostgreSQL Yum Repository, the PostgreSQL APT Repository, or from the official pgBackRest website: https://pgbackrest.org.

Links New Features pgbackrest executable is now written in C

pgBackRest commands can now be written in C or embedded Perl. This allows performance-sensitive commands (like asynchronous archive-push) to be implemented in C with significant performance benefits. Most commands are still written in Perl but are loaded only when required to reduce startup time.

Performance Improvements for “archive-push”

The archive-push command is now partially coded in C and allows the PostgreSQL archive_command to run significantly faster when processing status messages from the asynchronous archive process. Testing has shown that the startup time for asynchronous archive-push is up to 40 times faster, enabling more WAL logs to be archived per day.

S3 Performance Improvements

Performance improvements have been made to the S3 list and delete commands.

Kategóriák: Informatika

Announcing the release of TopN PostgreSQL extension

2018, március 27 - 02:00

Citus Data, is excited to announce the release of TopN, an open source PostgreSQL extension that returns the top values in a database according to some criteria. The TopN extension enables you to serve instant and approximate results to TopN queries. With the help of a very efficient approximation algorithm, TopN is able to materialize top values according to some criteria and incrementally update these top values, or merge them on-demand across different time intervals.

With TopN, you can:

  • Materialize your TopN results and update them incrementally.
  • Calculate TopN results approximately and very quickly.
  • Benefit the rich feature set of JSONB for your TopN datasets.

TopN is developed and maintained by Citus Data.

You can reach further information here and open source repository here. Please, do not hesitate to contact us via citusdata.com for further inquiries.

Kategóriák: Informatika

Introducing brand-new dbForge Studio for PostgreSQL, a powerful IDE for working with PostgreSQL databases

2018, március 22 - 01:00

Devart announced the first release of dbForge Studio for PostgreSQL that allows to manage and develop database objects in PostgreSQL. This new IDE offers many robust features like Code Completion, Object Explorer and Data Editor which help users create, develop and execute queries as well as edit and adjust the code to their requirements in a convenient and user-friendly interface.

In the first version, dbForge Studio for PostgreSQL offers the following key features:

1) Code Completion enables users to save their time and enhance the code quality while writing SQL queries with the help of numerous helpful functionalities like:

• List Members • Parameter Info • Quick Info • Complete Word

2) Object Explorer with expandable objects allows users to navigate through the object tree, find any PostgreSQL objects of interest and perform the following tasks:

• Retrieve data from a table to present on a single SQL document • Truncate a table • Select Properties to view specific information on objects

3) Data Editor simplifies the process of editing PostgreSQL table data offering many handy capabilities:

• Editing data similar to Google Sheets and MS Excel or in the card view mode • Managing the settings of tables, such as adjusting column width • Setting either paginal or auto-search mode by default • Changing colors and formats of rows and cells using a rich set of fonts and sizes • Providing predefined data type formats so that users can select the most suitable for their needs

For more information about dbForge Studio for PostgreSQL, please visit https://www.devart.com/dbforge/postgresql/studio/

About Devart

Devart, a Czech software vendor, is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.

Learn more about Devart at https://www.devart.com.

Kategóriák: Informatika

Announcing the Release of pglogical 2.2

2018, március 20 - 01:00

Oxford, United Kingdom - March 20, 2018

2ndQuadrant is proud to announce the release of pglogical 2.2, the next generation in logical replication for PostgreSQL. Implemented entirely as a PostgreSQL extension, pglogical is a logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication.

This release presents important enhancements and bug fixes including:

  • Fixed a race condition that could cause table synchronization to fail.
  • pglogical.alter_ subscription_synchronize() now removes synchronization info about orphaned tables.
  • Recreate replication slot on retry after table synchronization failure, which should improve table synchronization recovery after intermittent errors.
  • Report process identification based on log_line _prefix settings, making it easier to obtain pglogical messages from the server logs.
  • pglogical_create _subscriber no longer generates errors when run multiple times on the same provider.
  • Handle epoll_ctl failures cleanly to avoid internal error messages.
  • Improved memory management.

pglogical is supported by 2ndQuadrant, your diligent team of PostgreSQL experts.

Download and installation instructions are available here.

For more information, please send an email to info@2ndQuadrant.com

Kategóriák: Informatika

Announcing general availability of Azure Database for PostgreSQL

2018, március 20 - 01:00

Azure Database for PostgreSQL is now Generally Available. Use the database engine you're familiar with, together with languages and frameworks of your choice - now as a secure managed service in the cloud.

Read more here and create an instance today.

Kategóriák: Informatika

JDBC 42.2.2 Released

2018, március 16 - 01:00

The JDBC project is proud to announce the latest version 42.2.2. This release primarily fixes existing bugs including as well as updates documentation, including:

  • Documentation for server-side prepared statements
  • Support for generated keys for WITH queries missing RETURNING
  • Support for generated keys when INSERT/UPDATE/DELETE is followed by a comment
  • Fix incorrect results when a single-statement is used with different bind types
  • allowEncodingChanges should allow "SET client_encoding = ..."

and more.

For more details, please visit the changelog at https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.2

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

Kategóriák: Informatika

Announcing the Release of BDR 1.0.5

2018, március 16 - 01:00

2ndQuadrant today announced the release of BDR 1.0.5. BDR is the first open source multi-master replication system for PostgreSQL to reach full production status. This release includes the updated PostgreSQL server version to support the Postgres-BDR 9.4.17 extension, containing all of the fixes from the PostgreSQL 9.4.17 release.

The fixes and improvements included in this release are:

  • Work around a core postgres reorderbuffer corruption bug with a change in the BDR output plugin.
  • Ignore column-count mismatches if the mismatched columns are all nullable or dropped. This makes recovery from some kinds of operator errors simpler, and with sufficient care can be used to bypass DDL locking for adding new nullable columns to tables.
  • Fix possible deadlock in the apply worker in the find_pkey_tuple() function
  • Stricter memory context handling and leak prevention during apply. In particular be careful not to fall back to TopMemoryContext. This may help some possible memory leak issues.
  • Reset the apply worker memory context on every commit, not just when all messages have been consumed. May help with some possible memory leak issues.
  • Skip BDR 1.0.4 and bump the version straight to 1.0.5 to match BDR2.

Download and installation instructions are available here.

2ndQuadrant (Developers of Postgres-BDR) provides support as well as consultation and training for Postgres-BDR. With deep knowledge of distributed databases in PostgreSQL, 2ndQuadrant will evaluate individual use cases and determine the most suitable product or solution.

Postgres-BDR is also available and supported by 2ndQuadrant in the Cloud.

For more information, please send an email to info@2ndQuadrant.com

Kategóriák: Informatika

PostgreSQL 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 released!

2018, március 1 - 01:00
2018-03-01 Security Update Release

The PostgreSQL Global Development Group has released an update to all supported versions of the PostgreSQL database system, including 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22.

The purpose of this release is to address CVE-2018-1058, which describes how a user can create like-named objects in different schemas that can change the behavior of other users' queries and cause unexpected or malicious behavior, also known as a "trojan-horse" attack. Most of this release centers around added documentation that describes the issue and how to take steps to mitigate the impact on PostgreSQL databases.

We strongly encourage all of our users to please visit A Guide to CVE-2018-1058: Protect Your Search Path for a detailed explanation of CVE-2018-1058 and how to protect your PostgreSQL installations.

After evaluating the documentation for CVE-2018-1058, a database administrator may need to take follow up steps on their PostgreSQL installations to ensure they are protected from exploitation.

Security Issues

One security vulnerability is addressed in this release:

  • CVE-2018-1058: Uncontrolled search path element in pg_dump and other client applications

Please visit A Guide to CVE-2018-1058: Protect Your Search Path for a full explanation of the CVE-2018-1058.

Bug Fixes and Improvements

This update fixes several bugs reported since the last cumulative update. Some of these issues affect only version 10, but many affect all supported versions. These fixes include:

  • Prevent logical replication from trying to replicate changes for unpublishable relations, such as materialized views and the "information_schema" tables
  • Fix for a common table expression (WITH clause) returning correct results when being referenced in a subplan where there are concurrent-update rechecks
  • Fix for an unexpected query planner error in certain cases where there are overlapping merge join clauses in an OUTER JOIN.
  • Fix for potential data corruption with materialized views after running pg_upgrade. If receiving errors such as "could not access status of transaction" or "found xmin from before relfrozenxid" on materialized views, please use "REFRESH MATERIALIZED VIEW" without "CONCURRENTLY" to fix.
  • Several fix for pg_dump, including a fix to help with the future work of cross-table statistics
  • Fix for reporting a PL/Python stack trace relative to inner PL/Python functions
  • Allow contrib/auto_explain to range up to INT_MAX, which is about 24 days
  • Mark assorted configuration variables as PGDLLIMPORT, to ease porting extension modules to Windows
Acknowledgements

The PostgreSQL Global Development Group would like to thank Arseniy Sharoglazov for reporting CVE-2018-1058 to the security team.

Links
Kategóriák: Informatika

dbMigration .NET v7.6 released

2018, február 18 - 01:00

dbMigration .NET v7.6 is a simple, easy and intuitive multiple database migration and sync tool, With it you can easily migrate schema and data to PostgreSQL and vice versa without complicated procedures.

Free, All-In-One, Portable, Single executable file and Multi-language.

Major New features and improvements from version 6.6 to 7.6:

  • Startup, Data migration and Data synchronization performance improvements
  • Added Connection List
  • Added changing global table and column case
  • Added Sync settings: Skip New, Updated and Deleted Rows
  • Added Bulk Copy Mode for SQL Server/SQL Azure/IBM DB2/Informix and NuoDB
  • Improved Automatically generate foreign keys
  • Improved Migrating data with a SQL statement
  • Improved Data Synchronization
  • Improved Automatic Mapping Types
  • Improved Custom Mapping Types
  • Improved Command-Line
  • ...and more
The new version is immediately available for download.
Kategóriák: Informatika

Announcing The Release Of repmgr 4.0.3

2018, február 15 - 01:00

Oxford, United Kingdom - February 15, 2018

2ndQuadrant announces the release of repmgr 4.0.3. repmgr is the most popular tool for PostgreSQL replication and failover management. It enhances and complements PostgreSQL's built-in replication capabilities, making it easy to set up and manage standby servers, check replication status, and perform administrative tasks such as switchover operations. The repmgrd daemon provides automatic failover capability to maximize database uptime and can easily be integrated with other tools such as PgBouncer for high application availability.

repmgr 4.0.3 includes the following usability enhancements related to logging/diagnostics, event notifications, and pre-action checks:

  • Improve repmgr standby switchover behavior when pg_ctl is used to control the server and logging output is not explicitly redirected.
  • Improve repmgr standby switchover log messages and provide new exit code ERR_SWITCHOVER_INCOMPLETE when old primary could not be shut down cleanly.
  • Add check to verify the demotion candidate can make a replication connection to the promotion candidate before executing a switchover.
  • Add check for sufficient walsenders and replication slots on the promotion candidate before executing repmgr standby switchover.
  • Add --dry-run mode to repmgr standby follow.
  • Provide information about the primary node for repmgr standby register and repmgr standby follow event notifications.
  • Add standby_register_sync event notification, which is fired when repmgr standby register is run with the --wait-sync option and the new or updated standby node record has synchronized to the standby.
  • When running repmgr cluster show, if any node is unreachable, output the error message encountered in the list of warnings

This release contains the following bug fixes:

  • Ensure an inactive data directory can be overwritten when cloning a standby.
  • repmgr node status upstream node display fixed.
  • repmgr primary unregister clarify usage and fix --help output.
  • Parsing of pg_basebackup_options fixed.
  • Ensure the pg_subtrans directory is created when cloning a standby in Barman mode
  • repmgr witness register fix primary node check.

For a detailed list of all fixed bugs, please read the full release notes here.

We highly recommend upgrading to repmgr 4.0.3 at the earliest opportunity available. For this release, a simple package upgrade and restart of repmgrd (if running) is required.

Download is available here and installation instructions are available here.

repmgr is developed and maintained by 2ndQuadrant - your diligent team of PostgreSQL experts.

repmgr is distributed under GPL v3.

For more information, please send an email to info@2ndQuadrant.com

Kategóriák: Informatika

Oldalak

Theme by me