search

shuttle-hq / shuttle

Build & ship backends without writing any infrastructure files.
https://shuttle.rs
Apache License 2.0
5.77k stars 242 forks source link

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

Open ophilli opened 4 weeks ago

ophilli commented 4 weeks ago

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) image

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

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

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

jonaro00 commented 4 weeks ago

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.