pg_dump server version mismatch #149
Comments
|
It seems like the docker image contains pg_dump version from Postgres 13.8. Try building a docker image with a version that matches your production environment, apparently 14.5. I suppose you will need your own Dockerfile for that. |
arajkumar
added a commit
to arajkumar/pgcopydb
that referenced
this issue
Jul 26, 2024
…fix (dimitri#149) Prior to this change, we use hypertable id and default prefix(_hyper) to find the hypertable relation from the chunk. This will not work when the hypertables are created with custom schema and custom chunk prefix. e.g. ``` SELECT create_hypertable('metrics', 'time', associated_schema_name=> 'foo', associated_table_prefix=>'metrics'); ``` The new implementation builds mapping hash table with the results from following query, ``` "SELECT " " schema_name, table_name, " " associated_schema_name, associated_table_prefix " "FROM " " _timescaledb_catalog.hypertable"; ``` The key for the hash table is `associated_schema_name + associated_table_prefix` and the value is hypertable schema and table name. When we get DML on chunk, associated_schema_name and associated_table_prefix will be used to find the respective hypertable relation. Fixes timescale/team-data-onboarding#151 Related to timescale/timescaledb#6972 Signed-off-by: Arunprasad Rajkumar <ar.arunprasad@gmail.com>
arajkumar
added a commit
to arajkumar/pgcopydb
that referenced
this issue
Jul 31, 2024
0b57967 Fix issues with tsdb 2.13.x migration dimitri#152 0b57967 Ask user not to close/interrupt snapshot terminal (dimitri#151) 26fa73a Implement cross version TS to TS migration (dimitri#147) 58ed2a6 Refactor matview rename handling (dimitri#145) ddb8d8e Support chunk mapping for hypertable with custom schema and table prefix (dimitri#149) f28665d Set application name to all psql sessions (dimitri#146) fc29786 Upgrade test-common and other dependencies (dimitri#148) 209812c Recommend using docker run with –user CLI flag (dimitri#144) 5395420 Fail fast when initial data copy fails (dimitri#143) f1f0398 feat: implement retry for initial data migration (dimitri#137) 10da671 Use pgcopydb for PG to TS initial data copy (dimitri#120) c9cfa08 Exit with error code on failure (dimitri#142) Signed-off-by: Arunprasad Rajkumar <ar.arunprasad@gmail.com>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi, this seems a great tool, tried to use it with the default docker command and had trouble.
19:12:03 15 ERROR pg_dump: error: server version: 14.5; pg_dump version: 13.8 (Debian 13.8-0+deb11u1)
19:12:03 15 ERROR pg_dump: error: aborting because of server version mismatch
19:12:03 15 ERROR Failed to run pg_dump: exit code 1
19:12:03 15 ERROR Failed to clone source database, see above for details
19:12:03 1 ERROR clone process 15 has terminated [6]
19:12:03 1 WARN Failed to clone the source database, see above for details
19:12:03 1 FATAL Terminating all processes in our process group
Can you help me with the issue?
The text was updated successfully, but these errors were encountered: