Re: pg_basebackup not completing

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: pg_basebackup not completing
Дата
Msg-id CANzqJaC7o7cj_mJEBT_3V7-7OfTaBKJa++Wb6D=ZtimLBCjk0Q@mail.gmail.com
обсуждение исходный текст
Ответ на pg_basebackup not completing  (Somnath Som <somnath.som@ericsson.com>)
Список 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

Вложения

В списке pgsql-admin по дате отправления: