From: Christoph Berg <myon@debian.org>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Ian Barwick <ian.barwick@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions
Date: Mon, 5 Aug 2019 17:34:06 +0200
Message-ID: <20190805153406.GA24325@msg.df7cb.de> (raw)
In-Reply-To: <20190803124111.2aaddumd7url5wmq@development>
References: <CAA4eK1+JMm=tvx720y6jhD8pdzt=HdS1-TwQwkARib2pwK8EvQ@mail.gmail.com>
<20190802222254.qsvqjtkwte464lu3@development>
<31697.1564784856@sss.pgh.pa.us>
<CAOuzzgqNyQM_z0biEEBVBK9WcaLmbCyWrd5xTdf-Oxb_9pntLA@mail.gmail.com>
<32681.1564786027@sss.pgh.pa.us>
<CAOuzzgpDj4kLNh7=bfEYv4zXrLgRziMogcXFSHzrhn74xjYXyQ@mail.gmail.com>
<20190803004558.jfkbngi6g64eaqku@alap3.anarazel.de>
<CAOuzzgpuH+uvT3Yvw5KC=keEqGifSc4eXQ6DB=yrowYyre2YvA@mail.gmail.com>
<20190803010802.rs3cz2kjq4dl4olu@alap3.anarazel.de>
<20190803124111.2aaddumd7url5wmq@development>
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)
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-hackers@postgresql.org
Cc: myon@debian.org, tomas.vondra@2ndquadrant.com, andres@anarazel.de, sfrost@snowman.net, amit.kapila16@gmail.com, ian.barwick@2ndquadrant.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: [PATCH] Stop ALTER SYSTEM from making bad assumptions
In-Reply-To: <20190805153406.GA24325@msg.df7cb.de>
* 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