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

Ouverte
#10,767 1 commentaire 0 réactions 1 personne assignée Voir sur GitHub

Les mainteneurs répondent en général sous 2 jours

@CoderKing2705 y travaille déjà.

Depuis le 18/11/2026.

Évaluation

Difficulté
4/5
Temps estimé
3-5 jours
Accessibilité débutants
35/100
Type d'issue
Bug
Clarté
Plutôt claire
Activité
Active
Stack technique
postgresql, python
Domaine
databases, desktop

Piste de recherche

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.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

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
Langage dominant
Python
Étoiles
3.9k
Forks
922
Merge moyen
2 j 3 h
PR mergées (30 j)
33

Préparer son environnement

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de pgadmin-org/pgadmin4

Toutes les issues de pgadmin-org/pgadmin4

Issues similaires

Plus d'issues Python

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.