Jelenlegi hely

PostreSQL.org

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

Announcing the Release of repmgr v4.0 Beta

2017, október 11 - 02:00

Oxford, United Kingdom - October 11, 2017

2ndQuadrant is proud to announce the release of repmgr 4 (Beta). repmgr has been the most popular tool for PostgreSQL failover since 2010. v4 updates repmgr to support the recently released PostgreSQL 10.

This new release contains a number of changes related to WAL functionality and minor bug fixes. Additionally, there is a new log line type: DETAIL. Meaning that additional context for log messages is now provided in a separate DETAIL log line (similar to PostgreSQL). This release includes other important enhancements, some of which are listed below:

  • Improved switchover functionality
  • Redesigned failover mechanism
  • Faster performance
  • Improved checking of prerequisites
  • Easier upgrading
  • Suitable for setting up replication clusters in provisioning environments

Read the full release notes for repmgr 4.0 here

repmgr is an open source package that helps DBAs and System Administrators manage a cluster of PostgreSQL databases. repmgr greatly simplifies the process of setting up and managing databases with high availability and scalability requirements.

repmgr is developed and maintained by 2ndQuadrant. It is fully supported by their respected 24/7 Production Support, providing the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide. repmgr is distributed under GPL v3.

Repmgr 4 download and installation instructions are available here

About 2ndQuadrant

2ndQuadrant is the Gold Standard for PostgreSQL Products & Services and consistently contributes enterprise features to enhance performance, scalability, security, and stability in PostgreSQL. Spanning 22 countries and 5 continents, 2ndQuadrant is the largest single collective organization of PostgreSQL experts. We have adopted the open source business model and are Platinum sponsors for the PostgreSQL project. Our focus on service quality is reflected in the consistent best-in-class NPS of over 75 for more than 2 years.

Kategóriák: Informatika

PGConf APAC 2018 CFP is Open

2017, október 10 - 02:00

Following the success of two consecutive pan-Asia Postgres event - pgDay Asia 2016 and pgDay Asia 2017 held along with FOSSASIA, we are pleased to announce PGConf APAC 2018 to be held in Singapore from 22nd to 24th of March, 2018. Once again the conference will be held along with FOSSASIA - one of the largest FOSS conference on the planet. PGConf APAC will be PostgreSQL conference series for all PostgreSQL enthusiasts and users in the Asia Pacific region.

For more details on FOSSASIA - http://2018.fossasia.org

You will be able to enjoy one of the largest PostgreSQL conference in Asia and one of the largest FOSS conferences to meet like minded individuals in the same week!

pgDay Asia 2016 and pgDay Asia 2017 would not have been possible without your awesome talks and we would like to invite speakers from all over the globe to present at the PGConf APAC 2018. We would like to open Call For Paper for PGConf APAC 2018. Some of the topics which can be used for submitting a talk are-

  1. Migration projects
  2. Performance troubleshooting and tuning
  3. noSQL and geo-spatial features of Postgres
  4. Unique use-case and customer stories
  5. Useful new features in PostgreSQL 10

For more examples you can refer to the papers which were presented at last year's event - 2016 and 2017.

Of course we are happy to accept paper proposals on any other interesting topics as well.

To submit you proposal for presentation please go to this link - http://2018.pgconfapac.org/cfp

Venue

To be Announced

Call for Papers

2017-10-10: Proposals acceptance begins

2017-12-04: Proposals acceptance ends

2017-12-13: Authors of accepted proposals contacted

If you need any additional information please contact our team at pgconfapac(at)googlegroups(dot)com.

This conference is organized by the PostgreSQL people from Asian communities. If you have any question, feel free to contact us on pgconfapac(at)googlegroups(dot)com.

Kategóriák: Informatika

PostgresOpen SV 2017 - Wrap Up

2017, október 10 - 02:00

PostgresOpen SV 2017 was a smashing success! Thank you so much to all of our fantastic attendees, our great speakers and our sponsors for helping make it happen.

All of the videos for all of the general session talks and the keynotes are now available online here:

https://www.youtube.com/PostgresOpen

The slides for most of the talks have been posted to the Wiki, thanks to our wonderful speakers:

https://wiki.postgresql.org/wiki/Postgres_Open_2017

We'll be back in San Francisco again in 2018!

https://2018.postgresopen.org

