From: Sacha Kerres <skerres@kerres-edv.de>
To: 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 17:39:16 +0000
Message-ID: <0001D1F9.6543ECD4@10.20.80.201> (raw)
Hi,
https://www.postgresql.org/docs/16/config-setting.html
postgres -c log_connections=yes -c log_destination='syslog'
or
export PGOPTIONS="-c geqo=off -c statement_timeout=5min"
Mit freundlichen Grüßen
Sacha Kerres
Kerres-EDV Beratung
Deglhof 45-47
93142 Maxhütte-Haidhof
Tel. +49 9471 60 14 14
Mobil. +49 171 210 48 46
E-Mail. skerres@kerres-edv.de
Original Message processed by david®
How to _not_ save startup options in postmaster.opts? 2. November 2023, 18:01 Uhr
Von Ron
An Pgsql-admin
Pg 14, if it matters.
When doing maintenance (including a giant pg_restore), sometime one wants to run with different configuration values (like archivemode=off, wal_level=minimal, autovacuum=off, etc).
I could edit postgresql.conf -- or have two of them: one normal, and one for doing maintenance -- but if I'm going to restart anyway, why not just pass those parameters directly to the postmaster?
Alas, those config values are remembered in postmaster.opts. But I don't want that.
Thus: is there a way to tell pg to not put those options in postmaster.opts?
Or is this my only option before restarting for production:
which postgres > $PGDATA/postmaster.opts
--
Born in Arizona, moved to Babylonia.
To: ronljohnsonjr@gmail.com
pgsql-admin@lists.postgresql.org
Attachments:
[application/x-pkcs7-signature] smime.p7s (4.4K, ../0001D1F9.6543ECD4@10.20.80.201/3-smime.p7s)
download
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: skerres@kerres-edv.de, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to _not_ save startup options in postmaster.opts?
In-Reply-To: <0001D1F9.6543ECD4@10.20.80.201>
* 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