Unable to connect to database after restoring backup

As mentioned in the title. I restored a backup after making a very misguided update, now i can't connect via my postgres client, and I can't run supabase migration up

The error is

failed to connect to postgres: failed to connect to `readacted`: server error (FATAL: Tenant or user not found (SQLSTATE XX000))


I noticed when i go to the connect UI in the supabase dashboard, the host is no longer an aws string, so I also tried updating to what shows there (which is a supabase url). When I try to connect to that url I get host not found

From what I can tell my applications and edge functions aren't having any problems connecting but obviously not ideal that I am now unable to connect to my db
Was this page helpful?