If you didn't have a chance to check it out already, we encourage you to visit our blog, with posts from our Diamond and Platinum sponsors:

https://2017.postgresopen.org/blog/

Special thanks to our sponsors! We wouldn't be able to put on these awesome events without their help and support. Be on the lookout for our 2018 Call For Sponsors which will be happening soon!

For 2017 we were pleased to be able to recognize our three Diamond sponsors:

2ndQuadrant

CitusData

Microsoft

And our Platinum sponsor:

Heroku

Be sure to check out our site to see all of our Gold, Silver and Supporter sponsors for 2017, and our Community Partners here:

https://2017.postgresopen.org/sponsors/

PostgresOpen wouldn't be able to happen without the tireless efforts of the individuals at the United States PostgreSQL Association (PgUS), please consider joining us to help run events in your area and to work to grow PostgreSQL!

https://postgresql.us

PgUS is the non-profit organization which backs PostgresOpen and other events and we are always looking for help.

We look forward to seeing everyone in San Francisco again next year!

Any questions? Please contact: program2017@postgresopen.org.

Stephen Frost & Craig Kerstiens PostgresOpen SV 2017 Committee Co-Chairs https://2017.postgresopen.org

Kategóriák: Informatika

Announcing the Release of pglogical 2.1

2017, október 9 - 02:00

Oxford, United Kingdom - October 9, 2017

2ndQuadrant is proud to announce the release of pglogical 2.1, the next generation in logical replication, for PostgreSQL 10 - the latest major release of of the world's most advanced open source database. Implemented entirely as a PostgreSQL 10 extension, pglogical is a logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication.

This new release presents important enhancements and bug fixes including:

  • Fixed dropping of extensions when pglogical is in shared_preload_libraries but not used in the current database
  • Improved compatibility with pglogical 1.x provider
  • Fixed computation of CURRENT_TIMESTAMP on subscriber
  • Improved error reporting
  • Improved replication origins handling

pglogical is fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.

pglogical is supported by 2ndQuadrant. 2ndQuadrant’s respected 24/7 Production Support provides the fastest and highest rated response service for PostgreSQL anywhere and is available worldwide.

Download and installation instructions are available here.

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

Kategóriák: Informatika

Database .NET v23 released

2017, október 6 - 02:00

Database .NET v23 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 22.1 to 23.1:

  • PostgreSQL 10 support
  • Added Finding and Replacing Multiple Documents
  • Added DateTime Picker with TimeZone
  • Added Quick Filter objects
  • Added Search Object DDL (Pro)
  • Added Highlighting Groups of Cells
  • Added Using \r\n as record separator by Exporting and Importing delimited text files
  • Added Multi line search
  • Added Search result highlighting
  • Added JSON Editor and Viewer
  • ...and more
For more information please visit http://fishcodelib.com/Database.htm.
Kategóriák: Informatika

dbMigration .NET v6.5 released

2017, október 6 - 02:00

dbMigration .NET v6.5 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 5.1 to 6.5:

  • Massive performance improvements (>30%+)
  • Better support for windows display scaling
  • Added Migrating data with a SQL statement
  • Added support for Asynchronous connection open
  • Added automatically reset sequences after migrating the table
  • Improved Graphical User Interface
  • Improved Data Synchronization
  • Improved Automatic Mapping Types
  • Improved Custom Mapping Types (UDT and length)
  • Improved Command-Line parsing
  • ...and more
The new version is immediately available for download.
Kategóriák: Informatika

pgAdmin 4 v2.0 Released

2017, október 5 - 02:00

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 2.0, the most popular graphical administration and management tool for the PostgreSQL database.

This release of pgAdmin 4 includes over 70 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

  • PostgreSQL and EDB Advanced Server 10 support, including table partitioning
  • An updated icon set and embedded fonts for consistent look and feel on all platforms
  • Significant speed enhancements, particularly at startup time
  • Out-of-the-box ability to run in either server or desktop mode with no additional configuration changes required
  • Support for SSL certificate based authentication
  • Detailed display of server status info on the dashboards, with options to cancel queries and terminate sessions

For more information, please see the website

Download your copy here

Kategóriák: Informatika

PostgreSQL 10 Released

2017, október 5 - 02:00

The PostgreSQL Global Development Group today announced the release of PostgreSQL 10, the latest version of the world's most advanced open source database.

