PostgreSQL server and client versions

Feature Requests
1

I wonder if Replit’s PostgreSQL server and client versions could be aligned to use the same major version? This would be helpful since some users might want to copy their data to a separate NeonDB for production environments.

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...
1 Like
2

This is a bug and NOT a feature. You can’t dump you database and you can’t upgrade the pg_dump, 17.2 isn’t in the repo!

1 Like
3

You’re absolutely right.
I’m communicating this directly to the developer via X.
Fingers crossed they fix it.

By the way, neonDB can be connected from anywhere, so if you really want to pg_dump, you’ll have to run it from your local environment.

4

I thought I was going crazy. Any links where I can follow-up on this issue?