Re: pg_basebackup not completing

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Somnath Som <somnath(dot)som(at)ericsson(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_basebackup not completing
Date: 2024-07-24 07:38:43
Message-ID: bafb5e06d0f9efaa4aa951824aaed1a751716c45.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Siraj G 2024-07-24 07:50:56 Re: Detect who ran DROP schema
Previous Message Laurenz Albe 2024-07-24 07:34:58 Re: Detect who ran DROP schema