[go: up one dir, main page]

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
1 task done
ophilli opened this issue Jun 3, 2024 · 1 comment
Open
1 task done

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

ophilli opened this issue Jun 3, 2024 · 1 comment
Labels
S-Triage Awaiting decision for what to do T-Bug Something isn't working

Comments

@ophilli
Copy link
ophilli commented Jun 3, 2024

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

  • I have searched the issues and there are none like this.
@ophilli ophilli added S-Triage Awaiting decision for what to do T-Bug Something isn't working labels Jun 3, 2024
@jonaro00
Copy link
Member
jonaro00 commented Jun 3, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
S-Triage Awaiting decision for what to do T-Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants