Thread: Some databases not listed in treeview
Hi all, I've just come across a funny in pgAdmin 4 version 8.13: when I connect from my laptop to a server on the same laptop, not all databases are listed in the tree-view on the left. The server is PostgreSQL 16.6. Connecting to the server with psql and doing \l shows me 12 databases, including template0 and template1. Likewise, "select * from pg_database" gives me the same 12 rows. However, the treeview shows only 9... template* databases are excluded, plus one other of my own. Interestingly, when I select from pg_database, the one database of mine which is excluded has an OID of 4; all the others have 5-digit OIDs. I don't know why its OID is so low; it's come forward through a few PG versions over several years, so probably historical baggage. All the best, Ray. -- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie
Hi Ray,
I'm not sure how your DB has an OID of 4 digits. pgAdmin considers all DBs with OIDs less than equal to 16383 as system DBs. So your DB here is considered a system DB.
On Fri, Nov 29, 2024 at 6:32 PM Ray O'Donnell <ray@rodonnell.ie> wrote:
Hi all,
I've just come across a funny in pgAdmin 4 version 8.13: when I connect
from my laptop to a server on the same laptop, not all databases are
listed in the tree-view on the left. The server is PostgreSQL 16.6.
Connecting to the server with psql and doing \l shows me 12 databases,
including template0 and template1. Likewise, "select * from pg_database"
gives me the same 12 rows. However, the treeview shows only 9...
template* databases are excluded, plus one other of my own.
Interestingly, when I select from pg_database, the one database of mine
which is excluded has an OID of 4; all the others have 5-digit OIDs. I
don't know why its OID is so low; it's come forward through a few PG
versions over several years, so probably historical baggage.
All the best,
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
try to check the scheme name plz
---Original---
From: "Aditya Toshniwal"<aditya.toshniwal@enterprisedb.com>
Date: Mon, Dec 2, 2024 11:10 AM
To: "Ray O'Donnell"<ray@rodonnell.ie>;
Cc: "Pgadmin-Support"<pgadmin-support@postgresql.org>;
Subject: Re: Some databases not listed in treeview
Hi Ray,
I'm not sure how your DB has an OID of 4 digits. pgAdmin considers all DBs with OIDs less than equal to 16383 as system DBs. So your DB here is considered a system DB.
On Fri, Nov 29, 2024 at 6:32 PM Ray O'Donnell <ray@rodonnell.ie> wrote:
Hi all,
I've just come across a funny in pgAdmin 4 version 8.13: when I connect
from my laptop to a server on the same laptop, not all databases are
listed in the tree-view on the left. The server is PostgreSQL 16.6.
Connecting to the server with psql and doing \l shows me 12 databases,
including template0 and template1. Likewise, "select * from pg_database"
gives me the same 12 rows. However, the treeview shows only 9...
template* databases are excluded, plus one other of my own.
Interestingly, when I select from pg_database, the one database of mine
which is excluded has an OID of 4; all the others have 5-digit OIDs. I
don't know why its OID is so low; it's come forward through a few PG
versions over several years, so probably historical baggage.
All the best,
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
Helo Aditya,
Thanks for responding. I've no idea how that happened either! Anyway, I'm glad to know what the issue is - thanks for clarifying.
Ray.
On 02/12/2024 03:10, Aditya Toshniwal wrote:
Thanks for responding. I've no idea how that happened either! Anyway, I'm glad to know what the issue is - thanks for clarifying.
Ray.
On 02/12/2024 03:10, Aditya Toshniwal wrote:
Hi Ray,I'm not sure how your DB has an OID of 4 digits. pgAdmin considers all DBs with OIDs less than equal to 16383 as system DBs. So your DB here is considered a system DB.On Fri, Nov 29, 2024 at 6:32 PM Ray O'Donnell <ray@rodonnell.ie> wrote:Hi all,
I've just come across a funny in pgAdmin 4 version 8.13: when I connect
from my laptop to a server on the same laptop, not all databases are
listed in the tree-view on the left. The server is PostgreSQL 16.6.
Connecting to the server with psql and doing \l shows me 12 databases,
including template0 and template1. Likewise, "select * from pg_database"
gives me the same 12 rows. However, the treeview shows only 9...
template* databases are excluded, plus one other of my own.
Interestingly, when I select from pg_database, the one database of mine
which is excluded has an OID of 4; all the others have 5-digit OIDs. I
don't know why its OID is so low; it's come forward through a few PG
versions over several years, so probably historical baggage.
All the best,
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"
-- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie