Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peBSf-0003Y7-Kv for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Mar 2023 09:05:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peBSe-0000wv-34 for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Mar 2023 09:05:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peBSd-0000wl-Ph for pgsql-hackers@lists.postgresql.org; Mon, 20 Mar 2023 09:05:47 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1peBSb-0004pC-Jy for pgsql-hackers@lists.postgresql.org; Mon, 20 Mar 2023 09:05:47 +0000 Received: by mail-pj1-x1029.google.com with SMTP id p13-20020a17090a284d00b0023d2e945aebso13026704pjf.0 for ; Mon, 20 Mar 2023 02:05:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1679303144; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:from:to:cc:subject :date:message-id:reply-to; bh=2hAKGhHVajkKvAL0EkyaENNQKW57WTMD6dRRPEtKuDs=; b=L1ggJW8D4h3bKkMCyXWmdJ/xyS9D6abxCEW5n3LziYlcDFbjnKlwguNw7S7jqRTyCn 7MDAABda/86CxlqWDfTr0tSfQKaZ6dIuUols9gz9wy6+aFGotSB5tR1e2JEAUBNG1Nq7 +Nch+M1Mu7S/YuS70jT1+1PTDAYaWfJp41O3bBJ2qUrHbaqy4T0crHMIZRuhKJYBRFTn H8AIbAUB71yvFGth6bWfSjYmWD56o0dJ/ReoO02HziCF8/kdDhVpSOtZaAh6qAX+senE aN67oo5LDsZhXrE9hpSe25HY2XRz/8D0TdLwjihkV3Yu58qOLL9Z8o8sGXmwZQWdr9tM wWxg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679303144; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:from:subject:cc:to:message-id:date:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2hAKGhHVajkKvAL0EkyaENNQKW57WTMD6dRRPEtKuDs=; b=PvHe5GoVNxJULxX6Y3uV2cEhUV5JPCuZNQ4xUYb8zvvzgxxMTHcPJMvoO5EgPuQ8Mz 6Mm9Eu6Z5o4ZwwR1fbTKue68kGAIufBKIBzyY0aXuyLLzpVTgWmCqehoey1vuHCifIIU nRfs5CKirbUyHeElSrQS5ydh2RFGnOF/9WgAIYa+TYC/IU29HSQzy4q11DAkI95llm1r h0dk1wdP63n+Vb7rWJc+62pGnwNDaBbcN85+huLex5UlCjIWz5AzRhhJydqejgNcY2cK CEjU/VGova2kysGWE/iMsKNw0mHFMkFMYY7UyY5ibTsjzz0ZooCfAOR/jku96xpeq+aU BwTg== X-Gm-Message-State: AO0yUKWda0rmxTaDPbBu9afeTFEXNy4p3/jW/vIPntv3UWbsMj6tiSdm ds3nYN0ZQBrLQu86haC2JcI= X-Google-Smtp-Source: AK7set+VHdjtdMLI3pfsaYoLUwmHsPi+TcQCNbPD+9rKasPiy4DO572KDXSfT7f9ykt6IbRyIB7S+w== X-Received: by 2002:a17:902:d18a:b0:19e:8688:86fe with SMTP id m10-20020a170902d18a00b0019e868886femr14049719plb.42.1679303143628; Mon, 20 Mar 2023 02:05:43 -0700 (PDT) Received: from localhost (KD036014041111.ppp-bb.dion.ne.jp. [36.14.41.111]) by smtp.gmail.com with ESMTPSA id q20-20020a170902789400b0019a7363e752sm6165573pll.276.2023.03.20.02.05.42 (version=TLS1_3 cipher=TLS_CHACHA20_POLY1305_SHA256 bits=256/256); Mon, 20 Mar 2023 02:05:43 -0700 (PDT) Date: Mon, 20 Mar 2023 18:05:41 +0900 (JST) Message-Id: <20230320.180541.96678678678426257.horikyota.ntt@gmail.com> To: bharath.rupireddyforpostgres@gmail.com Cc: pgsql-hackers@lists.postgresql.org Subject: Re: Fix misplaced shared_preload_libraries_in_progress check in few extensions From: Kyotaro Horiguchi In-Reply-To: References: User-Agent: Mew version 6.8 on Emacs 26.1 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk At Sat, 18 Mar 2023 10:26:42 +0530, Bharath Rupireddy wrote in > Hi, > > I'm attaching a patch to do $subject in autoprewarm.c and worker_spi > extensions. The way it is right now doesn't hurt anyone, but why to > fail after defining custom GUCs if we aren't loading them via > shared_preload_libraries. > > Thoughts? I don't think they're misplaced at least for pg_prewram. pg_prewarm worker allows to be executed after startup and the variable is still used by such prewarm worker processes, but the patch make the variable stop working in that case. I didn't look at the part for worker_spi.c. regards. -- Kyotaro Horiguchi NTT Open Source Software Center