PGAdmin shows excessive amount of database from Heroku

I'm learning some backend stuff, I made a test database locally and filled some data, and then I dump the database to an SQL file with the following command:

pg_dump -U USERNAME DATABASE —no-owner —no-acl -f backup.sql

And finally restore it to Heroku:

heroku pg:psql —app APPNAME < backup.sql

There is only 1 database I’m deploying, however, when I use PGAdmin to connect to it, it shows more than 2000 databases and crashes my computer:

Where are all these databases coming from?

Solution

You don't get a dedicated PostgreSQL server with Heroku Postgres. Your databases are co-located with other users' databases on the same server. You'll be able to see the names of other users' databases, but you won't be able to access them.

I'm not sure what "crashes my computer" means, but make sure you are selecting your database when trying to connect.