pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_basebackup not completing
4+ messages / 4 participants
[nested] [flat]
* pg_basebackup not completing
@ 2024-07-24 05:55 Somnath Som <somnath.som@ericsson.com>
0 siblings, 3 replies; 4+ messages in thread
From: Somnath Som @ 2024-07-24 05:55 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
[cid:image001.png@01DADDBC.22742C80]
Attachments:
[image/png] image001.png (17.8K, ../../PAXPR07MB8338019EFF3ADCC204A07B0294AA2@PAXPR07MB8338.eurprd07.prod.outlook.com/3-image001.png)
download | view image
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_basebackup not completing
@ 2024-07-24 06:02 obi reddy <obireddy.g1997@gmail.com>
parent: Somnath Som <somnath.som@ericsson.com>
2 siblings, 0 replies; 4+ messages in thread
From: obi reddy @ 2024-07-24 06:02 UTC (permalink / raw)
To: Somnath Som <somnath.som@ericsson.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi somnath,
Are you getting any error?
Thanks
Obireddy
On Wed, 24 Jul 2024, 11:25 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
>
>
>
>
>
>
>
Attachments:
[image/png] image001.png (17.8K, ../../CAO7L2ZzUWyCtej3-HxsO2u75t=ssLg2Zpb3pb3HapoLSirb3ow@mail.gmail.com/3-image001.png)
download | view image
[image/png] image001.png (17.8K, ../../CAO7L2ZzUWyCtej3-HxsO2u75t=ssLg2Zpb3pb3HapoLSirb3ow@mail.gmail.com/4-image001.png)
download | view image
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_basebackup not completing
@ 2024-07-24 07:38 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Somnath Som <somnath.som@ericsson.com>
2 siblings, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2024-07-24 07:38 UTC (permalink / raw)
To: Somnath Som <somnath.som@ericsson.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_basebackup not completing
@ 2024-07-24 12:32 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Somnath Som <somnath.som@ericsson.com>
2 siblings, 0 replies; 4+ messages in thread
From: Ron Johnson @ 2024-07-24 12:32 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
Attachments:
[image/png] image001.png (17.8K, ../../CANzqJaC7o7cj_mJEBT_3V7-7OfTaBKJa++Wb6D=ZtimLBCjk0Q@mail.gmail.com/3-image001.png)
download | view image
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-07-24 12:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-24 05:55 pg_basebackup not completing Somnath Som <somnath.som@ericsson.com>
2024-07-24 06:02 ` obi reddy <obireddy.g1997@gmail.com>
2024-07-24 07:38 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-07-24 12:32 ` Ron Johnson <ronljohnsonjr@gmail.com>
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