codekingpro/portable-devtools
114k
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6 <head>
7 <meta charset="utf-8" />
8 <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10 <title>Version 8.6 — pgAdmin 4 8.6 documentation</title>
11 <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12 <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13
14 <script src="_static/documentation_options.js?v=d4c83366"></script>
15 <script src="_static/doctools.js?v=9a2dae69"></script>
16 <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17
18 <script src="_static/sidebar.js"></script>
19
20 <link rel="index" title="Index" href="genindex.html" />
21 <link rel="search" title="Search" href="search.html" />
22 <link rel="next" title="Version 8.5" href="release_notes_8_5.html" />
23 <link rel="prev" title="Release Notes" href="release_notes.html" />
24 </head><body>
25 <div class="related" role="navigation" aria-label="related navigation">
26 <h3>Navigation</h3>
27 <ul>
28 <li class="right" style="margin-right: 10px">
29 <a href="genindex.html" title="General Index"
30 accesskey="I">index</a></li>
31 <li class="right" >
32 <a href="release_notes_8_5.html" title="Version 8.5"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="release_notes.html" title="Release Notes"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-1"><a href="release_notes.html" accesskey="U">Release Notes</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">Version 8.6</a></li>
40 </ul>
41 </div>
42
43 <div class="document">
44 <div class="documentwrapper">
45 <div class="bodywrapper">
46 <div class="body" role="main">
47
48 <section id="version-8-6">
49<h1>Version 8.6<a class="headerlink" href="#version-8-6" title="Link to this heading">¶</a></h1>
50<p>Release date: 2024-05-02</p>
51<p>This release contains a number of bug fixes and new features since the release of pgAdmin 4 v8.5.</p>
52<section id="supported-database-servers">
53<h2>Supported Database Servers<a class="headerlink" href="#supported-database-servers" title="Link to this heading">¶</a></h2>
54<p><strong>PostgreSQL</strong>: 12, 13, 14, 15, and 16</p>
55<p><strong>EDB Advanced Server</strong>: 12, 13, 14, 15, and 16</p>
56</section>
57<section id="bundled-postgresql-utilities">
58<h2>Bundled PostgreSQL Utilities<a class="headerlink" href="#bundled-postgresql-utilities" title="Link to this heading">¶</a></h2>
59<p><strong>psql</strong>, <strong>pg_dump</strong>, <strong>pg_dumpall</strong>, <strong>pg_restore</strong>: 16.1</p>
60</section>
61<section id="new-features">
62<h2>New features<a class="headerlink" href="#new-features" title="Link to this heading">¶</a></h2>
63<blockquote>
64<div><div class="line-block">
65<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/6728">Issue #6728</a> - Added the new columns “last_seq_scan” and “last_idx_scan” from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab.</div>
66<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7163">Issue #7163</a> - Added support for excluding multiple tables while taking Backup.</div>
67</div>
68</div></blockquote>
69</section>
70<section id="housekeeping">
71<h2>Housekeeping<a class="headerlink" href="#housekeeping" title="Link to this heading">¶</a></h2>
72<blockquote>
73<div><div class="line-block">
74<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7213">Issue #7213</a> - Update UI library MUI from v4 to v5, more details <a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/commit/102e0a983956be57fdb63abb356b5b8fcb8b74ba">here</a></div>
75<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7362">Issue #7362</a> - Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7.</div>
76</div>
77</div></blockquote>
78</section>
79<section id="bug-fixes">
80<h2>Bug fixes<a class="headerlink" href="#bug-fixes" title="Link to this heading">¶</a></h2>
81<blockquote>
82<div><div class="line-block">
83<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/2410">Issue #2410</a> - Fixed all input boxes in pgAdmin to show browser auto-fill only where it is relevant.</div>
84<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7173">Issue #7173</a> - Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms.</div>
85<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7275">Issue #7275</a> - Fixed an issue where debugger was not scrolling automatically on stepping.</div>
86<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7282">Issue #7282</a> - Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216).</div>
87<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7294">Issue #7294</a> - Fixed an issue where double dollar quoted code is treated as string in syntax highlighter.</div>
88<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7317">Issue #7317</a> - Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling ‘Use spaces?’ in the preferences.</div>
89<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7334">Issue #7334</a> - Fixed an issue where incorrect select/exec scripts were generated for functions/procedures.</div>
90<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7372">Issue #7372</a> - Fixed an issue where connection to the database is not automatically re-established after connectivity drop.</div>
91<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7384">Issue #7384</a> - Fixed an issue when closing the view data second tab; it raises the error that the ‘ViewCommand’ object has no attribute ‘auto_commit’.</div>
92<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7390">Issue #7390</a> - Fixed violates check constraint issue when creating a pgAgent schedule.</div>
93<div class="line"><a class="reference external" href="https://github.com/pgadmin-org/pgadmin4/issues/7425">Issue #7425</a> - Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215).</div>
94</div>
95</div></blockquote>
96</section>
97</section>
98
99
100 <div class="clearer"></div>
101 </div>
102 </div>
103 </div>
104 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
105 <div class="sphinxsidebarwrapper">
106 <div>
107 <h3><a href="index.html">Table of Contents</a></h3>
108 <ul>
109<li><a class="reference internal" href="#">Version 8.6</a><ul>
110<li><a class="reference internal" href="#supported-database-servers">Supported Database Servers</a></li>
111<li><a class="reference internal" href="#bundled-postgresql-utilities">Bundled PostgreSQL Utilities</a></li>
112<li><a class="reference internal" href="#new-features">New features</a></li>
113<li><a class="reference internal" href="#housekeeping">Housekeeping</a></li>
114<li><a class="reference internal" href="#bug-fixes">Bug fixes</a></li>
115</ul>
116</li>
117</ul>
118
119 </div>
120<h3><a href="index.html">Table of Contents</a></h3>
121<ul class="current">
122<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
123<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
124<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
125<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
126<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
127<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
128<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
129<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
130<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
131<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
132<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
133<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
134<li class="toctree-l1 current"><a class="reference internal" href="release_notes.html">Release Notes</a><ul class="current">
135<li class="toctree-l2 current"><a class="current reference internal" href="#">Version 8.6</a></li>
136<li class="toctree-l2"><a class="reference internal" href="release_notes_8_5.html">Version 8.5</a></li>
137<li class="toctree-l2"><a class="reference internal" href="release_notes_8_4.html">Version 8.4</a></li>
138<li class="toctree-l2"><a class="reference internal" href="release_notes_8_3.html">Version 8.3</a></li>
139<li class="toctree-l2"><a class="reference internal" href="release_notes_8_2.html">Version 8.2</a></li>
140<li class="toctree-l2"><a class="reference internal" href="release_notes_8_1.html">Version 8.1</a></li>
141<li class="toctree-l2"><a class="reference internal" href="release_notes_8_0.html">Version 8.0</a></li>
142<li class="toctree-l2"><a class="reference internal" href="release_notes_7_8.html">Version 7.8</a></li>
143<li class="toctree-l2"><a class="reference internal" href="release_notes_7_7.html">Version 7.7</a></li>
144<li class="toctree-l2"><a class="reference internal" href="release_notes_7_6.html">Version 7.6</a></li>
145<li class="toctree-l2"><a class="reference internal" href="release_notes_7_5.html">Version 7.5</a></li>
146<li class="toctree-l2"><a class="reference internal" href="release_notes_7_4.html">Version 7.4</a></li>
147<li class="toctree-l2"><a class="reference internal" href="release_notes_7_3.html">Version 7.3</a></li>
148<li class="toctree-l2"><a class="reference internal" href="release_notes_7_2.html">Version 7.2</a></li>
149<li class="toctree-l2"><a class="reference internal" href="release_notes_7_1.html">Version 7.1</a></li>
150<li class="toctree-l2"><a class="reference internal" href="release_notes_7_0.html">Version 7.0</a></li>
151<li class="toctree-l2"><a class="reference internal" href="release_notes_6_21.html">Version 6.21</a></li>
152<li class="toctree-l2"><a class="reference internal" href="release_notes_6_20.html">Version 6.20</a></li>
153<li class="toctree-l2"><a class="reference internal" href="release_notes_6_19.html">Version 6.19</a></li>
154<li class="toctree-l2"><a class="reference internal" href="release_notes_6_18.html">Version 6.18</a></li>
155<li class="toctree-l2"><a class="reference internal" href="release_notes_6_17.html">Version 6.17</a></li>
156<li class="toctree-l2"><a class="reference internal" href="release_notes_6_16.html">Version 6.16</a></li>
157<li class="toctree-l2"><a class="reference internal" href="release_notes_6_15.html">Version 6.15</a></li>
158<li class="toctree-l2"><a class="reference internal" href="release_notes_6_14.html">Version 6.14</a></li>
159<li class="toctree-l2"><a class="reference internal" href="release_notes_6_13.html">Version 6.13</a></li>
160<li class="toctree-l2"><a class="reference internal" href="release_notes_6_12.html">Version 6.12</a></li>
161<li class="toctree-l2"><a class="reference internal" href="release_notes_6_11.html">Version 6.11</a></li>
162<li class="toctree-l2"><a class="reference internal" href="release_notes_6_10.html">Version 6.10</a></li>
163<li class="toctree-l2"><a class="reference internal" href="release_notes_6_9.html">Version 6.9</a></li>
164<li class="toctree-l2"><a class="reference internal" href="release_notes_6_8.html">Version 6.8</a></li>
165<li class="toctree-l2"><a class="reference internal" href="release_notes_6_7.html">Version 6.7</a></li>
166<li class="toctree-l2"><a class="reference internal" href="release_notes_6_6.html">Version 6.6</a></li>
167<li class="toctree-l2"><a class="reference internal" href="release_notes_6_5.html">Version 6.5</a></li>
168<li class="toctree-l2"><a class="reference internal" href="release_notes_6_4.html">Version 6.4</a></li>
169<li class="toctree-l2"><a class="reference internal" href="release_notes_6_3.html">Version 6.3</a></li>
170<li class="toctree-l2"><a class="reference internal" href="release_notes_6_2.html">Version 6.2</a></li>
171<li class="toctree-l2"><a class="reference internal" href="release_notes_6_1.html">Version 6.1</a></li>
172<li class="toctree-l2"><a class="reference internal" href="release_notes_6_0.html">Version 6.0</a></li>
173<li class="toctree-l2"><a class="reference internal" href="release_notes_5_7.html">Version 5.7</a></li>
174<li class="toctree-l2"><a class="reference internal" href="release_notes_5_6.html">Version 5.6</a></li>
175<li class="toctree-l2"><a class="reference internal" href="release_notes_5_5.html">Version 5.5</a></li>
176<li class="toctree-l2"><a class="reference internal" href="release_notes_5_4.html">Version 5.4</a></li>
177<li class="toctree-l2"><a class="reference internal" href="release_notes_5_3.html">Version 5.3</a></li>
178<li class="toctree-l2"><a class="reference internal" href="release_notes_5_2.html">Version 5.2</a></li>
179<li class="toctree-l2"><a class="reference internal" href="release_notes_5_1.html">Version 5.1</a></li>
180<li class="toctree-l2"><a class="reference internal" href="release_notes_5_0.html">Version 5.0</a></li>
181<li class="toctree-l2"><a class="reference internal" href="release_notes_4_30.html">Version 4.30</a></li>
182<li class="toctree-l2"><a class="reference internal" href="release_notes_4_29.html">Version 4.29</a></li>
183<li class="toctree-l2"><a class="reference internal" href="release_notes_4_28.html">Version 4.28</a></li>
184<li class="toctree-l2"><a class="reference internal" href="release_notes_4_27.html">Version 4.27</a></li>
185<li class="toctree-l2"><a class="reference internal" href="release_notes_4_26.html">Version 4.26</a></li>
186<li class="toctree-l2"><a class="reference internal" href="release_notes_4_25.html">Version 4.25</a></li>
187<li class="toctree-l2"><a class="reference internal" href="release_notes_4_24.html">Version 4.24</a></li>
188<li class="toctree-l2"><a class="reference internal" href="release_notes_4_23.html">Version 4.23</a></li>
189<li class="toctree-l2"><a class="reference internal" href="release_notes_4_22.html">Version 4.22</a></li>
190<li class="toctree-l2"><a class="reference internal" href="release_notes_4_21.html">Version 4.21</a></li>
191<li class="toctree-l2"><a class="reference internal" href="release_notes_4_20.html">Version 4.20</a></li>
192<li class="toctree-l2"><a class="reference internal" href="release_notes_4_19.html">Version 4.19</a></li>
193<li class="toctree-l2"><a class="reference internal" href="release_notes_4_18.html">Version 4.18</a></li>
194<li class="toctree-l2"><a class="reference internal" href="release_notes_4_17.html">Version 4.17</a></li>
195<li class="toctree-l2"><a class="reference internal" href="release_notes_4_16.html">Version 4.16</a></li>
196<li class="toctree-l2"><a class="reference internal" href="release_notes_4_15.html">Version 4.15</a></li>
197<li class="toctree-l2"><a class="reference internal" href="release_notes_4_14.html">Version 4.14</a></li>
198<li class="toctree-l2"><a class="reference internal" href="release_notes_4_13.html">Version 4.13</a></li>
199<li class="toctree-l2"><a class="reference internal" href="release_notes_4_12.html">Version 4.12</a></li>
200<li class="toctree-l2"><a class="reference internal" href="release_notes_4_11.html">Version 4.11</a></li>
201<li class="toctree-l2"><a class="reference internal" href="release_notes_4_10.html">Version 4.10</a></li>
202<li class="toctree-l2"><a class="reference internal" href="release_notes_4_9.html">Version 4.9</a></li>
203<li class="toctree-l2"><a class="reference internal" href="release_notes_4_8.html">Version 4.8</a></li>
204<li class="toctree-l2"><a class="reference internal" href="release_notes_4_7.html">Version 4.7</a></li>
205<li class="toctree-l2"><a class="reference internal" href="release_notes_4_6.html">Version 4.6</a></li>
206<li class="toctree-l2"><a class="reference internal" href="release_notes_4_5.html">Version 4.5</a></li>
207<li class="toctree-l2"><a class="reference internal" href="release_notes_4_4.html">Version 4.4</a></li>
208<li class="toctree-l2"><a class="reference internal" href="release_notes_4_3.html">Version 4.3</a></li>
209<li class="toctree-l2"><a class="reference internal" href="release_notes_4_2.html">Version 4.2</a></li>
210<li class="toctree-l2"><a class="reference internal" href="release_notes_4_1.html">Version 4.1</a></li>
211<li class="toctree-l2"><a class="reference internal" href="release_notes_4_0.html">Version 4.0</a></li>
212<li class="toctree-l2"><a class="reference internal" href="release_notes_3_6.html">Version 3.6</a></li>
213<li class="toctree-l2"><a class="reference internal" href="release_notes_3_5.html">Version 3.5</a></li>
214<li class="toctree-l2"><a class="reference internal" href="release_notes_3_4.html">Version 3.4</a></li>
215<li class="toctree-l2"><a class="reference internal" href="release_notes_3_3.html">Version 3.3</a></li>
216<li class="toctree-l2"><a class="reference internal" href="release_notes_3_2.html">Version 3.2</a></li>
217<li class="toctree-l2"><a class="reference internal" href="release_notes_3_1.html">Version 3.1</a></li>
218<li class="toctree-l2"><a class="reference internal" href="release_notes_3_0.html">Version 3.0</a></li>
219<li class="toctree-l2"><a class="reference internal" href="release_notes_2_1.html">Version 2.1</a></li>
220<li class="toctree-l2"><a class="reference internal" href="release_notes_2_0.html">Version 2.0</a></li>
221<li class="toctree-l2"><a class="reference internal" href="release_notes_1_6.html">Version 1.6</a></li>
222<li class="toctree-l2"><a class="reference internal" href="release_notes_1_5.html">Version 1.5</a></li>
223<li class="toctree-l2"><a class="reference internal" href="release_notes_1_4.html">Version 1.4</a></li>
224<li class="toctree-l2"><a class="reference internal" href="release_notes_1_3.html">Version 1.3</a></li>
225<li class="toctree-l2"><a class="reference internal" href="release_notes_1_2.html">Version 1.2</a></li>
226<li class="toctree-l2"><a class="reference internal" href="release_notes_1_1.html">Version 1.1</a></li>
227<li class="toctree-l2"><a class="reference internal" href="release_notes_1_0.html">Version 1.0</a></li>
228</ul>
229</li>
230<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
231</ul>
232
233<search id="searchbox" style="display: none" role="search">
234 <h3 id="searchlabel">Quick search</h3>
235 <div class="searchformwrapper">
236 <form class="search" action="search.html" method="get">
237 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
238 <input type="submit" value="Go" />
239 </form>
240 </div>
241</search>
242<script>document.getElementById('searchbox').style.display = "block"</script>
243 </div>
244<div id="sidebarbutton" title="Collapse sidebar">
245<span>«</span>
246</div>
247
248 </div>
249 <div class="clearer"></div>
250 </div>
251 <div class="related" role="navigation" aria-label="related navigation">
252 <h3>Navigation</h3>
253 <ul>
254 <li class="right" style="margin-right: 10px">
255 <a href="genindex.html" title="General Index"
256 >index</a></li>
257 <li class="right" >
258 <a href="release_notes_8_5.html" title="Version 8.5"
259 >next</a> |</li>
260 <li class="right" >
261 <a href="release_notes.html" title="Release Notes"
262 >previous</a> |</li>
263 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
264 <li class="nav-item nav-item-1"><a href="release_notes.html" >Release Notes</a> »</li>
265 <li class="nav-item nav-item-this"><a href="">Version 8.6</a></li>
266 </ul>
267 </div>
268 <div class="footer" role="contentinfo">
269 <div class="related" role="navigation" aria-label="related navigation">
270 <ul>
271 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
272 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
273 <li class="right" ><a href="release_notes_8_5.html" title="Version 8.5" accesskey="N">next</a> |</li>
274 <li class="right" ><a href="release_notes.html" title="Release Notes" accesskey="P">previous</a> |</li>
275 </ul>
276 </div>
277 </div>
278 </body>
279</html>