On Wed, 2024-07-24 at 05:55 +0000, Somnath Som wrote: > DB Size 114GB, when running to pg_basebackup then its stuck in 99%, full backup is not completing. > Postgres Version: 12.16 > > Backup Script: pg_basebackup -h $PGHOST -p $PGPORT -U $PGUSER -D $BACKUP_DIR/pgbase_$(date "+%d.%m.%Y-%H%M%S") -Ft -z -Xs -P >> $LOG_FILE 2>&1 > > [image showing pg_basebackup at 99%, immediately followed by a shell prompt] The image looks like pg_basebackup completed successfully. Perhaps the display didn't count up to 100. There is no error message and no sign that the command was interrupted. Look at the return code right after the command: echo $? If that is 0, you can be sure that the backup was successful. Yours, Laurenz Albe