A critical feature of modern workloads is the ability to distribute data across many nodes for faster access, management, and analysis, which is also known as a "divide and conquer" strategy. The PostgreSQL 10 release includes significant enhancements to effectively implement the divide and conquer strategy, including native logical replication, declarative table partitioning, and improved query parallelism.

"Our developer community focused on building features that would take advantage of modern infrastructure setups for distributing workloads," said Magnus Hagander, a core team member of the PostgreSQL Global Development Group. "Features such as logical replication and improved query parallelism represent years of work and demonstrate the continued dedication of the community to ensuring Postgres leadership as technology demands evolve."

This release also marks the change of the versioning scheme for PostgreSQL to a "x.y" format. This means the next minor release of PostgreSQL will be 10.1 and the next major release will be 11.

Logical Replication - A publish/subscribe framework for distributing data

Logical replication extends the current replication features of PostgreSQL with the ability to send modifications on a per-database and per-table level to different PostgreSQL databases. Users can now fine-tune the data replicated to various database clusters and will have the ability to perform zero-downtime upgrades to future major PostgreSQL versions.

"We have been heavily using PostgreSQL since 9.3 and are very excited about version 10 since it brings basis for long-awaited partitioning and built-in logical replication. It will allow us to use PostgreSQL in even more services," said Vladimir Borodin, DBA Team Lead at Yandex.

Declarative Table Partitioning - Convenience in dividing your data

Table partitioning has existed for years in PostgreSQL but required a user to maintain a nontrivial set of rules and triggers for the partitioning to work. PostgreSQL 10 introduces a table partitioning syntax that lets users easily create and maintain range and list partitioned tables. The addition of the partitioning syntax is the first step in a series of planned features to provide a robust partitioning framework within PostgreSQL.

Improved Query Parallelism - Quickly conquer your analysis

PostgreSQL 10 provides better support for parallelized queries by allowing more parts of the query execution process to be parallelized. Improvements include additional types of data scans that are parallelized as well as optimizations when the data is recombined, such as pre-sorting. These enhancements allow results to be returned more quickly.

Quorum Commit for Synchronous Replication - Distribute data with confidence

PostgreSQL 10 introduces quorum commit for synchronous replication, which allows for flexibility in how a primary database receives acknowledgement that changes were successfully written to remote replicas. An administrator can now specify that if any number of replicas has acknowledged that a change to the database has been made, then the data can be considered safely written.

"Quorum commit for synchronous replication in PostgreSQL 10 gives more options to extend our ability to promote database infrastructure with nearly zero downtime from the application perspective. This allows us to continuously deploy and update our database infrastructure without incurring long maintenance windows," said Curt Micol, Staff Infrastructure Engineer at Simple Finance.

SCRAM-SHA-256 authentication - Secure your data access

The Salted Challenge Response Authentication Mechanism (SCRAM) defined in RFC5802 defines a protocol to improve upon the secure storage and transmission of passwords by providing a framework for strong password negotiation. PostgreSQL 10 introduces the SCRAM-SHA-256 authentication method, defined in RFC7677, to provide better security than the existing MD5-based password authentication method.

Links About PostgreSQL

PostgreSQL is the world's most advanced open source database, with a global community of thousands of users, contributors, companies and organizations. The PostgreSQL Project builds on over 30 years of engineering, starting at the University of California, Berkeley, and has continued with an unmatched pace of development. 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 at PostgreSQL.org.

Kategóriák: Informatika

hypopg 1.1.0 released

2017, október 5 - 02:00

Version 1.1.0 of hypopg has just been released.

hypopg is a PostgreSQL extension adding support for hypothetical indexes.

An hypothetical, or virtual, index is an index that doesn't really exist, and thus doesn't cost CPU, disk, or any resource to create. They're useful to know if specific indexes might increase performance for problematic queries, since you could know if PostgreSQL will use these indexes or not without having to spend resources to create them.

This release adds support for hypothetical indexes on expression, an hypopg_get_indexdef() function to get the SQL command that will create the real index corresponding to a stored hypothetical index, PostgreSQL 10 compatiiblity, and bug fixes.

Please see the changelog for more details.

Many thanks to Andrew Kane and Rob Stolarz for reporting issues.

Source repository: github.com/dalibo/hypopg

