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?

Saulo Felipe
  • 93

1 Answers1

2

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 :( (However, if you disconnect from the server, then pull up properties again, it will allow editing.)

enter image description here

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

Scott Amussen
  • 3
  • 2
Honza Zidek
  • 121