Jelenlegi hely

PostreSQL.org

Feliratkozás PostreSQL.org hírcsatorna csatornájára
PostgreSQL news
Frissítve: 8 óra 19 perc

Scalefield - Rethinking PostgreSQL-as-a-service

2020, október 4 - 02:00

CYBERTEC is proud to announce the availability of Scalefield, a modern solution offering PostgreSQL-as-a-service for on-premise deployments and inhouse clouds.

Scalefield is based on Kubernetes and OpenShift and comes with:

clustering:

  • automatic failover
  • fully transparent clustering

storage options:

  • CEPH: network storage
  • SAN-storage
  • local SSD storage

automatic monitoring:

  • full Prometheus support
  • out of the box support for Grafana/pgwatch2

integrated data sets:

  • integrated GIS data sets
  • SQL sample data

web interfaces:

  • ready-to-use graphical user interface
  • intuitive graphical user management
  • ability to add PostgreSQL deployments easily

Scalefield is the ideal on premise solution for high availability PostgreSQL setups.

We also offer our solution to companies interested in building their own hosting offer.

More information & contact

Learn more about Scalefield on our website.

Contact our sales team for a personal demonstration or further information: sales@cybertec.at

Kategóriák: Informatika

oracle_fdw 2.3.0 released

2020, október 3 - 02:00

Version 2.3.0 of the Foreign Data Wrapper for Oracle is out.

This release provides support for PostgreSQL v13.

There are some new parameters to work around problems and limitations and make your life better, see the release notes.

A new function oracle_execute() allows executing utility statements on Oracle; this requires updating the extension with

ALTER EXTENSION oracle_fdw UPDATE;

after installing the binaries.

Project page: http://laurenz.github.io/oracle_fdw/

Source repository: https://github.com/laurenz/oracle_fdw

Enjoy!

Yours,
Laurenz Albe
Cybertec | https://www.cybertec-postgresql.com

Kategóriák: Informatika

PostgresDAC 3.9 meets PostgreSQL 13

2020, október 2 - 02:00
New milestone PostgresDAC release is out! Now with PostgreSQL 13 and RAD Studio 10.4.1 support

PostgresDAC is a direct access component suite for RAD Studio (Delphi and C++Builder)/FreePascal/Lazarus and PostgreSQL, EnterpriseDB, Amazon RDS, PostgresPro, and Heroku Postgres. Full changelog:

[!] v13 client libraries added [!] v13 dump & restore libraries (pg_dump.dll, pg_restore.dll) added [*] TPSQLTable.HasOIDs property removed as obsolete [*] Fix foCaseInsensitive in TPSQLDataset.Filter Download

You're welcome to download the PostgresDAC v3.9 right now at http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Kategóriák: Informatika

PostgreSQL 13 Released!

2020, szeptember 24 - 02:00

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

PostgreSQL 13 includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, better query planning when using enhanced statistics, and more.

Along with highly requested features like parallelized vacuuming and incremental sorting, PostgreSQL 13 provides a better data management experience for workloads big and small, with optimizations for daily administration, more conveniences for application developers, and security enhancements.

"PostgreSQL 13 showcases the collaboration and dedication of our global community in furthering the abilities of the world's most advanced open source relational database," said Peter Eisentraut, a PostgreSQL Core Team member. "The innovations that each release brings along with its reputation for reliability and stability is the reason why more people choose to use PostgreSQL for their applications."

PostgreSQL, an innovative data management system known for its reliability and robustness, benefits from over 25 years of open source development from a global developer community and has become the preferred open source relational database for organizations of all sizes.

Continued Performance Gains

Building on work from the previous PostgreSQL release, PostgreSQL 13 can efficiently handle duplicate data in B-tree indexes, the standard database index. This lowers the overall space usage that B-tree indexes require while improving overall query performance.

PostgreSQL 13 introduces incremental sorting, where sorted data from an earlier step in a query can accelerate sorting at a later step. Additionally, PostgreSQL can now use the extended statistics system (accessed via CREATE STATISTICS) to create improved plans for queries with OR clauses and IN/ANY lookups over lists.

