pgAdmin 4 v9.19 - Application freezes when interacting with the UI

Open
#10,767 1 comment 0 reactions 1 assignee View on GitHub

Maintainers usually reply within 2 days

@CoderKing2705 is already working on this.

Since Nov 18, 2026.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Active
Tech stack
postgresql, python
Domain
databases, desktop

Research direction

Start with the reported pgAdmin 4 v9.19 Windows hang when expanding Servers, then inspect the supplied pgadmin4.log error and Windows AppHangB1 diagnostics. The issue names no source files or tests, so first determine whether the hang is reproducible and collect the requested diagnostic logs. Done means identifying the cause and restoring responsive UI interaction.

Written by the indexing model from the issue text.

Description

Issue Summary

I am experiencing a persistent application freezing issue with pgAdmin 4 version 9.19 on Windows.

pgAdmin launches and sometimes displays its interface successfully. However, when I attempt to interact with the application, such as expanding the Servers section or clicking other UI elements, the application becomes unresponsive.

The issue persists even after reinstalling pgAdmin and attempting to launch it using a temporary profile.

Environment Details

Component Details
Application pgAdmin 4
Version 9.19
Operating System Windows
Database PostgreSQL 18.6
PostgreSQL Service postgresql-x64-18
PostgreSQL Host localhost / 127.0.0.1
PostgreSQL Port 5432
PostgreSQL Client psql 18.6

Steps to Reproduce

  1. Launch pgAdmin 4.

  2. Wait for the application interface to load.

  3. Navigate to the Servers section.

  4. Attempt to expand the registered PostgreSQL server or interact with another UI element.

  5. The application freezes and becomes unresponsive.

  6. Windows eventually reports that the application is Not Responding.

Note: During some troubleshooting attempts, pgAdmin failed to display its interface at all.

Expected Behavior

  • pgAdmin should launch successfully.

  • The interface should remain responsive.

  • Users should be able to expand registered servers.

  • Database connections and management operations should work normally.

Actual Behavior

  • pgAdmin sometimes launches and displays its interface.

  • The application freezes during UI interaction.

  • The Servers section cannot be used reliably.

  • The application may become completely unresponsive.

  • Restarting or reinstalling pgAdmin does not resolve the issue.

  • Launching with a temporary profile also did not resolve the issue.

Troubleshooting Already Performed

1. Reinstalled pgAdmin 4

Uninstalled and reinstalled pgAdmin 4.

Result: The issue persists.

2. Verified PostgreSQL Service

Executed the following PowerShell command:

Get-Service *postgres*

Result:

Status   Name                 DisplayName
Running  postgresql-x64-18    postgresql-x64-18

Result: PostgreSQL service is running.

3. Verified PostgreSQL Port Connectivity

Executed:

Test-NetConnection localhost -Port 5432

Result:

TcpTestSucceeded : True

Result: PostgreSQL is accessible on port 5432.

4. Verified PostgreSQL Using psql

Successfully connected to PostgreSQL using the command-line client:

psql -U postgres -h localhost -p 5432

PostgreSQL client version:

psql (18.6)

Result: PostgreSQL connectivity works independently of pgAdmin.

5. Checked pgAdmin Logs

Located the pgAdmin application log:

%APPDATA%\pgAdmin\pgadmin4.log

Observed the following error:

connection failed: connection to server at "127.0.0.1",
port 5432 failed: fe_sendauth: no password supplied

This indicates a database authentication attempt without a supplied password.

However, I am unsure whether this error is directly related to the application freezing.

6. Checked pgAdmin Configuration Database

Verified that the following file exists:

%APPDATA%\pgAdmin\pgadmin4.db

File size:

2252800 bytes

I have not confirmed whether the configuration database is contributing to the issue.

7. Checked Windows Event Viewer

Windows Event Viewer recorded an application hang.

Event Type: Application Hang
Problem Event Name: AppHangB1
Application: pgAdmin4.exe

Windows also generated Windows Error Reporting (WER) diagnostic files associated with the hang.

8. Verified pgAdmin Runtime Version

The installed pgAdmin runtime reports:

ProductVersion: 9.19
FileVersion: 44.7.0
9. Attempted Temporary Profile Launch

Attempted to launch pgAdmin using a temporary profile to investigate whether the existing user configuration was responsible.

Result: The pgAdmin interface did not appear during this attempt.

Impact

This issue prevents me from using pgAdmin for PostgreSQL database administration.

Although PostgreSQL itself is working correctly through psql, I cannot reliably access databases, schemas, tables, or query tools through the pgAdmin graphical interface.

Questions for the pgAdmin Development Team

  1. Are there any known application freezing issues in pgAdmin 4 v9.19 on Windows?

  2. Could this issue be related to the pgAdmin runtime, embedded browser, or internal Python processes?

  3. Could the pgAdmin configuration database cause this type of application hang?

  4. What additional diagnostic logs should I collect to identify the root cause?

  5. Is there a recommended troubleshooting procedure that preserves existing pgAdmin server registrations and settings?

Additional Information

  • PostgreSQL service is running successfully.

  • PostgreSQL connectivity works using psql.

  • TCP connectivity to port 5432 is successful.

  • The application freeze persists after reinstalling pgAdmin.

  • Windows Event Viewer reports an AppHangB1 event.

  • A temporary-profile launch did not resolve the problem.

I can provide sanitized pgAdmin logs, screenshots, and Windows Event Viewer diagnostic details if required.

Any assistance or recommendations from the pgAdmin development team would be greatly appreciated.

Thank you.

image
Dominant language
Python
Stars
3.9k
Forks
922
Avg merge
2d 3h
Merged PRs (30d)
33

Getting set up

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from pgadmin-org/pgadmin4

All issues in pgadmin-org/pgadmin4

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.