Re: pg_rewind fails on Windows where tablespaces are used

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Alexandra Wang <alexandra(dot)wang(dot)oss(at)gmail(dot)com>, Chris Travers <chris(dot)travers(at)stormatics(dot)tech>, Farooq Rashed <farooq(dot)rashed(at)desc(dot)gov(dot)ae>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_rewind fails on Windows where tablespaces are used
Date: 2025-01-18 14:37:07
Message-ID: 5941a940-f83f-4f7e-ba6c-566978861ac4@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


On 2025-01-14 Tu 4:12 PM, Andrew Dunstan wrote:
>
> On 2025-01-08 We 10:38 PM, Thomas Munro wrote:
>> On Thu, Jan 9, 2025 at 3:45 AM Andrew Dunstan <andrew(at)dunslane(dot)net>
>> wrote:
>>> Those patches didn't actually include any tests. I guess the best test
>>> would be to create a chain of several junction points and then run
>>> initdb on the leaf of the chain?
>> Yeah I think the three interesting cases were initdb when run under
>> junctions like these:
>>
>> 1.  Volume GUID format: mklink /J foo \\?\Volume{12341234-1234...},
>> expected to break without patch
>> 2.  Chain: mklink /J C:\\aaa1 C:\\aaa2, mkdir /J C:\\aaa2 c:\\aaa3,
>> expected to break without patch
>> 3.  Chain of length > 8, expected to fail with ELOOP once the patch
>> is applied.
>>
>> (Syntax may be off, I just googled it but don't have Windows to try).
>>
>> The way to get decent tests for this stuff and all the rest of the
>> wrappers would probably be to develop this test suite further:
>>
>> https://www.postgresql.org/message-id/flat/CA%2BhUKG%2BajSQ_8eu2AogTncOnZ5me2D-Cn66iN_-wZnRjLN%2Bicg%40mail.gmail.com
>>
>
>
>
> I can confirm that these two patches apply cleanly to releases 13 ..
> 15, that builds are also clean, and that tests 1..3 above pass/fail as
> expected. Tested on a WS2019 instance.
>
>
>

I have pushed the backpatch of these two patches into release 13 .. 15.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zhang Mingli 2025-01-18 15:52:01 Re: BUG #18778: Query planning fails in ExecInitExprRec with unrecognized node type
Previous Message PG Bug reporting form 2025-01-17 11:36:06 BUG #18779: Segmentation fault while trying to connect via psql