Hi there, I’ve lost my database because of a Neon end point issue. How can I restore my data??? So annoying.
completely ruined my presentation today on benchmark data across 101 users…@kody-replit - can you help me?
Is it just in the toolbar tab the connection looks broken or did the env variables change? what happens if you run: echo $DATABASE_URL in the Shell tool?
If its the connect and not the environment variables, you could probably re-connect by running that command for each variable and adding it back under database settings.
p.s - i have no idea what youre talking about with your suggestions above
If you go to the Shell tool, can add where that “+” sign is next to your tabs where you have Database and Git open in your other screenshot. What happens if you type: echo $DATABASE_URL
Ok so that suggests that the database environment variables are still in your Replit environment. I was suggesting that if you run the commands to pull those variables you could update them manually in the Database settings and then the tab would should your database. So after clicking “Create a database manually” in the database tab, you would go to Settings and at the bottom, update each variable with the results of the Shell command for each pull. Again, hasn’t happened to me so I don’t know if this would work, but this is what I would try if it did happen to me. Others might have had this experience may know better.
Shell Commands for each:
echo “DATABASE_URL: $DATABASE_URL”
echo “PGDATABASE: $PGDATABASE”
echo “PGHOST: $PGHOST”
echo “PGPORT: $PGPORT”
echo “PGUSER: $PGUSER”
echo “PGPASSWORD: $PGPASSWORD”
ok, so should i just type that into Shell? Or do i create a database manually and then type that in? I’ve also got Replit technician supposed to call me soon. Thank you so much for your help. I was worried that if i created a database manually that it would override my existing database?
If you have a tech from Replit calling I would follow their directions. And also let the group know where what advice they gave for when this happens to others.
For what I sent: 1) I would run the Shell commands first and copy the values for each variable first somewhere else (in case of overwrite) 2) Then I would start the new configuration once I have the variable values contained somewhere safe
1 Like
There are situations (annoying as they are) when the database UI disappears or the environment variables no longer appear in your app. I have experienced this when I fork an app. In both of these cases the database still exists but the app’s connection to the database was broken. Re-entering the required environment variables as @pmz described reconnected the database to allow the app to work properly but it still may render the Neon UI in accessible.
Hi there!
What ever happened with your issue? I had this same error last night and restored and now it is happening again today. I do not want to restore to an earlier point now and loose the progress from yesterday…
I was able to echo the database URL and confirm it is still there so I guess I will check the other variables.
