# Pg\_dump client and server missmatch

**URL:** https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718
**Category:** Bugs
**Tags:** using-replit
**Created:** [February 3, 2025, 12:20pm UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718 "2025-02-03T12:20:21Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![jason392](https://avatars.discourse-cdn.com/v4/letter/j/5f9b8f/32.png) [@jason392](https://replit.discourse.group/u/jason392)
#### Post date: [February 3, 2025, 12:20pm UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718/1 "2025-02-03T12:20:21Z")

</div>

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:

```auto
~/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...

```

---

<div class="post-metadata">

### Author: ![chrisbarker3](https://avatars.discourse-cdn.com/v4/letter/c/9e8a1a/32.png) [@chrisbarker3](https://replit.discourse.group/u/chrisbarker3)
#### Post date: [April 7, 2025, 8:13am UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718/2 "2025-04-07T08:13:43Z")

</div>

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 😡

---

<div class="post-metadata">

### Author: ![nobita2041](https://yyz2.discourse-cdn.com/flex010/user_avatar/replit.discourse.group/nobita2041/32/157_2.png) [@nobita2041](https://replit.discourse.group/u/nobita2041)
#### Post date: [April 15, 2025, 2:00am UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718/3 "2025-04-15T02:00:09Z")

</div>

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.

```auto
~/workspace$ pg_dump --version
pg_dump (PostgreSQL) 17.1

```

 ![img-20250414-16.23.47@2x](https://canada1.discourse-cdn.com/flex010/uploads/replit/original/2X/6/6f8d55a3fcd391b2da93d48db7e2b55dcdaa050b.png)

---

<div class="post-metadata">

### Author: ![chrisbarker3](https://avatars.discourse-cdn.com/v4/letter/c/9e8a1a/32.png) [@chrisbarker3](https://replit.discourse.group/u/chrisbarker3)
#### Post date: [April 15, 2025, 5:23am UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718/4 "2025-04-15T05:23:57Z")

</div>

You LEGEND!  
Much appreciated 🙏

---

<div class="post-metadata">

### Author: ![denton1](https://yyz2.discourse-cdn.com/flex010/user_avatar/replit.discourse.group/denton1/32/2672_2.png) [@denton1](https://replit.discourse.group/u/denton1)
#### Post date: [April 25, 2025, 6:18pm UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718/5 "2025-04-25T18:18:05Z")

</div>

I second the legendary status. Thank you

---

<div class="post-metadata">

### Author: ![robemorata](https://avatars.discourse-cdn.com/v4/letter/r/9de0a6/32.png) [@robemorata](https://replit.discourse.group/u/robemorata)
#### Post date: [October 15, 2025, 12:19am UTC](https://replit.discourse.group/t/pg-dump-client-and-server-missmatch/2718/6 "2025-10-15T00:19:48Z")

</div>

Totally agree — legend! Thanks 🙏