Kategóriák: Informatika

Support for PostgreSQL 9.6.5 in dbForge Data Compare for PostgreSQL

2017, szeptember 28 - 02:00

Devart has released a new version of dbForge Data Compare for PostgreSQL – a powerful and easy to use tool for table data comparison and synchronization.

Devart, a Czech software provider of database connectivity solutions and tools for database management and development, announced the release of dbForge Data Compare for PostgreSQL that comes with support for PostgreSQL 9.6.5, and extended compatibility of data types.

dbForge Data Compare for PostgreSQL has the following new features and improvements:

*PostgreSQL 9.6.5 is supported

*Azure for PostgreSQL is supported

*Types compatibility matrix is extended

*Advanced support for Range, PostGIS and Domain data types

*Advanced support for Interval data type

*Advanced support for JSON and JSONB data types

*Command-Line Master which greatly simplifies the creation of command line execution files

dbForge Data Compare for PostgreSQL is a PostgreSQL data diff and sync tool that allows users to review all the differences in tables being compared and execute an automatically generated script to remove these differences.

For more information about dbForge Data Compare for PostgreSQL, please visit https://www.devart.com/dbforge/postgresql/datacompare/

About Devart

Devart 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

PostgreSQL 10 RC1 Released

2017, szeptember 21 - 02:00

The PostgreSQL Global Development Group announces today that the first release candidate of version 10 is available for download. As a release candidate, 10 RC 1 should be identical to the final release of the new version. It contains fixes for issues found during testing, some which are detailed below. We encourage you to test and to report any issues that you may find.

Upgrading to RC 1

PostgreSQL 10 RC 1 requires an upgrade from beta 4, or earlier either using pg_dump / pg_restore or pg_upgrade.

Any bug fixes applied to 9.6 or earlier that also affected 10 are included in RC 1, as well issues that were reported with Beta 4.

Changes Since Beta 4

PostgreSQL 10 RC 1 contains fixes for issues discovered by users when testing Beta 4, including:

  • Add psql variables showing server version and psql version.
  • Several fixes for partitioning
  • Several fixes for logical replication
  • Several fixes for transition tables
  • Fix for query that could end up in an uninterruptible state

Note that some known issues remain unfixed. Before reporting a bug in the release candidate, please check the Open Items page.

Release Schedule

This is the first release candidate for version 10. The PostgreSQL Project will create additional release candidates until all reported issues are resolved, then release 10.0 final. For further information please see the Beta Testing page.

Links
Kategóriák: Informatika

Realese PoWA v3.1.1

2017, szeptember 20 - 02:00

PoWA is a PostgreSQL extension that analyses charges (similar to AWR on Oracle). PoWA collects and stocks your bases’ data usage and enables to compare requests with used ressources.

Bugfix

Fix unsafe coding with sighup handler (Andreas Seltenreich, Julien Rouhaud) Make sure we wait at least powa.frequency between two snapshot (Marc Cousin and Julien Rouhaud) Fix win32 portability of compute_powa_frequeny() (Julien Rouhaud) Don't try to read dbentry->tables if it's NULL (Julien Rouhaud) Fix compilation for platform with HAVE_CLOCK_GETTIME (Julien Rouhaud, reported by Maxence Ahlouche)

Miscellaneous

Add pg10 Compatibility (Julien Rouhaud) Only execute once the powa_stat functions (Julien Rouhaud)

To report an issue, please use the bug tracking system in the github project page: https://github.com/dalibo/powa

Kategóriák: Informatika

Release - ldap2pg v3.0

2017, szeptember 15 - 02:00

Ldap2pg is a tool to synchronize roles and ACL in PostgreSQL from a LDAP compatible directory. The configuration is simple but powerful. Ldap2pg can also audit your PostgreSQL cluster. Ldap2pg eases integration and security of PostgreSQL in your infrastructure.

Here is a highlight of changes in this new version.

ldap2pg 3.0

Breakage: Use Python {} format string for ACL queries instead of named printf style. Support old setuptools. Fix undefined LDAP password traceback. Fix case sensitivity in grant rule. ACL inspect query should now return a new column indicating partial grant. Allow to customize query to inspect roles in cluster. Add check mode: exits with 1 if changes. Juste like diff. Add --quiet option. Add __all__ schema wildcard for looping all schema in databases. Add ACL group to ease managing complex ACL setup. Add Cookbook in documentation.

You'll find all the documentation and community support following these links:

Documentation: http://ldap2pg.readthedocs.io/en/latest/

GitHub project: https://github.com/dalibo/ldap2pg

Kategóriák: Informatika

PostgreSQL Automatic Failover (PAF) v2.2.0 released

2017, szeptember 12 - 02:00

PostgreSQL Automatic Failover (PAF) v2.2.0 has been released on September 12th 2017 under the PostgreSQL licence.

See: https://github.com/dalibo/PAF/releases/tag/v2.2.0

PAF is a PostgreSQL resource agent for Pacemaker. Its original aim is to keep it clear between the Pacemaker administration and the PostgreSQL one, to keep things simple, documented and yet powerful.

This release features:

  • the support of PostgreSQL 10
  • a new "maxlag" parameter to exclude lagging slaves from promotion
  • ability to deal with multiple PostgreSQL instances in the same cluster
  • comprehensive error messages directly in crm_mon!

Source code and releases are available on github:

Documentation, procedures, community support as well:

Please, use the pgsql-general@postgresql.org or users@clusterlabs.org mailing lists if you have questions.

Any feedback is welcomed.

Kategóriák: Informatika

PostgreSQL 9.6.5, 9.5.9, 9.4.14, 9.3.19 and 9.2.23 released!

2017, augusztus 31 - 02:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.5, 9.5.9, 9.4.14, 9.3.19, and 9.2.23.

This release includes fixes that prevent a crash in pg_restore when using parallel mode. It also patches over a few other bugs reported since the last releases in August.

Additionally, in 9.4.14 only, there is a fix to an issue with walsenders preventing primary-server shutdown unless immediate shutdown mode is used.

Users should plan to update at the next convenient downtime.

Bug Fixes and Improvements

This update also fixes a number of bugs reported in the last few weeks. Some of these issues affect only version 9.6, but many affect all supported versions:

  • Show foreign tables in information_schema.table_privileges view. This fix applies to new databases, see the release notes for the procedure to apply the fix to an existing database.
  • Correctly identify columns that are of a range type or domain type over a composite type or domain type being searched for
  • Prevent crash when passing fixed-length pass-by-reference data types to parallel worker processes
  • Change ecpg’s parser to allow RETURNING clauses without attached C variables
  • Change ecpg’s parser to recognize backslash continuation of C preprocessor command lines
  • Improve selection of compiler flags for PL/Perl on Windows
EOL Warning for Version 9.2

PostgreSQL version 9.2 will be End-of-Life in September, 2017. The project expects to only release one more update for that version. We urge users to start planning an upgrade to a later version of PostgreSQL as soon as possible. See our Versioning Policy for more information.

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 in order to apply this update release; you may simply shut down PostgreSQL and update its binaries.

Links
Kategóriák: Informatika

PostgreSQL 10 Beta 4 Released!

2017, augusztus 31 - 02:00

The PostgreSQL Global Development Group announces today that the fourth beta release of PostgreSQL 10 is available for download. This release contains previews of all of the features which will be available in the final release of version 10, including fixes to many of the issues found in the third beta. Users are encouraged to begin testing their applications against 10 beta4.

Upgrading to Beta4

PostgreSQL 10 beta 4 requires an upgrade from beta 3, or earlier either using pg_dump / pg_restore or pg_upgrade.

Any bugfixes applied to 9.6 or earlier that also affected 10 are included in beta 4. Our users and contributors also reported bugs against 10 beta 3, and many of them have been fixed in this release. We urge our community to re-test to ensure that these bugs are actually fixed, including:

  • Show foreign tables in information_schema.table_privileges view. This fix applies to new databases, see the release notes for the procedure to apply the fix to an existing database.
  • Clean up handling of a fatal exit (e.g., due to receipt of SIGTERM) that occurs while trying to execute a ROLLBACK of a failed transaction
  • Remove assertion that could trigger during a fatal exit
  • Correctly identify columns that are of a range type or domain type over a composite type or domain type being searched for
  • Prevent crash when passing fixed-length pass-by-reference data types to parallel worker processes
  • Fix crash in pg_restore when using parallel mode and using a list file to select a subset of items to restore
  • Change ecpg’s parser to allow RETURNING clauses without attached C variables
  • Change ecpg’s parser to recognize backslash continuation of C preprocessor command lines
  • Improve selection of compiler flags for PL/Perl on Windows
  • Fix make check to behave correctly when invoked via a non-GNU make program

