1

I created a free postgres database on Heroku, when connecting it to my pgAdmin4 the connection is done normally, however, thousands of databases appear along with mine. All the databases that appear I don't have access, only 1 that I have access (mine). see the image: enter image description here

See that many databases appear out of nowhere, but what I need is just this one, mine:

enter image description here

Question:

1. Is there any way to show just the database I have access to?

Improve this question
1
  • If those databases do not belong to you (or the Heroku account holder), then I would file a bug with Heroku as this would be an excellent way to reduce the amount of effort required to gain access to a database I don't have any business knowing about ... 🤔
    – matigo
    Jul 5, 2021 at 2:19

1 Answer 1

Reset to default
0

You probably cannot set pgAdmin4 to see only databases which you have access to, but there is a workaround - you can set it to see only selected databases.

Right button on your server, select Properties, tab Advanced, and add the names of the databases you want to see in the DB restriction field. If the field contains data, the other databases disappear from the list.

Warning: once the connection is saved, the field becomes read-only :(

enter image description here

See also https://medium.com/@vapurrmaid/getting-started-with-heroku-postgres-and-pgadmin-run-on-part-2-90d9499ed8fb

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.