Missing Database
I had a database disappear from Neon. I am not aware of anything that I did to remove. When I look at the dashboard, I have one branch and one compute as expected but only the development database. The database that I was using for my production instance does not appear on the dashboard and I can no longer access it using the connect string that worked earlier today. Does anyone know how I can get it back? Thanks.
6 Replies
fair-rose•8mo ago
Hey! Do you mind sharing the old connection string (without the password). You can also DM me if you prefer
foreign-sapphireOP•8mo ago
@Mahmoud The connect string is (was) postgresql://dev_owner:**@ep-summer-wood-a6l64das.us-west-2.aws.neon.tech/development?sslmode=require. My I try this connect sting with a SQL client -- I am using DBVisualizer, I get database not found. When I checked the Neon console, The won-site-app database is no longer listed in the Connection Details of the Neon Dashboard. Appreciate your looking into this for me. Thank you, Mahmoud,
fair-rose•8mo ago
Your situation is definitely an odd one. You could try restoring your database back to a previous state using the restore tab
This will bring back the database in case it was deleted
foreign-sapphireOP•8mo ago
Thank you for the suggestion, @Mahmoud. It looks like I can only go back 1 day with my plan so I've missed the window. I do have a backup I can usebut am concerned that this may occur again.
Thanks again.
fair-rose•8mo ago
No problem! You could create a readonly role when connecting to external tools
This would ensure that no delete operations can be run against your database
fair-rose•8mo ago
We have a docs guide https://neon.tech/docs/manage/database-access#create-a-read-only-role
Neon
Manage database access - Neon Docs
Each Neon project is created with a Postgres role that is named for your database. For example, if your database is named neondb, the project is created with a role named neondb_owner. This Postgres r...