You CANNOT export your database at the moment. There is a missmatch between server and neon db. This is a major issue as 17.2 is not in the replit repo. AND NO I don’t want to use the database panel - my data, my access I want my raw sql in a way that I can transport it - not locked up.
Currently, we’re seeing a version mismatch:
- Server version: 17.2
- pg_dump version: 16.5
When trying to dump the database:
~/workspace$ pg_dump $DATABASE_URL > dump.sql
pg_dump: error: aborting because of server version mismatch
pg_dump: detail: server version: 17.2; pg_dump version: 16.5
Environment updated. Reloading shell...
Bumping this to the top. It’s SERIOUS, yet trivial to solve! I had to start a new db and import the old. It cost me a FULL DAY, all cos pg-dump couldn’t work. The final solution was CSV, record by record, with much management of the complex characters i had in very large text fields, all followed by per field verification. With pg-dump this could have been done in 2 minutes 
I found a workaround for this issue.
In the Dependencies tab, you can install PostgreSQL Tools 17 by selecting System (Advanced), then Modules, and choosing “PostgreSQL Tools 17”.
This gives you pg_dump 17.1, which is compatible with PostgreSQL 17.2 servers.
~/workspace$ pg_dump --version
pg_dump (PostgreSQL) 17.1
1 Like
You LEGEND!
Much appreciated 
1 Like
I second the legendary status. Thank you
1 Like
Totally agree — legend! Thanks
