pg_dump reports error "aborting because of server version mismatch"
search cancel

pg_dump reports error "aborting because of server version mismatch"

book

Article ID: 296328

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

# pg_dump -a -t 'my_schema.table01' -f /data/backup/my_schema.table01.dat proddb pg_dump: server version: 9.4.24; pg_dump version: 8.2.15 pg_dump: aborting because of server version mismatch

Environment

Product Version: 6.4

Resolution

The pg_dump binary provided in the earlier versions of 6.x is based on the incorrect version of PostreSQL.
Upgrade to the latest 6.x supported version.

It is not possible to use pg_dump from Greenplum 5.x to backup Greenplum 6.x.
Need to use pg_dump provided with the Greenplum version running on the cluster.