From: | KK CHN <kkchn(dot)in(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Pgbackrest fails due after an ISP change |
Date: | 2025-04-21 13:05:58 |
Message-ID: | CAKgGyB-JTZ3ShAyQNMqmc-y0u4=0PzbqCyoCgsJq=EZpSC3-ug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
List,
I am running a pgbackrest(2.52.1) backup setup for a postgres(16)
server(RHEL9.4) to a repo server RHEL 9.4..
The pgbackrest was working fine and the remote repo server got regular
backups through cron scheduler.
Suddenly there was an ISP change at our end, the VPN tunnel between DB
server and Repo server was lost for 24 hours due to VPN tunnel crash.
later I restored the VPN tunnel
After that the cron scheduler does not perform the pgbackrest backup. It
fails!!!
So I performed a full backup to overcome this .. But it fails with the
cron command ( 38 14 * * 1 pgbackrest --type=full --stanza=My_Repo
backup)
ERROR: [082]: WAL segment 000000010000022000000038 was not archived before
the 60000ms timeout
HINT: check the archive_command to
ensure that all options are correct (especially --stanza).
HINT: check the PostgreSQL server log
for errors.
HINT: run the 'start' command if the
stanza was previously stopped.
--------------------------------------------------------------------
If SUBMITTING AN ISSUE please provide
the following information:
version: 2.52.1
command: backup
options: --delta
--exec-id=492671-6f2068fc --log-level-console=info --log-level-file=debug
--pg1-host=10.x.y.202 --pg1-host-user=enterprisedb
--pg1-path=/data/edb/as16/data --pg-version-force=16 --process-max=5
--repo1-block --repo1-bundle --repo1-cipher-pass=<redacted>
--repo1-cipher-type=aes-256-cbc --repo1-path=/DBBACKUP
--repo1-retention-diff=3 --repo1-retention-full=3 --stanza=KTA_Repo
--start-fast --type=full
2025-04-21 14:39:07.335 P00 INFO: backup command end: aborted with
exception [082]
2025-04-21 14:39:07.335 P00 DEBUG: command/exit::exitSafe: => 82
2025-04-21 14:39:07.936 P00 DEBUG: main::main: => 82
How can I make the full backup command not to check the WAL was archived
or not to the repo server for atleast once ?
Any hint appreciated ..
Thanks
Krishane
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2025-04-21 15:43:11 | Re: Order of update |
Previous Message | Peter J. Holzer | 2025-04-21 08:47:17 | Re: Order of update |