Skip to content

pgAdmin tree view doesn't show all databases from YugabyteDB Cloud #10186

Description

@fapulito

Describe the bug

pgAdmin's tree view only displays the postgres database when connected to YugabyteDB Cloud, even though the connection is correctly configured with yugabyte as the maintenance database. SQL queries prove that all databases exist and are accessible, but they don't appear in the tree view.

To Reproduce

Steps to reproduce the behavior:

  1. Connect to YugabyteDB Cloud (Aeon) cluster
  2. Configure connection with:
    • Maintenance database: yugabyte
    • SSL Mode: Verify-Full
    • Root certificate: YugabyteDB CA certificate
  3. Expand the server in tree view
  4. Expand "Databases" folder
  5. Observe that only postgres database is shown

Expected behavior

Tree view should display all 3 databases: postgres, yugabyte, system_platform

Error message

No error messages. The connection succeeds, but databases are missing from the tree view.

Evidence this is a pgAdmin UI bug (not database issue):

  1. SQL query confirms all databases exist and are accessible:
SELECT datname FROM pg_database WHERE datistemplate = false;

Returns: postgres, yugabyte, system_platform

  1. Queries against the yugabyte database work perfectly:
SELECT COUNT(*) FROM awdc.laas_population_data;

Returns: 59,153 rows (proves connection to yugabyte database works)

  1. Connection settings verified correct:
    • Maintenance database: yugabyte (NOT postgres)
    • Query Tool connects to correct database
    • All credentials confirmed working

Screenshots

Image Image

Desktop (please complete the following information):

  • OS: Windows 11
  • pgAdmin version: 9.8
  • Mode: Desktop
  • Package type: Windows installer

Additional context

  • Database: YugabyteDB Cloud (Aeon)
  • The yugabyte and system_platform databases are accessible via Query Tool
  • This affects teams who rely on visual tree navigation to explore database schemas
  • Current workaround: Use Query Tool exclusively for all database operations

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions