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 1oQygm-0007qb-D9 for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Aug 2022 22:17:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oQygl-00019U-05 for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Aug 2022 22:17:31 +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 1oQygk-00019K-N3 for pgsql-hackers@lists.postgresql.org; Wed, 24 Aug 2022 22:17:30 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oQygi-0008NH-54 for pgsql-hackers@postgresql.org; Wed, 24 Aug 2022 22:17:30 +0000 Received: by mail-pl1-x635.google.com with SMTP id y4so16897307plb.2 for ; Wed, 24 Aug 2022 15:17:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc; bh=AaCoSQdd9RGEBfRFQAR9ZKwtJ6HMk2TQnJsardYcw2Y=; b=BesKH3FdkXyr6SRo16CwCQWjHB7Jxu5/JXZ2S7KT52bHxLZTVeZ9JB19d2MYOvakgj 67sx9MkvO6qUGmqshqKpbAkxgQXIXRQILcfroZ8U+gZc8u1R6+Pb17oZXhxFCMM+ldDn NMGgSspxZrWcb249AX8CSukVnmvN2sZJ20n0+xHg2/SJNvUcZQiMkrqIUloB55ITwJzu LsyyGW5rmCRC4qJGV9NP4u/eNfqixfXcwrtUB/L8cijC4nAF6cwrvJMtKWjdNPBShL5d eYX0NAiBzK0zoNML9TnyzAcOH686uC3dUaBEcL9MvhKZEe/0LgzIf+4VjILcJPjBy6B9 J8Lg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc; bh=AaCoSQdd9RGEBfRFQAR9ZKwtJ6HMk2TQnJsardYcw2Y=; b=c3a+YenSiB4BmbGW/4kjfxLgg/UJsh2u4rfeTYRWTylk19d5rCy4ZnwgCQxju71e5X ed2R1dA/xIJ4Uz/4VZ4nq97VCT8SI1L2Ah/pcok9AFopW95h+xbEnnl1Sme1Ev5h6VhU P1I2Fm4B8j4blG+LDv+N7XO4iKDakiTWV39Uyl+7y01cdtpDJsmkcasOA9AqYSdmaJ9+ 8YWUF8As6FKjy8q047fNB9rkwcG94lNkb5rh2hf8kPhCXwzlOAx97j5zvpMBV8DhPIsA AisxYzZN/B1iMtJXhv+A9iZ4WxHtL7/V5I0P5INo/bHM+t1avwffnt1So+WlhjlHchR6 06Tw== X-Gm-Message-State: ACgBeo0o3EAZpI820KB53K2ZBTLTSQpWgeYJw9yVupb515E8/k+imIq4 hKaj9rGMIiURasJo0O5wQcE= X-Google-Smtp-Source: AA6agR4Hjo+5zmHIhHObH2pGSf6PHsYZRcPXsXk+Wfsm9VnI+MhbrGpVz7Xh7ni55ofR54/KIeiFtQ== X-Received: by 2002:a17:90b:388a:b0:1fb:7dea:c31e with SMTP id mu10-20020a17090b388a00b001fb7deac31emr1235878pjb.162.1661379446244; Wed, 24 Aug 2022 15:17:26 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id y3-20020aa79ae3000000b00535ebc6cd4bsm12689452pfp.218.2022.08.24.15.17.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Aug 2022 15:17:25 -0700 (PDT) Date: Wed, 24 Aug 2022 15:17:23 -0700 From: Nathan Bossart To: talk to ben Cc: Tom Lane , Alvaro Herrera , Robert Haas , "Bossart, Nathan" , David Steele , Fujii Masao , "pgsql-hackers@postgresql.org" , Michael Paquier , Magnus Hagander , Stephen Frost Subject: Re: archive modules Message-ID: <20220824221723.GA1347845@nathanxps13> References: <20220707151157.cakxxwwadchkov35@alvherre.pgsql> <2985823.1657208900@sss.pgh.pa.us> <20220707165908.GB2251016@nathanxps13> <20220823173930.GB1207981@nathanxps13> <727557.1661276860@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Aug 24, 2022 at 10:05:55AM +0200, talk to ben wrote: > This view does not display customized options > - until the extension module that defines them has been loaded. > + until the extension module that defines them has been loaded. Therefore, any > + option defined in a library that is dynamically loaded in a separate process > + will not be visible in the view, unless the module is manually loaded > + beforehand. This case applies for example to an archive module loaded by the > + archiver process. I would suggest something like: This view does not display customized options until the extension module that defines them has been loaded by the backend process executing the query (e.g., via shared_preload_libraries, the LOAD command, or a call to a user-defined C function). For example, since the archive_library is only loaded by the archiver process, this view will not display any customized options defined by archive modules unless special action is taken to load them into the backend process executing the query. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com