Re: pgsql: Fix pg_basebackup with in-place tablespaces. - Mailing list pgsql-committers

From David Steele
Subject Re: pgsql: Fix pg_basebackup with in-place tablespaces.
Date
Msg-id 8893318e-5778-ebf4-71b0-afb210d71a52@pgmasters.net
Whole thread Raw
In response to Re: pgsql: Fix pg_basebackup with in-place tablespaces.  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: pgsql: Fix pg_basebackup with in-place tablespaces.  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-committers
On 3/15/22 23:42, Kyotaro Horiguchi wrote:
> At Wed, 16 Mar 2022 11:13:53 +1300, Thomas Munro <thomas.munro@gmail.com> wrote in
>> On Wed, Mar 16, 2022 at 10:28 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> David Steele <david@pgmasters.net> writes:
>>>> On 3/14/22 19:31, Thomas Munro wrote:
>>>>> Fix pg_basebackup with in-place tablespaces.
>>>
>>>> Perhaps I'm being picky, but seems like this logic should be wrapped in:
>>>> if (allow_in_place_tablespaces)
>>>> {
>>>>       <...>
>>>> }
>>>> I worry about strange effects when this GUC is not enabled.
>>>
>>> What would happen if someone created an in-place tablespace and
>>> then turned off the GUC?
>>
>> Then it would break with unhelpful error messages.  I suppose we could
>> error out explicitly, "in-place tablespace detected, but
>> allow_in_place_tablespaces not enabled".  I'm not sure why we should
>> suddenly choose to enforce that *here* though.
> 
> +1. The GUC is only to prevent non-developer users from accidentally
> creating in-place tablespaces that is not officieally suported.  We
> have done nothing about in-place tablespaces other than the things
> needed to perform regression test, and I think we won't do that in
> future.

Sure, but there is a behavioral change whether the GUC is enabled or 
not. Before, if there was clutter in pg_tblspc there would at least be a 
warning in the log. Now that logging does not happen.

It seems that the warning at line 8313 is essentially dead code now. I 
don't expect test code to have an impact on production systems, even if 
the effect is minor.

I'm less worried about what happens when the flag is flipped on then off 
because that's not likely to happen in production.

Regards,
-David



pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgsql: Allow extensions to add new backup targets.
Next
From: Justin Pryzby
Date:
Subject: Re: pgsql: Allow extensions to add new backup targets.