How to hide databases that I am not allowed to access

HerokuPgadmin

Heroku Problem Overview

When I connect to my Heroku - Postgresql database via pgAdmin3, It lists all the tables (about 2600). Every time I open the pgAdmin3 I have to find my own database.

Is there a way to hide databases that I'm not allowed to access ?

Heroku Solutions

Solution 1 - Heroku

Had the same issue, as its a shared space on AWS with 1000 other DBs.

pgAdmin 3

  1. Make sure you are disconnected from your server.
  2. Right click your Server -> properties -> Advanced tab.
  3. In 'DB restriction' type in the name of your database(s) enclosed in single quotes and separated by spaces. E.g. 'dback447'

pgAdmin 4

Same as above, but on step 3 do not use quotes, just the plain DB name. E.g dback447

pgAdmin 4 version 6.1

Same as above, but press Tab after entering the name of each database. Commas or spaces take your string as a name of one single database.

And you have to press Tab even if you want to type only one database name, otherwise the Save button ignores your changes.

enter image description here

enter image description here

enter image description here

Solution 2 - Heroku

pgAdmin 4 does not contain the 'DB Restriction' which is the only reason I am not using it, forcing me to settle for pgAdmin 3.

There was a ticket opened up to add this functionality in pgAdmin 4 ... https://redmine.postgresql.org/issues/1918

Solution 3 - Heroku

The latest version of pgAdmin 4 (2.0) has the DB restriction property too in the "Advanced" tab of the server connection property, much the same as in pgAdmin 3. No quotes needed.

Solution 4 - Heroku

I had the same issue with only 10 other DBs and Matt Stevens' answer was only partly helpful ie at first it helped and then I got access to another DB on the same server.

I did all as described and it shoed no DB at all. In 'DB restriction' you type in the name of your databases enclosed in single quotes and separated by commas. E.g. 'db1', 'db2'.

Solution 5 - Heroku

Don't enclose in single quotes in pgAdmin 4.5, it will not work if you do.

Categories
Recommended Heroku Solutions
Recommended Pgadmin Solutions

Previous Solution:

AngularJS: ng-show / ng-hide not working with `{{ }}` interpolation

AngularjsNg ShowNg Hide

Next Solution:

shared_ptr to an array : should it be used?

C++C++11Shared Ptr

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionalioguzhanView Question on Stackoverflow
Solution 1 - HerokuMatt StevensView Answer on Stackoverflow
Solution 2 - HerokuGarrettView Answer on Stackoverflow
Solution 3 - HerokugmorphView Answer on Stackoverflow
Solution 4 - HerokuBurkhardView Answer on Stackoverflow
Solution 5 - HerokumishapView Answer on Stackoverflow