[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: pgAdmin 4 v6.20 Released
From: pgAdmin Development Team via PostgreSQL Announce <announce-noreply () postgresql ! or
Date: 2023-02-13 15:24:51
Message-ID: 167630189139.647185.8555591302793235363 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.20. This \
release of pgAdmin 4 includes 18 bug fixes and new features. For more details please \
see the [release notes](https://www.pgadmin.org/docs/pgadmin4/6.20/release_notes_6_20.html).
pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more \
information, please see [the website](https://www.pgadmin.org/).
### Note
Whilst pgAdmin 4 does not formally support downgrading, it typically does work if you \
uninstall and then reinstall the application.
This release of pgAdmin includes a major change to the configuration database \
structure which is NOT backward compatible, and therefore a straightforward downgrade \
will not work.
If you are using the default SQLite database for your configuration (as will be the \
case for the vast majority of users), the old version of the configuration database \
will be backed up to "pgadmin4.db.prev.bak" in your storage directory. If you wish to \
downgrade to pgAdmin v6.19 or earlier, after running v6.20, you must restore this \
file to "pgadmin4.db" in the same directory, BEFORE starting the older version of \
pgAdmin again.
If you are storing your configuration in an external PostgreSQL database, you will \
need to restore a backup of that database taken prior to the upgrade to v6.20, if you \
wish to return to the earlier version.
Changes made after migration such as the addition of new servers, will not be stored \
in the old database and will have to be re-created following a downgrade.
Notable changes in this release include:
### Features:
* Added support for setting PostgreSQL connection parameters.
With the help of this feature, a user can specify the connection parameters when \
connecting to a server using the server dialog. In the server dialog, we have added a \
new Parameters tab and removed the SSL tab. The Parameters tab now contains all SSL \
tab controls.
### Bugs/Housekeeping:
* Use uplot for Dashboard graphs to reduce CPU usage.
* Fixed an issue where the client cert location was not stored on the shared servers.
* Fix orphan database connections resulting in an inability to connect to databases.
* Ensure that the system columns should not visible in the import/export data.
* Increase the length of the value column of the setting table.
* Fix an issue where drag and drop object names are not working.
* Fix an issue where the role is used as a username for newly added servers when \
opening the query tool.
* Fixed an issue where Query history is not getting loaded with the external \
database.
* Fix failing import servers CLI due to vulnerability fix.
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](https://www.pgadmin.org/download/).
[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>pgAdmin 4 v6.20 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>
<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">pgAdmin 4 \
v6.20 Released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">The pgAdmin Development Team is pleased to announce pgAdmin 4 \
version 6.20. This release of pgAdmin 4 includes 18 bug fixes and new features. For \
more details please see the <a \
href="https://www.pgadmin.org/docs/pgadmin4/6.20/release_notes_6_20.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">pgAdmin is the leading Open Source graphical management tool for \
PostgreSQL. For more information, please see <a href="https://www.pgadmin.org/" \
style="color: #3498db; text-decoration: underline">the website</a>.</p> <h3 \
style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Note</h3> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Whilst pgAdmin \
4 does not formally support downgrading, it typically does work if you uninstall and \
then reinstall the application. </p> <p style="font-family: sans-serif; font-size: \
14px; font-weight: normal; margin: 0; margin-bottom: 15px">This release of pgAdmin \
includes a major change to the configuration database structure which is NOT backward \
compatible, and therefore a straightforward downgrade will not work. </p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">If you are using the default SQLite database for your \
configuration (as will be the case for the vast majority of users), the old version \
of the configuration database will be backed up to "pgadmin4.db.prev.bak" in your \
storage directory. If you wish to downgrade to pgAdmin v6.19 or earlier, after \
running v6.20, you must restore this file to "pgadmin4.db" in the same directory, \
BEFORE starting the older version of pgAdmin again. </p> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">If \
you are storing your configuration in an external PostgreSQL database, you will need \
to restore a backup of that database taken prior to the upgrade to v6.20, if you wish \
to return to the earlier version.</p> <p style="font-family: sans-serif; font-size: \
14px; font-weight: normal; margin: 0; margin-bottom: 15px">Changes made after \
migration such as the addition of new servers, will not be stored in the old database \
and will have to be re-created following a downgrade. </p> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px">Notable changes in this release include:</p> <h3 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">Features:</h3> <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"> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px">Added support for setting PostgreSQL connection parameters.</p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">With the help of this feature, a user can specify the connection \
parameters when connecting to a server using the server dialog. In the server dialog, \
we have added a new Parameters tab and removed the SSL tab. The Parameters tab now \
contains all SSL tab controls.</p> </li>
</ul>
<h3 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Bugs/Housekeeping:</h3> <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">Use uplot for Dashboard \
graphs to reduce CPU usage.</li> <li style="list-style-position: inside; margin-left: \
5px">Fixed an issue where the client cert location was not stored on the shared \
servers.</li> <li style="list-style-position: inside; margin-left: 5px">Fix orphan \
database connections resulting in an inability to connect to databases.</li> <li \
style="list-style-position: inside; margin-left: 5px">Ensure that the system columns \
should not visible in the import/export data.</li> <li style="list-style-position: \
inside; margin-left: 5px">Increase the length of the value column of the setting \
table.</li> <li style="list-style-position: inside; margin-left: 5px">Fix an issue \
where drag and drop object names are not working.</li> <li \
style="list-style-position: inside; margin-left: 5px">Fix an issue where the role is \
used as a username for newly added servers when opening the query tool.</li> <li \
style="list-style-position: inside; margin-left: 5px">Fixed an issue where Query \
history is not getting loaded with the external database.</li> <li \
style="list-style-position: inside; margin-left: 5px">Fix failing import servers CLI \
due to vulnerability fix.</li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Builds for Windows and macOS are available now, along with a \
Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the <a \
href="https://www.pgadmin.org/download/" style="color: #3498db; text-decoration: \
underline">tarball area</a>.</p>
</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 pgAdmin Development Team. It \
was delivered on their behalf by the PostgreSQL project. Any questions about the \
content of the message should be sent to pgAdmin Development Team.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
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>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic