Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions
Christoph Berg <myon@debian.org>
From: Christoph Berg <myon@debian.org>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>, Stephen Frost <sfrost@snowman.net>, Amit Kapila <amit.kapila16@gmail.com>, Ian Barwick <ian.barwick@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2019-08-05T15:34:06Z
Lists: pgsql-hackers
Re: Tomas Vondra 2019-08-03 <20190803124111.2aaddumd7url5wmq@development>
> If we really want to give external tools a sensible (and optional) API
> to access the file, a simple command-line tool seems much better. Say we
> have something like
>
> pg_config_file -f PATH --set KEY VALUE
> pg_config_file -f PATH --get KEY
Fwiw, Debian has pg_conftool (based on the perl lib around
PgCommon.pm):
NAME
pg_conftool - read and edit PostgreSQL cluster configuration files
SYNOPSIS
pg_conftool [options] [version cluster] [configfile] command
DESCRIPTION
pg_conftool allows to show and set parameters in PostgreSQL configuration files.
If version cluster is omitted, it defaults to the default cluster (see user_clusters(5) and postgresqlrc(5)). If configfile is
omitted, it defaults to postgresql.conf. configfile can also be a path, in which case version cluster is ignored.
OPTIONS
-b, --boolean
Format boolean value as on or off (not for "show all").
-s, --short
Show only the value (instead of key = value pair).
-v, --verbose
Verbose output.
--help
Print help.
COMMANDS
show parameter|all
Show a parameter, or all present in this config file.
set parameter value
Set or update a parameter.
remove parameter
Remove (comment out) a parameter from a config file.
edit
Open the config file in an editor. Unless $EDITOR is set, vi is used.
SEE ALSO
user_clusters(5), postgresqlrc(5)
AUTHOR
Christoph Berg <myon@debian.org>
Debian 2019-07-15 PG_CONFTOOL(1)
Commits
-
Doc: improve documentation about postgresql.auto.conf.
- e3ddb112f245 10.11 landed
- 7f77f2aec3d0 11.6 landed
- 57980bdf62f4 9.4.25 landed
- 45aaaa42fefa 13.0 landed
- 372d6a8918e0 12.0 landed
- 1ab92aaa97ce 9.5.20 landed
- 0969a7aa3240 9.6.16 landed
-
Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf.
- f1bf619acdff 13.0 landed
- f8c9a08520ee 10.11 landed
- a4b0d955bd23 9.4.25 landed
- 75b2f011f642 12.0 landed
- 4784ad7a370e 9.6.16 landed
- 32d38f54a369 11.6 landed
- 29f9b1819a72 9.5.20 landed