Note that some known issues remain unfixed. Before reporting a bug in the beta, please check the Open Items page.

Beta Schedule

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

Links
Kategóriák: Informatika

Announcing the Release of OmniDB: Lightweight and Easy-to-Use Tool for Database Management

2017, augusztus 22 - 02:00
New browser-based tool is open source and designed especially for managing PostgreSQL databases

Oxford, United Kingdom - August 22, 2017

2ndQuadrant proudly announces the release of OmniDB, an interactive, browser-based tool that simplifies database management. It is designed to be a powerful, yet lightweight and user friendly interface for PostgresQL databases. OmniDB is fully backed by 2ndQuadrant’s world renowned 24/7 Production Support.

OmniDB includes a smart SQL editor that runs smoothly in any browser from any operating system. This revolutionary tool is powered by WebSocket technology, enabling the user to execute multiple queries in parallel. The interface includes all the necessary features to add, edit, and manage user data in a unified workspace.

OmniDB is capable of connecting and identifying main structures such as tables, keys, indexes and constraints. The interactive and customizable SQL editor features syntax highlighting and SQL code completion for tables and subqueries. The most impressive aspect of OmniDB is the highly performant response time averaging only 0.03 seconds.

“Performance has been a cause for frustration within the PostgreSQL community while working with GUI tools for database management. While developing OmniDB, one of our primary aims was to address this issue. We started off with a target of 0.1 seconds as the maximum time to complete a transaction. I am very proud to say that our benchmarks show an outstanding average response time of only 0.03 seconds.” - Umair Shahid, Head of Marketing & Products

In addition to the unparalleled response time, the key capabilities of OmniDB are:

  • Easy to manage. The structure of the user's database is shown as an interactive tree. Each node's context menu contains access to every available action. The user can easily switch between database connections by picking from a simple dropdown menu.
  • Create and edit tables easily. As a result of a powerful interface and extended editing capabilities, OmniDB allows the user to manage and edit existing tables and create new ones easily. It also allows the user to add & edit various table attributes such as columns, foreign keys, etc.
  • Data Management. It is possible to add, edit, and remove table records depending on the table’s characteristics.
Where to find OmniDB

Download and installation instructions are available here.

About 2ndQuadrant

2ndQuadrant was founded in 2001 by Simon Riggs, a major developer and committer of the PostgreSQL project. As the largest single collective organization of PostgreSQL experts of any company globally, it is 2ndQuadrant's mission to provide the gold standard of products and services to support PostgreSQL and its continuous growth. Comprised of some of the best known developers from around the globe, all members actively contribute to the development of PostgreSQL.

Kategóriák: Informatika

PostgreSQL Maestro 17.8 released. PostgreSQL 10 support and other new features.

2017, augusztus 21 - 02:00

SQL Maestro Group announces the release of PostgreSQL Maestro 17.8, a powerful Windows GUI solution for PostgreSQL database server administration and database development.

The new version is immediately available for download.

Top 10 new features:
  1. PostgreSQL 10 compatibility.
  2. Support for Native Table Partitioning (PostgreSQL 10).
  3. Support for Identity Columns (PostgreSQL 10).
  4. Support for Restrictive RLS Policies (PostgreSQL 10).
  5. Custom captions and colors for server nodes in Database Explorer.
  6. New Statistics tab in the Edit Database Profile dialog.
  7. Improved Data Grid.
  8. New SQL Editor options.
  9. Links to our Socials at the Quick Launch panel.
  10. Some performance and usability improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Kategóriák: Informatika

2017-08-10 Security Update Release

2017, augusztus 10 - 02:00

The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.4, 9.5.8, 9.4.13, 9.3.18, and 9.2.22. This release fixes three security issues. It also patches over 50 other bugs reported over the last three months. Users who are affected by the below security issues should update as soon as possible. Users affected by CVE-2017-7547 will need to perform additional steps after upgrading to resolve the issue. Other users should plan to update at the next convenient downtime.

Security Issues

