Re: pg_basebackup not completing

On Wed, Jul 24, 2024 at 1:55 AM Somnath Som <somnath(dot)som(at)ericsson(dot)com>
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
>
>
>
>
>

Following up on Laurenz's post: *always* check return codes.
My scripts, for example, are peppered with:
declare -i RC
pg_blah ....
RC=$? ; if (( $RC != 0 )); then date +"%F %T Blah failed with error
code=$RC. Exiting script."; exit 6; fi