Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup

From: MaXinjian <machine_ok(at)163(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "missing chunk number 0 for toast value xxx in pg_toast_xxx" when pg_basebackup
Date: 2021-04-13 13:36:48
Message-ID: 1618321008208-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Why do you write the WAL to /tmp/pg_wal, only to later mount that at the
> default location?
pg_wal dir has size limitation, if wal files are too large, they will be
overwrited, right?

> I see nothing wrong with what you are doing, but I may have got lost in
> your complicated procedure.

> You don't happen to remove "backup_label", do you?
em, I do remove backup_label...

1. It means recovery.conf is not necessary, backup_label is necessary?
2. Which key in backup_label is necessary?
3. I searched the log, it do has recoveried.
Then, if there is no backup_label, what's the default START WAL LOCATION and
CHECKPOINT LOCATION?

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zhihong Yu 2021-04-13 14:07:52 Re: Have I found an interval arithmetic bug?
Previous Message Zwettler Markus (OIZ) 2021-04-13 13:07:55 AW: [Extern] Re: Advice on binary installation