Three security vulnerabilities have been closed by this release:

  • CVE-2017-7546: Empty password accepted in some authentication methods
  • CVE-2017-7547: The "pg_user_mappings" catalog view discloses passwords to users lacking server privileges
  • CVE-2017-7548: lo_put() function ignores ACLs
CVE-2017-7546: Empty password accepted in some authentication methods

libpq, and by extension any connection driver that utilizes libpq, ignores empty passwords and does not transmit them to the server. When using libpq or a libpq-based connection driver to perform password-based authentication methods, it would appear that setting an empty password would be the equivalent of disabling password login. However, using a non-libpq based connection driver could allow a client with an empty password to log in.

To fix this issue, this update disables empty passwords from being submitted in any of the password-based authentication methods. The server will reject any empty passwords from being set on accounts.

CVE-2017-7547: The "pg_user_mappings" catalog view discloses passwords to users lacking server privileges

This fix pertains to the usage of the foreign data wrapper functionality, particularly for the user mapping feature.

Before this fix, a user had access to see the options in pg_user_mappings even if the user did not have the USAGE permission on the associated foreign server. This meant that a user could see details such as a password that might have been set by the server administrator rather than the user.

This fix will only fix the behavior in newly created clusters utilizing initdb. To fix this issue on existing systems, you will need to follow the below steps. For more details, please see the release notes.

  1. In your postgresql.conf file, add the following:

    allow_system_table_mods = true
  2. After adding that line, you will need to restart your PostgreSQL cluster.

  3. In each database of the cluster, run the following commands as a superuser:

    SET search_path = pg_catalog; CREATE OR REPLACE VIEW pg_user_mappings AS SELECT U.oid AS umid, S.oid AS srvid, S.srvname AS srvname, U.umuser AS umuser, CASE WHEN U.umuser = 0 THEN 'public' ELSE A.rolname END AS usename, CASE WHEN (U.umuser <> 0 AND A.rolname = current_user AND (pg_has_role(S.srvowner, 'USAGE') OR has_server_privilege(S.oid, 'USAGE'))) OR (U.umuser = 0 AND pg_has_role(S.srvowner, 'USAGE')) OR (SELECT rolsuper FROM pg_authid WHERE rolname = current_user) THEN U.umoptions ELSE NULL END AS umoptions FROM pg_user_mapping U LEFT JOIN pg_authid A ON (A.oid = U.umuser) JOIN pg_foreign_server S ON (U.umserver = S.oid);
  4. You also need to run the command on your template0 and template1 databases, otherwise the vulnerability will exist in future databases that you create.

    First, you will need to allow template0 to accept connections. In PostgreSQL 9.5 you can run the following:

    ALTER DATABASE template0 WITH ALLOW_CONNECTIONS true;

    In PostgreSQL 9.4 and below, you will have to run this command:

    UPDATE pg_database SET datallowconn = true WHERE datname = 'template0';

    Then, in your template0 and template1 databases, run the commands as describe in Step 3

    When you are done, you will need to disallow connections from template0. In PostgreSQL 9.5, you can run the following:

    ALTER DATABASE template0 WITH ALLOW_CONNECTIONS false;

    In PostgreSQL 9.4 and below, you will have to run the following:

    UPDATE pg_database SET datallowconn = false WHERE datname = 'template0';
  5. Remove the following line from your postgresql.conf file:

    allow_system_table_mods = false
  6. Restart your PostgreSQL cluster

For more details, please see the release notes.

CVE-2017-7548: lo_put() function ignores ACLs

The lo_put() function should require the same permissions as lowrite(), but there was a missing permission check which would allow any user to change the data in a large object.

To fix this, the lo_put() function was changed to check the UPDATE privileges on the target object.

Bug Fixes and Improvements

