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:27:48 -0500
Message-ID: <16b8d553-b18c-40ee-8cbc-7eed208c1474@gmail.com> (raw)
In-Reply-To: <CAKFQuwYQNs6okw-tnkfUjZvmTSDMhsM4W0BVk8+kMb9Dr83KyQ@mail.gmail.com>
References: <89ffab7a-0dfe-42e5-ae9d-e2fff60c9762@gmail.com>
<CAKFQuwYQNs6okw-tnkfUjZvmTSDMhsM4W0BVk8+kMb9Dr83KyQ@mail.gmail.com>
On 11/2/23 12:24, David G. Johnston wrote:
>
> 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 doesn’t
> remember anything in any real sense because it isn’t used by the system to
> determine what those parameter values should be during startup.
https://pgpedia.info/p/postmaster.opts.html
"*|postmaster.opts|*is a file in the data directory written after startup
which contains the options used to start the postmaster process. The
contents of|postmaster.opts|are used to ensure the postmaster process can be
restarted with the same options with which it was originally started."
I've confirmed this behavior, which I why I wrote the email.
>
> Use the -c functionality for your manual maintenance boots and just let
> the normal startup mechanism do whatever it does when you re-engage it.
>
> David J.
>
--
Born in Arizona, moved to Babylonia.
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: <16b8d553-b18c-40ee-8cbc-7eed208c1474@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