ankane / ankane/pgsync

Sync aborting due to server version mismatch

Open
#251 2 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Ruby
Stars
3.5k
Forks
219
PR merge metrics
No merged PRs in 30d

Description

Hi,

Any idea how can this issue be solved? Thanks

I'm using postgres:17.6-alpine and ankane/pgsync:latest docker images.

From: source_db on source-postgres:5432
To: target_db on target-postgres:5432
pg_dump: error: aborting because of server version mismatch
pg_dump: detail: server version: 17.6; pg_dump version: 16.10
pg_restore: error: input file is too short (read 0, expected 5)
Schema sync returned non-zero exit code

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the reported postgres:17.6-alpine and ankane/pgsync:latest images, then inspect how pg_dump and pg_restore are provided and invoked. Reproduce the sync and verify that the dump client version is compatible with the server so the schema sync completes without errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
docker, postgresql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.