gpbackup and gprestore hang when run in the background.

Products

• VMware Tanzu Greenplum
• Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

gpbackup and gprestore can get hung when run in the background. For example:

gprestore --timestamp 20240111170350 --create-db > out &
[1] 94024
$ 
[1]+  Stopped                 gprestore --timestamp 20240111170350 --create-db > out

The backup or restore will not progress until it is brought to the foreground:

$ fg %1
gprestore --timestamp 20240111170350 --create-db > out
  :
  :

The issue was introduced in version 1.30.0 of the gpbackup package

Environment

Greenplum Backup and Restore v 1.30.0

 

Resolution

Workaround

Use the "--verbose" option to allow it to run in the background. For example:

$ gprestore --verbose --timestamp 20240111170350 --create-db > out &

Fix

The issue has been resolved in version 1.30.4 and above.