pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to _not_ save startup options in postmaster.opts?
Date: Thu, 2 Nov 2023 14:31:51 -0500
Message-ID: <1943a772-3938-429b-a877-dafdcb854563@gmail.com> (raw)
In-Reply-To: <3134512.1698946957@sss.pgh.pa.us>
References: <89ffab7a-0dfe-42e5-ae9d-e2fff60c9762@gmail.com>
	<CAKFQuwYQNs6okw-tnkfUjZvmTSDMhsM4W0BVk8+kMb9Dr83KyQ@mail.gmail.com>
	<3134512.1698946957@sss.pgh.pa.us>

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.

view thread (6+ messages)

Message-ID: <1943a772-3938-429b-a877-dafdcb854563@gmail.com>
Permalink:  ../1943a772-3938-429b-a877-dafdcb854563@gmail.com/
Also on:    postgresql.org/message-id/1943a772-3938-429b-a877-dafdcb854563@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: How to _not_ save startup options in postmaster.opts?
  In-Reply-To: <1943a772-3938-429b-a877-dafdcb854563@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox