Re: pg_upgrade: Make testing different transfer modes easier - Mailing list pgsql-hackers

From Kyotaro Horiguchi
Subject Re: pg_upgrade: Make testing different transfer modes easier
Date
Msg-id 20221202.095650.413092142832173887.horikyota.ntt@gmail.com
Whole thread Raw
In response to pg_upgrade: Make testing different transfer modes easier  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: pg_upgrade: Make testing different transfer modes easier
List pgsql-hackers
At Thu, 1 Dec 2022 16:18:21 +0100, Peter Eisentraut <peter.eisentraut@enterprisedb.com> wrote in 
> I wanted to test the different pg_upgrade transfer modes (--link,
> --clone), but that was not that easy, because there is more than one
> place in the test script you have to find and manually change.  So I
> wrote a little patch to make that easier.  It's still manual, but it's
> a start.  (In principle, we could automatically run the tests with
> each supported mode in a loop, but that would be very slow.)
> 
> While doing that, I also found it strange that the default transfer
> mode (referred to as "copy" internally) did not have any external
> representation, so it is awkward to refer to it in text, and obscure
> to see where it is used for example in those test scripts.  So I added
> an option --copy, which effectively does nothing, but it's not
> uncommon to have options that select default behaviors explicitly.  (I

I don't have a clear idea of wheter it is common or not, but I suppose many such commands allow to choose the default
behaviorby a configuration file or an environment variable, etc. But I don't mind the command had the effetively nop
optiononly for completeness.
 

> also thought about something like a "mode" option with an argument,
> but given that we already have --link and --clone, this seemed the
> most sensible.)
> 
> Thoughts?

When I read up to the point of the --copy option, what came to my mind
was the --mode=<blah> option.  IMHO, if I was going to add an option
to choose the copy behavior, I would add --mode option instead, like
pg_ctl does, as it implicitly signals that the suboptions are mutually
exclusive.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Avoid LWLockWaitForVar() for currently held WAL insertion lock in WaitXLogInsertionsToFinish()
Next
From: Tom Lane
Date:
Subject: Re: Using AF_UNIX sockets always for tests on Windows