Search code examples
herokuheroku-postgres

Heroku psql lists hundreds of weird databases

So when I go into "heroku pg:psql" and type \l I get this:

enter image description here

What's the deal with that?

Solution

  • On dev and basic plans, your postgresql database is shared with others on the server.
    Therefore, you are not the only one on this server, there are other users.

    These databases you're seeing are the other users' databases.
    You can't access them. But you can know they are here.