PGAdmin 9.18 support

Поиск
Список
Период
Сортировка
Искать

PGAdmin 9.18 support

От:
"Vipul Kaushik (Moody's)" <Vipul.Kaushik@moodys.com>
Дата:

Hi PGAdmin Team,

 

I hope you are doing well.

 

We are reaching out regarding the issue reported in pgAdmin 9.18. We would appreciate it if you could let us know whether a permanent fix or updated solution is currently available.

 

The workaround that has been provided does not appear to be ideal for users managing multiple database connections, as it could be operationally challenging to implement at scale.

Additionally, we would like to highlight that pgAdmin 9.17 is currently identified as vulnerable, which limits our ability to remain on the previous version as a long-term mitigation.

Could you please advise on the recommended path forward and whether a patch, hotfix, or updated release is planned to address this issue?

We appreciate your assistance and look forward to your guidance.

 

https://github.com/pgadmin-org/pgadmin4/issues/10445

 

Thanks

Vipul


Moody's monitors email communications through its networks for regulatory compliance purposes and to protect its customers, employees and business and where allowed to do so by applicable law. The information contained in this e-mail message, and any attachment thereto, is confidential and may not be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.

Re: PGAdmin 9.18 support

От:
Dave Page <dpage@pgadmin.org>
Дата:
Hi

The next release of pgAdmin currently falls in the week of the 18th October on the normal schedule, however that is unlikely to happen as many folks will be at PGConf.EU 2026 then, therefore it will likely be a week or two later. In the meantime you can use a snapshot build (https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/) or stick with the older version.

It's worth noting that the CVE's fixed in 9.18 do not apply when using desktop mode with our Windows packages - they only apply in server deployments.

Regards, Dave.

On Wed, 7 Oct 2026 at 14:51, Vipul Kaushik (Moody's) <Vipul.Kaushik@moodys.com> wrote:

Hi PGAdmin Team,

 

I hope you are doing well.

 

We are reaching out regarding the issue reported in pgAdmin 9.18. We would appreciate it if you could let us know whether a permanent fix or updated solution is currently available.

 

The workaround that has been provided does not appear to be ideal for users managing multiple database connections, as it could be operationally challenging to implement at scale.

Additionally, we would like to highlight that pgAdmin 9.17 is currently identified as vulnerable, which limits our ability to remain on the previous version as a long-term mitigation.

Could you please advise on the recommended path forward and whether a patch, hotfix, or updated release is planned to address this issue?

We appreciate your assistance and look forward to your guidance.

 

https://github.com/pgadmin-org/pgadmin4/issues/10445

 

Thanks

Vipul


Moody's monitors email communications through its networks for regulatory compliance purposes and to protect its customers, employees and business and where allowed to do so by applicable law. The information contained in this e-mail message, and any attachment thereto, is confidential and may not be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.


--

Re: PGAdmin 9.18 support

От:
Rick Yost NC Data Team <Rick@NCDataTeam.org>
Дата:
Are there any plans to convert PGAdmin to Java? I deal with very large databases and some of the queries I run produce millions of records, I've been forced to use other products to extract the data and run my queries, but I always like pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger stuff. But since it's based on chromium, apparently there's a problem with downloading that many records after I run the query.

Thanks for all you do!
Rick


On October 9, 2026 4:48:28 AM EDT, Dave Page <dpage@pgadmin.org> wrote:
Hi

The next release of pgAdmin currently falls in the week of the 18th October on the normal schedule, however that is unlikely to happen as many folks will be at PGConf.EU 2026 then, therefore it will likely be a week or two later. In the meantime you can use a snapshot build (https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/) or stick with the older version.

It's worth noting that the CVE's fixed in 9.18 do not apply when using desktop mode with our Windows packages - they only apply in server deployments.

Regards, Dave.

On Wed, 7 Oct 2026 at 14:51, Vipul Kaushik (Moody's) <Vipul.Kaushik@moodys.com> wrote:

Hi PGAdmin Team,

 

I hope you are doing well.

 

We are reaching out regarding the issue reported in pgAdmin 9.18. We would appreciate it if you could let us know whether a permanent fix or updated solution is currently available.

 

The workaround that has been provided does not appear to be ideal for users managing multiple database connections, as it could be operationally challenging to implement at scale.

Additionally, we would like to highlight that pgAdmin 9.17 is currently identified as vulnerable, which limits our ability to remain on the previous version as a long-term mitigation.

Could you please advise on the recommended path forward and whether a patch, hotfix, or updated release is planned to address this issue?

We appreciate your assistance and look forward to your guidance.

 

https://github.com/pgadmin-org/pgadmin4/issues/10445

 

Thanks

Vipul


Moody's monitors email communications through its networks for regulatory compliance purposes and to protect its customers, employees and business and where allowed to do so by applicable law. The information contained in this e-mail message, and any attachment thereto, is confidential and may not be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.


Re: PGAdmin 9.18 support

От:
Pavel Stehule <pavel.stehule@gmail.com>
Дата:
Hi

út 13. 10. 2026 v 9:21 odesílatel Rick Yost NC Data Team <Rick@ncdatateam.org> napsal:
Are there any plans to convert PGAdmin to Java? I deal with very large databases and some of the queries I run produce millions of records, I've been forced to use other products to extract the data and run my queries, but I always like pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger stuff. But since it's based on chromium, apparently there's a problem with downloading that many records after I run the query.

What I know - dbeaver is written in Java, and I doubt it is faster than pgAdmin4.

Probably any interactive client written in any language fails out of memory when you will read (and display) millions of records.

Modern clients based on usage of some generic grid components are not designed for displaying millions rows. Maybe if you write your own with client side buffering in temp files, then it can work. But what I know is that all modern (universal) clients don't do this. 

Regards

Pavel

 

Thanks for all you do!
Rick


On October 9, 2026 4:48:28 AM EDT, Dave Page <dpage@pgadmin.org> wrote:
Hi

The next release of pgAdmin currently falls in the week of the 18th October on the normal schedule, however that is unlikely to happen as many folks will be at PGConf.EU 2026 then, therefore it will likely be a week or two later. In the meantime you can use a snapshot build (https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/) or stick with the older version.

It's worth noting that the CVE's fixed in 9.18 do not apply when using desktop mode with our Windows packages - they only apply in server deployments.

Regards, Dave.

On Wed, 7 Oct 2026 at 14:51, Vipul Kaushik (Moody's) <Vipul.Kaushik@moodys.com> wrote:

Hi PGAdmin Team,

 

I hope you are doing well.

 

We are reaching out regarding the issue reported in pgAdmin 9.18. We would appreciate it if you could let us know whether a permanent fix or updated solution is currently available.

 

The workaround that has been provided does not appear to be ideal for users managing multiple database connections, as it could be operationally challenging to implement at scale.

Additionally, we would like to highlight that pgAdmin 9.17 is currently identified as vulnerable, which limits our ability to remain on the previous version as a long-term mitigation.

Could you please advise on the recommended path forward and whether a patch, hotfix, or updated release is planned to address this issue?

We appreciate your assistance and look forward to your guidance.

 

https://github.com/pgadmin-org/pgadmin4/issues/10445

 

Thanks

Vipul


Moody's monitors email communications through its networks for regulatory compliance purposes and to protect its customers, employees and business and where allowed to do so by applicable law. The information contained in this e-mail message, and any attachment thereto, is confidential and may not be disclosed without our express permission. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message, or any attachment thereto, in whole or in part, is strictly prohibited. If you have received this message in error, please immediately notify us by telephone, fax or e-mail and delete the message and all of its attachments. Every effort is made to keep our network free from viruses. You should, however, review this e-mail message, as well as any attachment thereto, for viruses. We take no responsibility and have no liability for any computer virus which may be transferred via this e-mail message.


Re: PGAdmin 9.18 support

От:
Dave Page <dpage@pgadmin.org>
Дата:


On Tue, 13 Oct 2026 at 12:49, Pavel Stehule <pavel.stehule@gmail.com> wrote:
Hi

út 13. 10. 2026 v 9:21 odesílatel Rick Yost NC Data Team <Rick@ncdatateam.org> napsal:
Are there any plans to convert PGAdmin to Java? I deal with very large databases and some of the queries I run produce millions of records, I've been forced to use other products to extract the data and run my queries, but I always like pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger stuff. But since it's based on chromium, apparently there's a problem with downloading that many records after I run the query.

What I know - dbeaver is written in Java, and I doubt it is faster than pgAdmin4.

Probably any interactive client written in any language fails out of memory when you will read (and display) millions of records.

Modern clients based on usage of some generic grid components are not designed for displaying millions rows. Maybe if you write your own with client side buffering in temp files, then it can work. But what I know is that all modern (universal) clients don't do this. 

We use various techniques in pgAdmin, depending on your configuration; for example, batch loading from the backend (think cursors), and a virtual grid so we only need to render a limited number of rows above and below the current viewport.

That said, Pavel is quite right - no clients are really designed for displaying millions of rows. It's pointless, as humans can't handle viewing anything even remotely close to that amount of data. 

--

Re: PGAdmin 9.18 support

От:
Darren Duncan <darren@darrenduncan.net>
Дата:
In the scheme of things, PgAdmin 4 is already an ongoing rewrite in a new 
language, Python, compared to PgAdmin 3 that was written in C++.

It seems like the team already made their language choice for the "modern" 
version of the tool.

I would be surprised if they turn around and rewrite it again in Java any time 
soon, since the Python one is relatively new.

Granted, with the new LLM tools we have now, choosing to rewrite a codebase from 
one language to another isn't necessarily as onerous or time consuming as it 
once was.

What is the business case to do it now though?

On 2026-10-12 2:19 p.m., Rick Yost NC Data Team wrote:
> Are there any plans to convert PGAdmin to Java? I deal with very large databases 
> and some of the queries I run produce millions of records, I've been forced to 
> use other products to extract the data and run my queries, but I always like 
> pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger stuff. But 
> since it's based on chromium, apparently there's a problem with downloading that 
> many records after I run the query.


Re: PGAdmin 9.18 support

От:
Dave Page <dpage@pgadmin.org>
Дата:
Вложения:
You're not wrong, but at this point I wouldn't use the word "new" for pgAdmin 4 :-)



pgAdmin 1 (well, just pgAdmin back then), actually started in 1998/1999. I'm not sure of the exact date - the predecessor, pgManager was never released and that only lived for a brief while in 1998 or so. For those that remember it, it was a Visual Basic 4 clone of the original PostgreSQL GUI, pgAccess, written in TCL/TK.

On Tue, 13 Oct 2026 at 14:31, Darren Duncan <darren@darrenduncan.net> wrote:
In the scheme of things, PgAdmin 4 is already an ongoing rewrite in a new
language, Python, compared to PgAdmin 3 that was written in C++.

It seems like the team already made their language choice for the "modern"
version of the tool.

I would be surprised if they turn around and rewrite it again in Java any time
soon, since the Python one is relatively new.

Granted, with the new LLM tools we have now, choosing to rewrite a codebase from
one language to another isn't necessarily as onerous or time consuming as it
once was.

What is the business case to do it now though?

On 2026-10-12 2:19 p.m., Rick Yost NC Data Team wrote:
> Are there any plans to convert PGAdmin to Java? I deal with very large databases
> and some of the queries I run produce millions of records, I've been forced to
> use other products to extract the data and run my queries, but I always like
> pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger stuff. But
> since it's based on chromium, apparently there's a problem with downloading that
> many records after I run the query.




--

Re: PGAdmin 9.18 support

От:
Darren Duncan <darren@darrenduncan.net>
Дата:
So, then, given that the PgAdmin 4 lineage just by itself is now 13 years old 
and a lot has changed since then in the technology landscape...

Hypothetically, would you consider starting a PgAdmin 5 written in Java or some 
other stack, or would you still choose the same stack you have now to make a 
major new version today?

For me personally, by coincidence, Java is my top preferred and recommended 
application language, when the problem domain does not specifically favor 
something else, and I feel Java continues to receive vast useful improvements 
each year. Key factors include it having strong compile-time checking and typing 
while still heavily supporting generics, and having multiple major vendors 
supporting the core product.

Despite that, I do not currently feel that PgAdmin 4 is not "modern" or needing 
a rewrite for technology sake.

And I agree with the core design decision of a common code base for both a 
desktop application and a web application, this helps with the longevity of the 
current version, although at the same time also making it more structurally 
adaptable to piecewise rewrite, such as replacing the Python layer with Java 
while keeping the Javascript layer as that, not that there are really any 
alternatives to running in a web browser that aren't involving Javascript.

On 2026-10-13 6:48 a.m., Dave Page wrote:
> You're not wrong, but at this point I wouldn't use the word "new" for pgAdmin 4 :-)
> 
> Screenshot 2026-10-13 at 14.45.49.png
> 
> pgAdmin 1 (well, just pgAdmin back then), actually started in 1998/1999. I'm not 
> sure of the exact date - the predecessor, pgManager was never released and that 
> only lived for a brief while in 1998 or so. For those that remember it, it was a 
> Visual Basic 4 clone of the original PostgreSQL GUI, pgAccess, written in TCL/TK.
> 
> On Tue, 13 Oct 2026 at 14:31, Darren Duncan wrote:
> 
>     In the scheme of things, PgAdmin 4 is already an ongoing rewrite in a new
>     language, Python, compared to PgAdmin 3 that was written in C++.
> 
>     It seems like the team already made their language choice for the "modern"
>     version of the tool.
> 
>     I would be surprised if they turn around and rewrite it again in Java any time
>     soon, since the Python one is relatively new.
> 
>     Granted, with the new LLM tools we have now, choosing to rewrite a codebase
>     from
>     one language to another isn't necessarily as onerous or time consuming as it
>     once was.
> 
>     What is the business case to do it now though?
> 
>     On 2026-10-12 2:19 p.m., Rick Yost NC Data Team wrote:
>      > Are there any plans to convert PGAdmin to Java? I deal with very large
>     databases
>      > and some of the queries I run produce millions of records, I've been
>     forced to
>      > use other products to extract the data and run my queries, but I always like
>      > pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger
>     stuff. But
>      > since it's based on chromium, apparently there's a problem with
>     downloading that
>      > many records after I run the query.


Re: PGAdmin 9.18 support

От:
Dave Page <dpage@pgadmin.org>
Дата:
Hi

On Tue, 13 Oct 2026 at 19:35, Darren Duncan <darren@darrenduncan.net> wrote:
So, then, given that the PgAdmin 4 lineage just by itself is now 13 years old
and a lot has changed since then in the technology landscape...

Hypothetically, would you consider starting a PgAdmin 5 written in Java or some
other stack, or would you still choose the same stack you have now to make a
major new version today?

For me personally, by coincidence, Java is my top preferred and recommended
application language, when the problem domain does not specifically favor
something else, and I feel Java continues to receive vast useful improvements
each year. Key factors include it having strong compile-time checking and typing
while still heavily supporting generics, and having multiple major vendors
supporting the core product.

I have no plans to do so - pgAdmin is so big now it would be a huge task, really only viable if it were entirely vibe coded (though, modern versions of Opus and Fable are more than capable of producing far better code than most of us these days, *when properly guided*, so that’s not the end of the world I suppose).

If I did, I would not use Java though. Most of my recent projects have been Go on the backend, and Typescript/React on the front end. Though, Typescript throughout would probably make more sense for pgAdmin, given we would need to use Electron to host the desktop version.




Despite that, I do not currently feel that PgAdmin 4 is not "modern" or needing
a rewrite for technology sake.

And I agree with the core design decision of a common code base for both a
desktop application and a web application, this helps with the longevity of the
current version, although at the same time also making it more structurally
adaptable to piecewise rewrite, such as replacing the Python layer with Java
while keeping the Javascript layer as that, not that there are really any
alternatives to running in a web browser that aren't involving Javascript.

Many of the early problems with pgAdmin were down to the use of Python on the backend, and then figuring out how to make that work in NWjs and later Electron when our custom desktop host didn’t work out as we hoped. Sticking entirely to Typescript makes the most sense for Electron, which would mean running under Node in server mode.




On 2026-10-13 6:48 a.m., Dave Page wrote:
> You're not wrong, but at this point I wouldn't use the word "new" for pgAdmin 4 :-)
>
> Screenshot 2026-10-13 at 14.45.49.png
>
> pgAdmin 1 (well, just pgAdmin back then), actually started in 1998/1999. I'm not
> sure of the exact date - the predecessor, pgManager was never released and that
> only lived for a brief while in 1998 or so. For those that remember it, it was a
> Visual Basic 4 clone of the original PostgreSQL GUI, pgAccess, written in TCL/TK.
>
> On Tue, 13 Oct 2026 at 14:31, Darren Duncan wrote:
>
>     In the scheme of things, PgAdmin 4 is already an ongoing rewrite in a new
>     language, Python, compared to PgAdmin 3 that was written in C++.
>
>     It seems like the team already made their language choice for the "modern"
>     version of the tool.
>
>     I would be surprised if they turn around and rewrite it again in Java any time
>     soon, since the Python one is relatively new.
>
>     Granted, with the new LLM tools we have now, choosing to rewrite a codebase
>     from
>     one language to another isn't necessarily as onerous or time consuming as it
>     once was.
>
>     What is the business case to do it now though?
>
>     On 2026-10-12 2:19 p.m., Rick Yost NC Data Team wrote:
>      > Are there any plans to convert PGAdmin to Java? I deal with very large
>     databases
>      > and some of the queries I run produce millions of records, I've been
>     forced to
>      > use other products to extract the data and run my queries, but I always like
>      > pgAdmin4 for the smaller stuff.  I wish it would do it for the bigger
>     stuff. But
>      > since it's based on chromium, apparently there's a problem with
>     downloading that
>      > many records after I run the query.


FAQ