[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: PostgreSQL 14 Beta 2 Released!
From: PostgreSQL Global Development Group <announce-noreply () postgresql ! org>
Date: 2021-06-24 14:21:11
Message-ID: 162454447168.698.4641951951923055328 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
The PostgreSQL Global Development Group announces that the second beta rele=
ase
of PostgreSQL 14 is now [available for download](https://www.postgresql.org=
/download/).
This release contains previews of all features that will be available in the
final release of PostgreSQL 14, though some details of the release could ch=
ange
before then.
You can find information about all of the features and changes found in
PostgreSQL 14 in the [release notes](https://www.postgresql.org/docs/14/rel=
ease-14.html):
[https://www.postgresql.org/docs/14/release-14.html](https://www.postgres=
ql.org/docs/14/release-14.html)
In the spirit of the open source PostgreSQL community, we strongly encourag=
e you
to test the new features of PostgreSQL 14 in your systems to help us elimin=
ate
any bugs or other issues that may exist. While we do not advise you to run
PostgreSQL 14 Beta 2 in your production environments, we encourage you to f=
ind
ways to run your typical application workloads against this beta release.
You can read more about our [beta testing process](https://www.postgresql.o=
rg/developer/beta/)
and how you can contribute here:
[https://www.postgresql.org/developer/beta/](https://www.postgresql.org/d=
eveloper/beta/)
Upgrading to PostgreSQL 14 Beta 2
---------------------------------
To upgrade to PostgreSQL 14 Beta 2 from Beta 1 or 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](https://www.postgresql.org/docs/14/static/upgrading.html).
Changes Since Beta 1
--------------------
There have been many bug fixes for PostgreSQL 14 reported during the Beta 1
period and applied to the Beta 2 release. This includes:
- Redesign the handling of OUT parameters for procedures.
- Various improvements and fixes to LZ4 support for toast columns.
- Support disabling index bypassing by `VACUUM`.
- Addition of `--no-toast-compression` to `pg_dumpall`
- Fix a crash in `libpq` with SSL SNI when specifying hostaddr in connection
string.
- Fix assertion failure when streaming multi-INSERT data in logical
replication.
- Fix portability issue with the function `permute` in pgbench.
- Fix `postgres_fdw` failures with whole-row Vars.
- Fix several issues with `pg_stat_wal`.
Please see the [release notes](https://www.postgresql.org/docs/14/release-1=
4.html)
for a complete list of new and changed features:
[https://www.postgresql.org/docs/14/release-14.html](https://www.postgres=
ql.org/docs/14/release-14.html)
Testing for Bugs & Compatibility
--------------------------------
The stability of each PostgreSQL release greatly depends on you, the commun=
ity,
to test the upcoming version with your workloads and testing tools in order=
to
find bugs and regressions before the general availability of PostgreSQL 14.=
As
this is a Beta, changes to database behaviors, feature details, and APIs are
still possible. Your feedback and testing will help determine the final twe=
aks
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](https://wiki.postgresql.org/wiki/PostgreSQL_14_Open=
_Items)
is publicly available in the PostgreSQL wiki. You can
[report bugs](https://www.postgresql.org/account/submitbug/) using this for=
m on
the PostgreSQL website:
[https://www.postgresql.org/account/submitbug/](https://www.postgresql.or=
g/account/submitbug/)
Beta Schedule
-------------
This is the second beta release of version 14. The PostgreSQL Project will
release additional betas as required for testing, followed by one or more
release candidates, until the final release in late 2021. For further
information please see the [Beta Testing](https://www.postgresql.org/develo=
per/beta/) page.
Links
-----
* [Download](https://www.postgresql.org/download/)
* [Beta Testing Information](https://www.postgresql.org/developer/beta/)
* [PostgreSQL 14 Beta Release Notes](https://www.postgresql.org/docs/14/rel=
ease-14.html)
* [PostgreSQL 14 Open Issues](https://wiki.postgresql.org/wiki/PostgreSQL_1=
4_Open_Items)
* [Submit a Bug](https://www.postgresql.org/account/submitbug/)
* [Follow @postgresql on Twitter](https://twitter.com/postgresql)
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>PostgreSQL 14 Beta 2 Released!</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<img alt="PostgreSQL logo" height="50" src="cid:slonik.png" style="float: left" \
width="50"/> <img alt="PostgreSQL logo" height="50" src="cid:slonik.png" \
style="float: right" width="50"/> <h1 style="color: #000; font-family: sans-serif; \
line-height: 1.4; margin: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; \
text-align: center">PostgreSQL 14 Beta 2 Released!</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">The PostgreSQL Global Development Group announces that the \
second beta release of PostgreSQL 14 is now <a \
href="https://www.postgresql.org/download/" style="color: #3498db; text-decoration: \
underline">available for download</a>. This release contains previews of all features \
that will be available in the final release of PostgreSQL 14, though some details of \
the release could change before then.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">You can find information about all of the features and changes \
found in PostgreSQL 14 in the <a \
href="https://www.postgresql.org/docs/14/release-14.html" style="color: #3498db; \
text-decoration: underline">release notes</a>:</p> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px"><a \
href="https://www.postgresql.org/docs/14/release-14.html" style="color: #3498db; \
text-decoration: underline">https://www.postgresql.org/docs/14/release-14.html</a></p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">In the spirit of the open source PostgreSQL community, we \
strongly encourage you to test the new features of PostgreSQL 14 in your systems to \
help us eliminate any bugs or other issues that may exist. While we do not advise you \
to run PostgreSQL 14 Beta 2 in your production environments, we encourage you to find
ways to run your typical application workloads against this beta release.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">You can read more about our <a \
href="https://www.postgresql.org/developer/beta/" style="color: #3498db; \
text-decoration: underline">beta testing process</a> and how you can contribute \
here:</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; \
margin: 0; margin-bottom: 15px"><a href="https://www.postgresql.org/developer/beta/" \
style="color: #3498db; text-decoration: \
underline">https://www.postgresql.org/developer/beta/</a></p> <h2 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">Upgrading to PostgreSQL 14 Beta 2</h2> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">To \
upgrade to PostgreSQL 14 Beta 2 from Beta 1 or an earlier version of PostgreSQL, you \
will need to use a strategy similar to upgrading between major versions of PostgreSQL \
(e.g. <code>pg_upgrade</code> or <code>pg_dump</code> / <code>pg_restore</code>). For \
more information, please visit the documentation section on <a \
href="https://www.postgresql.org/docs/14/static/upgrading.html" style="color: \
#3498db; text-decoration: underline">upgrading</a>.</p> <h2 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">Changes Since Beta 1</h2> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">There have been \
many bug fixes for PostgreSQL 14 reported during the Beta 1 period and applied to the \
Beta 2 release. This includes:</p> <ul style="font-family: sans-serif; font-size: \
14px; font-weight: normal; margin: 0; margin-bottom: 15px"> <li \
style="list-style-position: inside; margin-left: 5px">Redesign the handling of OUT \
parameters for procedures.</li> <li style="list-style-position: inside; margin-left: \
5px">Various improvements and fixes to LZ4 support for toast columns.</li> <li \
style="list-style-position: inside; margin-left: 5px">Support disabling index \
bypassing by <code>VACUUM</code>.</li> <li style="list-style-position: inside; \
margin-left: 5px">Addition of <code>--no-toast-compression</code> to \
<code>pg_dumpall</code></li> <li style="list-style-position: inside; margin-left: \
5px">Fix a crash in <code>libpq</code> with SSL SNI when specifying hostaddr in \
connection string.</li>
<li style="list-style-position: inside; margin-left: 5px">Fix assertion failure when \
streaming multi-INSERT data in logical replication.</li>
<li style="list-style-position: inside; margin-left: 5px">Fix portability issue with \
the function <code>permute</code> in pgbench.</li> <li style="list-style-position: \
inside; margin-left: 5px">Fix <code>postgres_fdw</code> failures with whole-row \
Vars.</li> <li style="list-style-position: inside; margin-left: 5px">Fix several \
issues with <code>pg_stat_wal</code>.</li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Please see the <a \
href="https://www.postgresql.org/docs/14/release-14.html" style="color: #3498db; \
text-decoration: underline">release notes</a> for a complete list of new and changed \
features:</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: \
normal; margin: 0; margin-bottom: 15px"><a \
href="https://www.postgresql.org/docs/14/release-14.html" style="color: #3498db; \
text-decoration: underline">https://www.postgresql.org/docs/14/release-14.html</a></p>
<h2 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Testing for Bugs & Compatibility</h2> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">The stability of each PostgreSQL release greatly depends on you, \
the community, to test the upcoming version with your workloads and testing tools in \
order to find bugs and regressions before the general availability of PostgreSQL 14. \
As this is a Beta, 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.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">A list of <a \
href="https://wiki.postgresql.org/wiki/PostgreSQL_14_Open_Items" style="color: \
#3498db; text-decoration: underline">open issues</a> is publicly available in the \
PostgreSQL wiki. You can <a href="https://www.postgresql.org/account/submitbug/" \
style="color: #3498db; text-decoration: underline">report bugs</a> using this form on \
the PostgreSQL website:</p> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px"><a \
href="https://www.postgresql.org/account/submitbug/" style="color: #3498db; \
text-decoration: underline">https://www.postgresql.org/account/submitbug/</a></p> <h2 \
style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Beta Schedule</h2> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">This is the \
second beta release of version 14. The PostgreSQL Project will release additional \
betas as required for testing, followed by one or more release candidates, until the \
final release in late 2021. For further information please see the <a \
href="https://www.postgresql.org/developer/beta/" style="color: #3498db; \
text-decoration: underline">Beta Testing</a> page.</p> <h2 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">Links</h2> <ul style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px"> <li style="list-style-position: \
inside; margin-left: 5px"><a href="https://www.postgresql.org/download/" \
style="color: #3498db; text-decoration: underline">Download</a></li> <li \
style="list-style-position: inside; margin-left: 5px"><a \
href="https://www.postgresql.org/developer/beta/" style="color: #3498db; \
text-decoration: underline">Beta Testing Information</a></li> <li \
style="list-style-position: inside; margin-left: 5px"><a \
href="https://www.postgresql.org/docs/14/release-14.html" style="color: #3498db; \
text-decoration: underline">PostgreSQL 14 Beta Release Notes</a></li> <li \
style="list-style-position: inside; margin-left: 5px"><a \
href="https://wiki.postgresql.org/wiki/PostgreSQL_14_Open_Items" style="color: \
#3498db; text-decoration: underline">PostgreSQL 14 Open Issues</a></li> <li \
style="list-style-position: inside; margin-left: 5px"><a \
href="https://www.postgresql.org/account/submitbug/" style="color: #3498db; \
text-decoration: underline">Submit a Bug</a></li> <li style="list-style-position: \
inside; margin-left: 5px"><a href="https://twitter.com/postgresql" style="color: \
#3498db; text-decoration: underline">Follow @postgresql on Twitter</a></li> </ul>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from the PostgreSQL project.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag PostgreSQL Project.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
["slonik.png" (image/png)]
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic