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
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))
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
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
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.