Replit and Neon
I use replit and have a database set up there. I just hat the case that my whole database was empty. Luckily with a rollback I could also restore the database. BUT: This database restore feature used to not work a week ago or so... so in this case I would have now lost all my data. That is very scary. So now my question is: Is there a way to "access" my database from Replit in the neon app? And somehow save it in other places too? What would you suggest?
4 Replies
suitable-rose•2mo ago
Hey! Because Replit provisions you a Neon database from their own org, you can't access it in the Neon console. Because you have the connecting string from the Replit dashboard, you are able to do do backups using pg_dump :
https://neon.com/docs/manage/backup-pg-dump
Just make sure that you arent using the non-pooled connection string when pg_dump-ing
Neon
Backups with pg_dump - Neon Docs
This topic describes how to create a backup of your Neon database using the Postgres pg_dump utility and how to restore a backup using pg_restore. Avoid using pg_dump over a pooled connection string (...
suitable-rose•5w ago
Following up, I made a typo there. Make sure you ARE using the non-pooled connection string. Sorry if I caused any confusion!
foreign-sapphire•22h ago
Sam I am also concerned woke up to empty database that still hasn’t been recovered need options to store it other places than replit. This is a mission critical need. Replit cannot be trusted to not willy-nilly delete databases
suitable-rose•16h ago