Вход на сайт

Просмотр новости

Найдите то, что Вас интересует

PostgreSQL 19 Beta 2 Released!

Дата публикации: 16-07-2026 00:00:00


The PostgreSQL Global Development Group announces that the second beta release of
PostgreSQL 19 is now available for download.
This release contains PostgreSQL 19 feature previews ahead of general
availability, though some details of the release can change during the beta
period.
You can find information about all of the PostgreSQL 19 features and changes in
the release notes:
https://www.postgresql.org/docs/19/release-19.html
In the spirit of the open source PostgreSQL community, we strongly encourage you
to test the new features of PostgreSQL 19 on your systems to help us eliminate
bugs and other issues. While we do not advise you to run beta versions in
production environments, we encourage you to find ways to run your typical
application workloads against this beta release.
Your testing and feedback help the community ensure that PostgreSQL 19
upholds our standards of delivering a stable, reliable release of the
world's most advanced open source relational database. Please read more about
our beta testing process and how
you can contribute:
https://www.postgresql.org/developer/beta/
Upgrading to PostgreSQL 19 Beta 2
To upgrade to PostgreSQL 19 Beta 2 from an earlier version of PostgreSQL,
you will need to use a strategy similar to upgrading between major versions of
PostgreSQL (e.g. pg_upgrade or pg_dump / pg_restore). For more
information, please visit the documentation section on
upgrading.
Changes Since Beta 1
Fixes and changes in PostgreSQL 19 Beta 2 include:
Fix a regression in vacuumdb --analyze-in-stages for partitioned tables.
Fix servicefile to show correct file after fallback to system file.
Fix tuple deformation optimization for virtual generated columns.
Allow pg_createsubscriber to accept duplicate publication names.
Fix REPACK worker not being cleaned up on a FATAL exit.
Several fixes for the new FOR PORTION OF temporal table syntax.
Fix race condition when logical decoding activation is concurrently
interrupted.
Disallow negative values for max_retention_duration.
Fix md5_password_warnings for role and database settings.
Several fixes for the new SQL/PGQ property graph feature.
Fix autovacuum's multixact-age score calculation, which could become infinite.
Revert non-text output formats for pg_dumpall.
Fix locking for ALTER DOMAIN ... VALIDATE CONSTRAINT.
Fix how postgres_fdw handles imported foreign-table statistics.
Please see the release notes
for a complete list of new and changed features:
https://www.postgresql.org/docs/19/release-19.html
Testing for Bugs & Compatibility
The stability of each PostgreSQL release greatly depends on you, the community,
to test the upcoming version with your workloads and testing tools to find bugs
and regressions before the general availability of PostgreSQL 19. As this is a
Beta, minor changes to database behaviors, feature details, and APIs are still
possible. Your feedback and testing will help determine the final tweaks on the
new features, so please test in the near future. The quality of user testing
helps determine when we can make a final release.
A list of open issues
is publicly available in the PostgreSQL wiki. You can
report bugs using this form on
the PostgreSQL website:
https://www.postgresql.org/account/submitbug/
Beta Schedule
This is the second beta release of version 19. The PostgreSQL Project will
release additional betas as required for testing, followed by one or more
release candidates, until the final release around September/October 2026. For further
information please see the Beta Testing
page.
Links
Download
Beta Testing Information
PostgreSQL 19 Beta Release Notes
PostgreSQL 19 Open Issues
Submit a Bug
Donate


Основное содержимое страницы с новостью.

Posted on 2026-07-16 by PostgreSQL Global Development Group

PostgreSQL Project

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 19 is now available for download. This release contains PostgreSQL 19 feature previews ahead of general availability, though some details of the release can change during the beta period.

You can find information about all of the PostgreSQL 19 features and changes in the release notes:

https://www.postgresql.org/docs/19/release-19.html

In the spirit of the open source PostgreSQL community, we strongly encourage you to test the new features of PostgreSQL 19 on your systems to help us eliminate bugs and other issues. While we do not advise you to run beta versions in production environments, we encourage you to find ways to run your typical application workloads against this beta release.

Your testing and feedback help the community ensure that PostgreSQL 19 upholds our standards of delivering a stable, reliable release of the world's most advanced open source relational database. Please read more about our beta testing process and how you can contribute:

https://www.postgresql.org/developer/beta/

Upgrading to PostgreSQL 19 Beta 2

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

Changes Since Beta 1

Fixes and changes in PostgreSQL 19 Beta 2 include:

  • Fix a regression in vacuumdb --analyze-in-stages for partitioned tables.
  • Fix servicefile to show correct file after fallback to system file.
  • Fix tuple deformation optimization for virtual generated columns.
  • Allow pg_createsubscriber to accept duplicate publication names.
  • Fix REPACK worker not being cleaned up on a FATAL exit.
  • Several fixes for the new FOR PORTION OF temporal table syntax.
  • Fix race condition when logical decoding activation is concurrently interrupted.
  • Disallow negative values for max_retention_duration.
  • Fix md5_password_warnings for role and database settings.
  • Several fixes for the new SQL/PGQ property graph feature.
  • Fix autovacuum's multixact-age score calculation, which could become infinite.
  • Revert non-text output formats for pg_dumpall.
  • Fix locking for ALTER DOMAIN ... VALIDATE CONSTRAINT.
  • Fix how postgres_fdw handles imported foreign-table statistics.

Please see the release notes for a complete list of new and changed features:

https://www.postgresql.org/docs/19/release-19.html

Testing for Bugs & Compatibility

The stability of each PostgreSQL release greatly depends on you, the community, to test the upcoming version with your workloads and testing tools to find bugs and regressions before the general availability of PostgreSQL 19. As this is a Beta, minor changes to database behaviors, feature details, and APIs are still possible. Your feedback and testing will help determine the final tweaks on the new features, so please test in the near future. The quality of user testing helps determine when we can make a final release.

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

https://www.postgresql.org/account/submitbug/

Beta Schedule

This is the second beta release of version 19. The PostgreSQL Project will release additional betas as required for testing, followed by one or more release candidates, until the final release around September/October 2026. For further information please see the Beta Testing page.

Links

Схожие новости

#Наименование новостиТональностьИнформативностьДата публикации
1powa-archivist 5.2.0 is out! 0512-07-2026
2Odyssey 1.5.1 released 5714-07-2026
3Postgres Professional усилила Postgres Pro Standard 18.4.1 встроенной отказоустойчивостью BiHA0518-06-2026
4СУБД PostgreSQL обновилась до версии 1801006-10-2025
5Postgres Professional выпустила ProGate 1.3.0 с поддержкой Shardman и отказоустойчивой репликацией0508-07-2026
6patera-database 0.9.00010-07-2026
7openSUSE pacemaker Important Denial Of Service CVE-2026-10649 2026-21196-10503-07-2026
8openSUSE GStreamer-Plugins-Bad Important Out-of-Bounds DoS CVE-2026-527190503-07-2026
99 Best Free and Open Source Configuration Management Databases0515-07-2026
10move - Mort release without updated move plugin gives issue during move actions. see PR #319-2515-07-2026

Классификация: Пресс-релизы. Схожих патентов: 0. Схожих новостей: 10. Тональность: 5. Информативность: 7. Источник: www.postgresql.org.