pg_rewind fails with in-place tablespace

From: 赵锐(惜元) <xiyuan(dot)zr(at)alibaba-inc(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: pg_rewind fails with in-place tablespace
Date: 2023-07-19 13:31:35
Message-ID: 2b79d2a8-b2d5-4bd7-a15b-31e485100980.xiyuan.zr@alibaba-inc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello postgres hackers,
Recently I encountered an issue: pg_rewind fails when dealing with in-place tablespace. The problem seems to be that pg_rewind is treating in-place tablespace as symbolic link, while in fact it should be treated as directory.
Here is the output of pg_rewind:
pg_rewind: error: file "pg_tblspc/16385" is of different type in source and target
To help reproduce the failure, I have attached a tap test. And I am pleased to say that I have also identified a solution for this problem, which I have included in the patch.
Thank you for your attention to this matter.
Best regards,
Rui Zhao

Attachment Content-Type Size
0001-pg_rewind-fails-with-in-place-tablespace.patch application/octet-stream 1.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dmitry Koval 2023-07-19 13:43:47 Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Previous Message Amit Kapila 2023-07-19 13:19:57 Re: Report distinct wait events when waiting for WAL "operation"