[Bug]: Trouble connecting to Shuttle Shared Databases with PgAdmin

[ophilli]

What happened?

I'm struggling to use PgAdmin 4 v8.7 to connect to my shuttle shared database. When I deploy a project with a shared postgres database I get a connection string like postgres://user-<project_name>:********@db.shuttle.rs:5432/db-<project_name> and I can use cargo shuttle resource list --show-secrets to see the full connection string like postgres://user-<project_name>:<password>@db.shuttle.rs:5432/db-<project_name>

You can see here for an example of how I'm trying to configure the connection (note that I'm using my actual project name, not the <project_name> placeholder)

Then after connecting I get a "Failed to retrieve data from the server. permission denied for table pg_database" error.

I've also tried changing the "Maintenance database" setting but that does not seem to work either.

Version

v0.45.0

Which operating system(s) are you seeing the problem on?

macOS

Which CPU architectures are you seeing the problem on?

ARM64

Relevant log output

No response

Duplicate declaration

• I have searched the issues and there are none like this.

[jonaro00]

The shared Postgres cluster has lots of restrictions, making "permission denied for table pg_database" appear when doing various operations on pgAdmin. If you close the error box(es) you should still be able to interact with your database.