Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qydQ7-009pue-Uy for pgsql-admin@arkaria.postgresql.org; Thu, 02 Nov 2023 19:31:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qydQ5-00F10n-Ib for pgsql-admin@arkaria.postgresql.org; Thu, 02 Nov 2023 19:31:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qydQ5-00F10d-7d for pgsql-admin@lists.postgresql.org; Thu, 02 Nov 2023 19:31:57 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qydQ2-004NDx-EI for pgsql-admin@lists.postgresql.org; Thu, 02 Nov 2023 19:31:56 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-5a87ac9d245so16104047b3.3 for ; Thu, 02 Nov 2023 12:31:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698953512; x=1699558312; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=7MPnl3DCj12K2XQCFY+871BjZ2j5phJP+v5D9P5+n4I=; b=TSFsfJc4JRSRjLXPsz5N/ekSPIo5/priPeIZaGuSMPRCZ65wnt0cW19odI8UIso02J lHi2sV2/FfXZV9w9aJaRqa3HpXQ3+ycz98nUOOuCMqct62FlXxN5jgpKSXgW3TPDW9uc w9+481rrEwX5bbav4yfrG/zCJuVWq39MZuBefx6PrIHr2fFNe/l9jJFh0R6djvQPquPp 02+xj3+xeSrEcH1Q1qOdDJCacpAVBxlNLqXwc9yoAy6pAkSToBDhMTYl1OjfOil4HKpQ PiE1o76W8K7KL5Q62fbNyNu/jblmnLl6iNdvck/YyU0mDOP+PyrTd343ZAk7do1ZKROj Xr9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698953512; x=1699558312; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=7MPnl3DCj12K2XQCFY+871BjZ2j5phJP+v5D9P5+n4I=; b=SvwqCKUAKLDkzpH5dESxNygs3xSksyHA702kKDye4Dx5nMMnCMN+iXLcZFKqnRZ8Rj 2jzEqJL06189VKvs242m6PFZRALFeM98qcqlcZ4798MkoKS+oa5doKoP+wvkwh9Fn5Gt TARRE7EpNfLWV4XsfBoaeUD3Blvg7uDmkAtwXv9YD/qDLHDZVtJ1yBjCzF6JyJ1kWHNi 1KmowZwHieksS3HL62R+tVu+f4OIp6C7L1VrAIhhYtCS4ctUIQhKF1AwBsaSxEXTl57d YN08+34s0marPog8NIoYXfdfoEz68MqU0w01AO6RAdXlQmFW+NgHX+c4QYirTlFrPWPF RQLQ== X-Gm-Message-State: AOJu0Yyqes/2GTCsmLT/6u082ZOU8/Og4KL/GatcvQtYypj57oiHXQnR m/UituREvcLOLxYTCHSoNw/Z+3a1+10= X-Google-Smtp-Source: AGHT+IE/zGmmPy+iNad08j8tt8IfOYQ+bLwptaN0wlaEX6TbDdLbABd7fg/aCEyUfTtgHFjIfaoF7Q== X-Received: by 2002:a81:494c:0:b0:5a8:7cb2:15d0 with SMTP id w73-20020a81494c000000b005a87cb215d0mr711027ywa.11.1698953512467; Thu, 02 Nov 2023 12:31:52 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44]) by smtp.googlemail.com with ESMTPSA id m133-20020a0dca8b000000b0059beb468cb4sm105036ywd.1.2023.11.02.12.31.52 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 02 Nov 2023 12:31:52 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------0Q3tllDjAP9CKw0oGuIbCoNd" Message-ID: <1943a772-3938-429b-a877-dafdcb854563@gmail.com> Date: Thu, 2 Nov 2023 14:31:51 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: How to _not_ save startup options in postmaster.opts? Content-Language: en-US To: Pgsql-admin References: <89ffab7a-0dfe-42e5-ae9d-e2fff60c9762@gmail.com> <3134512.1698946957@sss.pgh.pa.us> From: Ron In-Reply-To: <3134512.1698946957@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------0Q3tllDjAP9CKw0oGuIbCoNd Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 11/2/23 12:42, Tom Lane wrote: > "David G. Johnston" writes: >>> Alas, those config values are remembered in postmaster.opts. But I don't >>> want that. >> I don’t know where this file is even documented ATM but my understanding is >> it just shows you the values used during the last startup. > It does more, per the pg_ctl man page: > > postmaster.opts > > If this file exists in the data directory, pg_ctl (in restart > mode) will pass the contents of the file as options to postgres, > unless overridden by the -o option. The contents of this file are > also displayed in status mode. > > It seems totally reasonable for "pg_ctl restart" to re-apply those > switches. If you don't want that, don't use "restart", but stop > and start. Thanks. -- Born in Arizona, moved to Babylonia. --------------0Q3tllDjAP9CKw0oGuIbCoNd Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 11/2/23 12:42, Tom Lane wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:

Alas, those config values are remembered in postmaster.opts.  But I don't
want that.


      

        
I don’t know where this file is even documented ATM but my understanding is
it just shows you the values used during the last startup.


      

      
It does more, per the pg_ctl man page:

    postmaster.opts

        If this file exists in the data directory, pg_ctl (in restart
        mode) will pass the contents of the file as options to postgres,
        unless overridden by the -o option. The contents of this file are
        also displayed in status mode.

It seems totally reasonable for "pg_ctl restart" to re-apply those
switches.  If you don't want that, don't use "restart", but stop
and start.


    

    

    Thanks.

    

    
-- 

      Born in Arizona, moved to Babylonia.

  


--------------0Q3tllDjAP9CKw0oGuIbCoNd--