Thread: Missing Database in pgadmin4
Hi Paul,
Please check if you've added DB restriction in the server connection dialog -> advanced tab.
On Thu, Apr 18, 2024 at 10:12 AM Paul Strauss <pstrauss@carallel.com> wrote:
We deleted an empty database from a server and then renamed an existing database to the same name as the old one, but now the new database doesn't show up in pgadmin4 (Mac). The permissions are correct on the database for the user, and we can even see and query the database from inside of the pgadmin PSQL tool, but it doesn't show up in the list of databases in the GUI. And the database is accessible with other postgres clients.Any ideas on how to resolve the issue? It's happening to a couple of us, and even de-installing and re-installing pgadmin and preference files doesn't fix the issue.--
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
Attachment
Nope, it's blank:
On Thu, Apr 18, 2024 at 12:21 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Paul,Please check if you've added DB restriction in the server connection dialog -> advanced tab.On Thu, Apr 18, 2024 at 10:12 AM Paul Strauss <pstrauss@carallel.com> wrote:We deleted an empty database from a server and then renamed an existing database to the same name as the old one, but now the new database doesn't show up in pgadmin4 (Mac). The permissions are correct on the database for the user, and we can even see and query the database from inside of the pgadmin PSQL tool, but it doesn't show up in the list of databases in the GUI. And the database is accessible with other postgres clients.Any ideas on how to resolve the issue? It's happening to a couple of us, and even de-installing and re-installing pgadmin and preference files doesn't fix the issue.--
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.
Attachment
OK then, did you refresh the Databases node?
Can you please share the logs as well.
On Thu, Apr 18, 2024 at 7:14 PM Paul Strauss <pstrauss@carallel.com> wrote:
Nope, it's blank:On Thu, Apr 18, 2024 at 12:21 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:Hi Paul,Please check if you've added DB restriction in the server connection dialog -> advanced tab.On Thu, Apr 18, 2024 at 10:12 AM Paul Strauss <pstrauss@carallel.com> wrote:We deleted an empty database from a server and then renamed an existing database to the same name as the old one, but now the new database doesn't show up in pgadmin4 (Mac). The permissions are correct on the database for the user, and we can even see and query the database from inside of the pgadmin PSQL tool, but it doesn't show up in the list of databases in the GUI. And the database is accessible with other postgres clients.Any ideas on how to resolve the issue? It's happening to a couple of us, and even de-installing and re-installing pgadmin and preference files doesn't fix the issue.--
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"--
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.
Thanks,
Aditya Toshniwal
"Don't Complain about Heat, Plant a TREE"
Attachment
I haven't had a chance - I was wasting too many cycles on this so I switched to a different client.
Thanks for your help anyhow.
On Thu, Apr 18, 2024 at 11:32 PM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
OK then, did you refresh the Databases node?Can you please share the logs as well.On Thu, Apr 18, 2024 at 7:14 PM Paul Strauss <pstrauss@carallel.com> wrote:Nope, it's blank:On Thu, Apr 18, 2024 at 12:21 AM Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:Hi Paul,Please check if you've added DB restriction in the server connection dialog -> advanced tab.On Thu, Apr 18, 2024 at 10:12 AM Paul Strauss <pstrauss@carallel.com> wrote:We deleted an empty database from a server and then renamed an existing database to the same name as the old one, but now the new database doesn't show up in pgadmin4 (Mac). The permissions are correct on the database for the user, and we can even see and query the database from inside of the pgadmin PSQL tool, but it doesn't show up in the list of databases in the GUI. And the database is accessible with other postgres clients.Any ideas on how to resolve the issue? It's happening to a couple of us, and even de-installing and re-installing pgadmin and preference files doesn't fix the issue.--
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"--
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.--Thanks,Aditya Toshniwal"Don't Complain about Heat, Plant a TREE"
The information contained in this communication is confidential and is intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication or any part hereof is strictly prohibited and may be unlawful. If you have received this communication in error, please notify me by return e-mail, and destroy this communication and all copies thereof, including all attachments.