In PostgreSQL 13, more types of aggregate and grouping set queries can leverage PostgreSQL’s efficient hash aggregation functionality, as queries with large aggregates do not have to fit entirely into memory. Queries with partitioned tables have received a performance boost, as there are now more cases where partitions can be pruned and where partitions can be directly joined.

Administration Optimizations

Vacuuming is an essential part of PostgreSQL administration, enabling the database to reclaim storage space after rows are updated and deleted. This process can also present administrative challenges, though prior PostgreSQL releases have done work to ease the overhead of vacuuming.

PostgreSQL 13 continues to improve the vacuuming system with the introduction of parallelized vacuum for indexes. In addition to the vacuuming performance benefits it offers, the use of this new feature can be tuned to specific workloads as administrators can select the number of parallel workers to run. In addition to these performance benefits, data inserts can now trigger the autovacuum process.

Replication slots, which are used to prevent write-ahead logs (WAL) from being removed before they are received by a replica, can be tuned in PostgreSQL 13 to specify the max number of WAL files to retain and help avoid out-of-disk errors.

PostgreSQL 13 also adds more ways an administrator can monitor database activity, including referencing WAL usage statistics from EXPLAIN, the progress of streaming base backups, and the progress of the ANALYZE commands. Additionally, the integrity of the output of the pg_basebackup command can be checked using the new pg_verifybackup command.

Application Development Conveniences

PostgreSQL 13 makes it even easier to work with PostgreSQL data types coming from different data sources. This release adds the datetime() function to its SQL/JSON path support, which converts valid time formats (e.g. ISO 8601 strings) to PostgreSQL-native types. Additionally, the UUID v4 generation function, gen_random_uuid(), is now available without having to install any extensions.

PostgreSQL’s partitioning system is more flexible, as partitioned tables fully support logical replication and BEFORE row-level triggers.

The FETCH FIRST syntax in PostgreSQL 13 is now expanded to include the WITH TIES clause. When specified, WITH TIES includes any rows that, based on the ORDER BY clause, "tie" with the last row in the result set.

Security Enhancements

PostgreSQL’s extension system is a key component of its robustness as it allows developers to expand its functionality. In previous releases, new extensions could only be installed by a database superuser. To make it easier to take advantage of PostgreSQL’s extensibility, PostgreSQL 13 adds the concept of a "trusted extension," which allows database users to install extensions that a superuser marks as "trusted." Certain built-in extensions are marked as trusted by default, including pgcrypto, tablefunc, hstore, and more.

For applications that require secure authentication methods, PostgreSQL 13 allows for clients to require channel binding when using SCRAM authentication, and the PostgreSQL foreign data wrapper (postgres_fdw) can now use certificate-based authentication.

About PostgreSQL

PostgreSQL is the world's most advanced open source database, with a global community of thousands of users, contributors, companies and organizations. Built on over 30 years of engineering, starting at the University of California, Berkeley, PostgreSQL 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.

Press Release Translations Links
Kategóriák: Informatika

pgagroal 0.9.0

2020, szeptember 23 - 02:00

The pgagroal community is happy to announce version 0.9.0.

New features

  • Transaction pooling
  • Huge page support
  • Unix Domain Socket support

Plus various improvements.

pgagroal

pgagroal is a high-performance protocol-native connection pool for PostgreSQL.

Features

  • High performance
  • Connection pool
  • Limit connections for users and databases
  • Prefill support
  • Remove idle connections
  • Perform connection validation
  • Enable / disable database access
  • Graceful / fast shutdown
  • Prometheus support
  • Remote management
  • Authentication query support
  • Failover support
  • Transport Layer Security (TLS) v1.2+ support
  • Daemon mode
  • User vault

Learn more on our web site or GitHub. Follow on Twitter.

pgagroal is released under the 3-clause BSD license, and is sponsored by Red Hat.

Kategóriák: Informatika

pg_chameleon 2.0.15

2020, szeptember 21 - 02:00

The new maintenance release for pg_chameleon adds the support for reduced lock if MySQL engine is transactional, thanks to rascalDan

The initialisation process now checks whether the engine for the table is transactional and runs the initial copy within a transaction. The process still requires a FLUSH TABLES WITH READ LOCK but the lock is released as soon as the transaction snapshot is acquired. This improvement allows pg_chameleon to run against primary databases with minimal impact during the init_replica process.

The python-mysql-replication requirement is now changed to version >=0.22 which adds the support for PyMySQL >=0.10.0.

Kategóriák: Informatika

ORC Foreign Data Wrapper Update Version 1.1.0 is Released!

2020, szeptember 21 - 02:00

HighGo Software Inc. (Canada) is pleased to announce the GitHub community release of orc_fdw v1.1.0.

Browse to the github release URL to access v1.1.0 release: ORC FDW v1.1.0 Release

Feature Enhancements:
  • Support added for joins between ORC foreign tables
  • Predicate pushdown handling added for boolean, const and operator evaluations
  • Target list pushdown for non-aggregate queries
  • Improved import schema functionality

and ...

  • Miscellaneous bug fixes
github

github: https://github.com/HighgoSoftware/orc_fdw/

Upcoming

In the meantime, we are continuously working on adding more features to this FDW. We look forward to your feedback which will help us improve it significantly. Part of the future enhancements is to add DML support which will be added in a future version.

Kategóriák: Informatika

Pgpool-II 4.1.4, 4.0.11, 3.7.16, 3.6.23 and 3.5.27 are now officially released.

2020, szeptember 21 - 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:

  • 4.1.4
  • 4.0.11
  • 3.7.16
  • 3.6.23
  • 3.5.27

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

Pgpool-II 4.1.4, 4.0.11, 3.7.16, 3.6.23 and 3.5.27 are now officially released.

2020, szeptember 21 - 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:

  • 4.1.4
  • 4.0.11
  • 3.7.16
  • 3.6.23
  • 3.5.27

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

pg_chameleon 2.0.15

2020, szeptember 21 - 02:00

The new maintenance release for pg_chameleon adds the support for reduced lock if MySQL engine is transactional, thanks to rascalDan

The initialisation process now checks whether the engine for the table is transactional and runs the initial copy within a transaction. The process still requires a FLUSH TABLES WITH READ LOCK but the lock is released as soon as the transaction snapshot is acquired. This improvement allows pg_chameleon to run against primary databases with minimal impact during the init_replica process.

The python-mysql-replication requirement is now changed to version >=0.22 which adds the support for PyMySQL >=0.10.0.

Kategóriák: Informatika

ORC Foreign Data Wrapper Update Version 1.1.0 is Released!

2020, szeptember 21 - 02:00

HighGo Software Inc. (Canada) is pleased to announce the GitHub community release of orc_fdw v1.1.0.

Browse to the github release URL to access v1.1.0 release: ORC FDW v1.1.0 Release

Feature Enhancements:
  • Support added for joins between ORC foreign tables
  • Predicate pushdown handling added for boolean, const and operator evaluations
  • Target list pushdown for non-aggregate queries
  • Improved import schema functionality

and ...

  • Miscellaneous bug fixes
github

github: https://github.com/HighgoSoftware/orc_fdw/

Upcoming

In the meantime, we are continuously working on adding more features to this FDW. We look forward to your feedback which will help us improve it significantly. Part of the future enhancements is to add DML support which will be added in a future version.

Kategóriák: Informatika

Brand New Tool – dbForge Schema Compare for PostgreSQL on Board

2020, szeptember 20 - 02:00

Devart has announced the release of a new tool, dbForge Schema Compare for PostgreSQL, which suits best for quick and efficient comparison of Amazon Redshift and PostgreSQL databases.

Devart, a recognized software vendor of database tools and data connectivity solutions, released a brand new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL. The tool is best suited when users need to compare Amazon Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

The new solution also has such key features as:

  1. Support for Amazon Redshift. The first version features Amazon Redshift support to compare and synchronize database schemas.
  2. Limited Support for PostgreSQL. At the moment, the vendor also implemented the limited support for the following PostgreSQL databases: PostgreSQL, Amazon RDS for PostgreSQL, Azure PostgreSQL.
  3. Support for Redshift Objects. The solution allows users to compare and sync the following Redshift objects: Schemas, Tables, Views, Function, Procedures, Comments, Privileges.
  4. Identification of Object Dependencies. The tool allows users to sync objects they have not selected for synchronization but which are used by objects they added to synchronize.
  5. Review of DDL Differences in Database Objects. Also, users can view DDL differences for each object pair to analyze the schema comparison result.
  6. Execution of Query History. Users can get basic information about PostgreSQL queries executed in the database for a certain period of time.
  7. Execution of Large Script. The large scripts can be executed without opening in the editor.

Learn more about the recent release by visiting Devart’s blog article.

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. For additional information about Devart, visit https://www.devart.com/.

Kategóriák: Informatika

Brand New Tool – dbForge Schema Compare for PostgreSQL on Board

2020, szeptember 20 - 02:00

Devart has announced the release of a new tool, dbForge Schema Compare for PostgreSQL, which suits best for quick and efficient comparison of Amazon Redshift and PostgreSQL databases.

Devart, a recognized software vendor of database tools and data connectivity solutions, released a brand new product from the dbForge Tools for PostgreSQL line – dbForge Schema Compare for PostgreSQL. The tool is best suited when users need to compare Amazon Redshift databases quickly and efficiently, as well as to generate synchronization SQL scripts to update target database schemas.

The new solution also has such key features as:

  1. Support for Amazon Redshift. The first version features Amazon Redshift support to compare and synchronize database schemas.
  2. Limited Support for PostgreSQL. At the moment, the vendor also implemented the limited support for the following PostgreSQL databases: PostgreSQL, Amazon RDS for PostgreSQL, Azure PostgreSQL.
  3. Support for Redshift Objects. The solution allows users to compare and sync the following Redshift objects: Schemas, Tables, Views, Function, Procedures, Comments, Privileges.
  4. Identification of Object Dependencies. The tool allows users to sync objects they have not selected for synchronization but which are used by objects they added to synchronize.
  5. Review of DDL Differences in Database Objects. Also, users can view DDL differences for each object pair to analyze the schema comparison result.
  6. Execution of Query History. Users can get basic information about PostgreSQL queries executed in the database for a certain period of time.
  7. Execution of Large Script. The large scripts can be executed without opening in the editor.

Learn more about the recent release by visiting Devart’s blog article.

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. For additional information about Devart, visit https://www.devart.com/.

Kategóriák: Informatika

pgAdmin 4 v4.26 Released

2020, szeptember 18 - 02:00

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 4.26. This release of pgAdmin 4 includes 30 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:

  • Added SQL Formatter support in Query Tool.
  • Added a new button to the query tool toolbar to open a new query tool window.
  • Added shared server support for admin users.
  • Warn the user when connecting to a server that is older than pgAdmin supports.
  • Ensure that schema names starting with 'pg' should be visible in the browser tree when standard_conforming_strings is set to off.
  • Fixed an issue where --load-server does not allow loading connections that use pg_services.
  • Fixed string indices must be integers issue for PostgreSQL < 9.3
  • Fixed an issue where the application ignores the fixed port configuration value.
  • Remove the illegal argument from the trigger function in the trigger DDL statement.
  • Ensure that 'setup-web.sh' should work in Debian 10.
  • Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset.

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

Kategóriák: Informatika

pgAdmin 4 v4.26 Released

2020, szeptember 18 - 02:00

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 4.26. This release of pgAdmin 4 includes 30 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:

  • Added SQL Formatter support in Query Tool.
  • Added a new button to the query tool toolbar to open a new query tool window.
  • Added shared server support for admin users.
  • Warn the user when connecting to a server that is older than pgAdmin supports.
  • Ensure that schema names starting with 'pg' should be visible in the browser tree when standard_conforming_strings is set to off.
  • Fixed an issue where --load-server does not allow loading connections that use pg_services.
  • Fixed string indices must be integers issue for PostgreSQL < 9.3
  • Fixed an issue where the application ignores the fixed port configuration value.
  • Remove the illegal argument from the trigger function in the trigger DDL statement.
  • Ensure that 'setup-web.sh' should work in Debian 10.
  • Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset.

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

Kategóriák: Informatika

PostgreSQL 13 RC 1 Released!

2020, szeptember 17 - 02:00

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 13 is now available for download. As a release candidate, PostgreSQL 13 RC 1 will be mostly identical to the initial release of PostgreSQL 13, though some more fixes may be applied prior to the general availability of PostgreSQL 13.

The planned date for the general availability of PostgreSQL 13 is September 24, 2020. Please see the "Release Schedule" section for more details.

Upgrading to PostgreSQL 13 RC 1

To upgrade to PostgreSQL 13 RC 1 from earlier versions of PostgreSQL, you will need to use a major version upgrade strategy, e.g. pg_upgrade or pg_dump / pg_restore. For more information, please visit the documentation section on upgrading.

Changes Since 13 Beta 3

Several bug fixes were applied for PostgreSQL 13 during the Beta 3 period. These include:

  • Adjustments to the costing model for hash aggregates that spill to disk.
  • Adjustments to the output of EXPLAIN (BUFFERS).
  • Display the stats target of extended statistics in the output of \d.

For a detailed list of fixes, please visit the open items page.

Release Schedule

This is the first release candidate for PostgreSQL 13. Unless an issue is discovered that warrants a delay or to produce an additional release candidate, PostgreSQL 13 should be made generally available on September 24, 2020.

For further information please see the Beta Testing page.

Links
Kategóriák: Informatika

PostgreSQL 13 RC 1 Released!

2020, szeptember 17 - 02:00

The PostgreSQL Global Development Group announces that the first release candidate of PostgreSQL 13 is now available for download. As a release candidate, PostgreSQL 13 RC 1 will be mostly identical to the initial release of PostgreSQL 13, though some more fixes may be applied prior to the general availability of PostgreSQL 13.

The planned date for the general availability of PostgreSQL 13 is September 24, 2020. Please see the "Release Schedule" section for more details.

Upgrading to PostgreSQL 13 RC 1

To upgrade to PostgreSQL 13 RC 1 from earlier versions of PostgreSQL, you will need to use a major version upgrade strategy, e.g. pg_upgrade or pg_dump / pg_restore. For more information, please visit the documentation section on upgrading.

Changes Since 13 Beta 3

Several bug fixes were applied for PostgreSQL 13 during the Beta 3 period. These include:

  • Adjustments to the costing model for hash aggregates that spill to disk.
  • Adjustments to the output of EXPLAIN (BUFFERS).
  • Display the stats target of extended statistics in the output of \d.

For a detailed list of fixes, please visit the open items page.

Release Schedule

This is the first release candidate for PostgreSQL 13. Unless an issue is discovered that warrants a delay or to produce an additional release candidate, PostgreSQL 13 should be made generally available on September 24, 2020.

For further information please see the Beta Testing page.

Links
Kategóriák: Informatika

PL/R 8.4.1 released

2020, szeptember 16 - 02:00

This is a maintenance release primarily to deal with a small change in the backend API.

Issue validating some functions was fixed by Mikhail Titov

There should be no changes visible to the user.

Windows releases can be found here

Kategóriák: Informatika

PL/R 8.4.1 released

2020, szeptember 16 - 02:00

This is a maintenance release primarily to deal with a small change in the backend API.

Issue validating some functions was fixed by Mikhail Titov

There should be no changes visible to the user.

Windows releases can be found here

Kategóriák: Informatika

PostgreSQL Prometheus Adapter - Initial Release

2020, szeptember 10 - 02:00

Crunchy Data is pleased to announce the initial release of the PostgreSQL Prometheus Adapter, a remote storage adapter for enabling Prometheus to use PostgreSQL as a storage system for time-series metrics. You can find the PostgreSQL Prometheus Adapter project here:

https://github.com/CrunchyData/postgresql-prometheus-adapter

PostgreSQL Prometheus Adapter leverages PostgreSQL 12's native partitioning enhancements to efficiently store Prometheus time series data in a PostgreSQL database. Incoming data is processed by one or more threads that store the data in PostgreSQL partitions that are automatically created hourly or daily.

You can run the PostgreSQL Prometheus Adapter either as a cross-platform native application or within a container. We've provided a guide for how you can set up and use the PostgreSQL Prometheus Adapter here:

https://info.crunchydata.com/blog/using-postgres-to-back-prometheus-for-your-postgresql-monitoring-1

The PostgreSQL Prometheus Adapter is released under an Apache 2.0 license. We welcome your feedback and contributions to the project!

Links

Crunchy Data is proud to support the development and maintenance of the PostgreSQL Prometheus Adapter.

Kategóriák: Informatika

Oldalak

Theme by me