Error trying to populate database from a local .sql file
I recently cloned a database locally using the pg_dump command, the file being around 12G.
I'm trying to populate this data onto my neon database using the psql command
psql <connection string> < database-dump.sql
However I keep getting the error while its in the proccess of completing.
How is this typically handled? What can I do to get this to work?5 Replies
sunny-green•17mo ago
@Pascal are you on the free tier? Check your storage utilization stats in the Neon console at https://console.neon.tech you may have exhausted the 0.5GB storage alotment in the free tier.
eastern-cyanOP•17mo ago
I’m on the launch tier
Do I need to upgrade to scale? @andyhats
sunny-green•17mo ago
No
Once you are on the paid tiers, the limit to storage is ~2TB
If you haven't already, open a ticket so our support team can look into your specific issue.
@Rishi Raj Jain has worked on a bunch of import/export stuff recently, Rishi have you ever encountered this?
eastern-cyanOP•17mo ago
Where do I open tickets? Could you point me to where?
sunny-green•17mo ago
Since you're on a paid tier, you should be able to create a ticket in the console here https://console.neon.tech/app/projects?modal=support
I see your ticket submitted - will make sure it gets escalated. thanks