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

General
1

I opened this issue at pgAdmin tree view doesn't show all databases from YugabyteDB Cloud · Issue #10186 · pgadmin-org/pgadmin4 · GitHub and have reposted it here.

I am able to query data from YugabyteDB cloud cluster but the database is not displaying correctly in pgAdmin. I attached two screenshots of my pgAdmin browser.

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
Image2936×1902 200 KB

Image
Image2933×1890 270 KB

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
2

Hello @fapulito

This is related to:

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

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

Can you check the oids of the dbs?

1 Like
3

Workarounds:

  • DB restriction (doesn’t pollute the rest of the tree): Server → Properties → Advanced tab → Restriction type = Database names, DB restriction = postgres, yugabyte, system_platform. That takes the db_restrictions branch of the template, which skips the OID filter entirely.

  • Alternative: Show system objects: File → Preferences → Browser → Display → Show system objects? → on. Sets last_system_oid = 0. Works, but it’s a global preference: every schema node then shows pg_catalog, information_schema, system columns, plus template0/template1.

1 Like
4

Thank you for your suggestions. For now the DB restriction field is grayed out and I can’t update it.

The alternative suggestion was present as a setting and still only the ‘postgres’ database shows up in the UI tree. This was confirmed after your suggestion.

I will review the suggested github issues later, I may also try DBeaver to compare.