From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Somnath Som <somnath.som@ericsson.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_basebackup not completing
Date: Wed, 24 Jul 2024 09:38:43 +0200
Message-ID: <bafb5e06d0f9efaa4aa951824aaed1a751716c45.camel@cybertec.at> (raw)
In-Reply-To: <PAXPR07MB8338019EFF3ADCC204A07B0294AA2@PAXPR07MB8338.eurprd07.prod.outlook.com>
References: <PAXPR07MB8338019EFF3ADCC204A07B0294AA2@PAXPR07MB8338.eurprd07.prod.outlook.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, somnath.som@ericsson.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_basebackup not completing
In-Reply-To: <bafb5e06d0f9efaa4aa951824aaed1a751716c45.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox