From: | "Sacha Kerres" <skerres(at)kerres-edv(dot)de> |
---|---|
To: | "Ron" <ronljohnsonjr(at)gmail(dot)com>, "Pgsql-admin" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: How to _not_ save startup options in postmaster.opts? |
Date: | 2023-11-02 17:39:16 |
Message-ID: | 0001D1F9.6543ECD4@10.20.80.201 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)kerres-edv(dot)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(at)gmail(dot)com
pgsql-admin(at)lists(dot)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Nikhil Shetty | 2023-11-02 17:39:25 | Re: statement_timeout has no effect if sync standby is unavailable |
Previous Message | David G. Johnston | 2023-11-02 17:24:00 | Re: How to _not_ save startup options in postmaster.opts? |