gprestore hangs when restoring backups which are compressed with zstd

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

If a backup is taken gpbackup option "--compression-type zstd", when the backup is restored it may hang when copying the data into the table.

The pg_stat_activity will show the COPY command like:

COPY schema.table01(a,b,c) FROM PROGRAM 'zstd --decompress -c <SEG_DATA_DIR>/backups/20250818/20250818105222/gpbackup_<SEGID>_20250818105222_1660157.zst' WITH CSV DELIMITER ',' ON SEGMENT;

 

Cause

The COPY command uses "zstd" to uncompress the file, but this command will print a progress bar and other messages which can cause the restore to hang.

Resolution

The issue was introduced in 1.31.2.

As of August 2025, R&D are working on a fix.

As a workaround, downgrade gpbackup/gprestore package to 1.30.x to avoid the issue.