| From: | Sushil Shirodkar <sushilps(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re. Backup |
| Date: | 2023-08-03 17:20:43 |
| Message-ID: | PH7PR10MB6225BB0156769A0E7B9C945AD408A@PH7PR10MB6225.namprd10.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello Friends,
Looking for some help/input regarding backup issue we are having.
Env : PG => 12.11
Ubuntu => 20.04.4
We take regular backup along with WALs everyday no issues, but one day of
the week regularly backup fails with the following error.
ERROR: requested WAL segment 0000000C000008A10000000B has already been removed
We know the reason there is heavy database activity going during this period. But
trying to avoid addition of more WAL files, is there any way to modify our backup
command below which will take just the snapshot and not worry about the WALs?
playing with diff. options but no luck.
pg_basebackup -h ${MASTER_TCP_ADDRESS} -U ${REP_USER} -D ${BACKUP_DIR} -X fetch -Ft -zPw >>$LOG
Thanks in advance,
Sushil...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Hammerman | 2023-08-03 17:54:36 | Instrumenting stale replication slots |
| Previous Message | richard coleman | 2023-08-03 16:16:14 | Re: analyze foreign tables |