This update also fixes a number of bugs reported in the last few months. Some of these issues affect only version 9.6, but many affect all supported versions:

  • pg_upgrade: corrected the documentation about the process for upgrading standby servers to ensure the primary and standbys synchronized safely. Also includes a fix to ensure the last WAL record does not have "wal_level = minimum" which would prevent standbys from connecting upon restart
  • Fix for issue with a concurrent locking race condition that could cause some of the updates to fail
  • Several fixes for low probability data corruption scenarios
  • Fix to prevent crash when sorting more than one billion tuples in-memory
  • Fix on Windows to retry creating a process if shared memory addresses could not be allocated, typically caused from antivirus software interference
  • Fix in libpq to ensure that failed connection attempts using GSS/SASL and SSPI authentication are reset properly
  • Fixes for SSL connection handling and logging
  • Fix to allow window functions to be used in sub-SELECT statements that are within the arguments of an aggregate function
  • Allow parallelism in the query plan when COPY when copying from a query
  • Several fixes to ALTER TABLE
  • Fix to ensure that ALTER USER ... SET and ALTER ROLE ... SET accepts the same syntax variants
  • Fixes for the statistics collector, ensuring statistics requests made just after a postmaster shutdown request will be written to disk
  • Fix possible creation of an invalid WAL segment during standby promotion
  • Several walsender / walreceiver fixes, particularly around signal handling and shutdowns / restarts
  • Several logic decoding fixes, including removing leakage of small subtransactions to disk
  • Allow a CHECK constraints to be initially NOT VALID when executing CREATE FOREIGN TABLE
  • Fixes to postgres_fdw for applying changes promptly after ALTER SERVER / ALTER USER MAPPING commands and improving ability to escape from an unresponsive server
  • Several fixes for pg_dump and pg_restore, including a fix for pg_dump output to stdout on Windows
  • Fix pg_basebackup output to stdout on Windows, similar to the fix for pg_dump
  • Fix pg_rewind to correctly handle files exceeding 2GB, though files of such size should rarely appear in a data directory
  • Several fixes for building PostgreSQL with Microsoft Visual C (MSVC), primarily around sourcing libraries
EOL Warning for Version 9.2

PostgreSQL version 9.2 will be End-of-Life in September, 2017. The project expects to only release one more update for that version. We urge users to start planning an upgrade to a later version of PostgreSQL as soon as possible. See our Versioning Policy for more information.

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 in order to apply this update release; you may simply shut down PostgreSQL and update its binaries.

Links:

Kategóriák: Informatika

PostgreSQL 10 Beta 3 Released!

2017, augusztus 10 - 02:00

The PostgreSQL Global Development Group announces today that the third beta release of PostgreSQL 10 is available for download. This release contains previews of all of the features which will be available in the final release of version 10, including fixes to many of the issues found in the second beta. Users are encouraged to begin testing their applications against 10 beta3.

Upgrading to Beta3

PostgreSQL 10 beta3 requires an upgrade from beta1, beta2, or earlier either using pg_dump / pg_restore or pg_upgrade.

Any bugfixes applied to 9.6 or earlier that also affected 10 are included in beta3. Our users and contributors also reported bugs against 10 beta 2, and many of them have been fixed in this release. We urge our community to re-test to ensure that these bugs are actually fixed, including:

  • hash: Fix write-ahead logging bugs related to init forks
  • Fix oddity in error handling of constraint violation in ExecConstraints for partitioned tables
  • Use a real RT index when setting up partition tuple routing
  • Fix serious performance problems in json(b) to_tsvector()
  • Fix problems defining multi-column range partition bounds
  • Fix partitioning crashes during error reporting
  • Fix race conditions in replication slot operations
  • Fix very minor memory leaks in psql's command.c
  • PL/Perl portability fix: avoid including XSUB.h in plperl.c
  • Fix inadequate stack depth checking in the wake of expression execution changes
  • Allow creation of C/POSIX collations without depending on libc behavior
  • Fix OBJECT_TYPE/OBJECT_DOMAIN confusion
  • Remove duplicate setting of SSL_OP_SINGLE_DH_USE option
  • Fix crash with logical replication on a function index
  • Teach map_partition_varattnos to handle whole-row expressions
  • Fix lock upgrade hazard in ATExecAttachPartition
  • Apply ALTER ... SET NOT NULL recursively in ALTER ... ADD PRIMARY KEY
  • hash: Increase the number of possible overflow bitmaps by 8x
  • Only kill sync workers at commit time in subscription DDL
  • Fix bug in deciding whether to scan newly-attached partition
  • Make pg_stop_backup's wait_for_archive flag work on standbys
  • Fix handling of dropped columns in logical replication
  • Fix local/remote attribute mix-up in logical replication

Note that some known issues remain unfixed. Before reporting a bug in the beta, please check the Open Items page.

Beta Schedule

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

Kategóriák: Informatika

Oldalak

Theme by me