Re: pg_basebackup not completing - Mailing list pgsql-admin
On Wed, Jul 24, 2024 at 1:55 AM Somnath Som <somnath.som@ericsson.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
Attachment
pgsql-admin by date: