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
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 |