pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf
3+ messages / 3 participants
[nested] [flat]

* ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf
@ 2017-07-13 10:53 vodevsh@gmail.com
  2017-07-13 10:57 ` Re: ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf Michael Paquier <michael.paquier@gmail.com>
  2017-07-13 15:35 ` Re: ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf David G. Johnston <david.g.johnston@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: vodevsh@gmail.com @ 2017-07-13 10:53 UTC (permalink / raw)
  To: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/config-setting.html
Description:

&gt; The already-mentioned ALTER SYSTEM command provides a SQL-accessible means
of changing global defaults; it is functionally equivalent to editing
postgresql.conf

Should not it be ...to editing postgresql.auto.conf?.. I know user is not
supposed to edit postgresql.auto.conf but this is what ALTER SYSTEM does,
not touching the postgres.conf - isn&#39;t is confusing in manual?..

Thank you

-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf
  2017-07-13 10:53 ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf vodevsh@gmail.com
@ 2017-07-13 10:57 ` Michael Paquier <michael.paquier@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Paquier @ 2017-07-13 10:57 UTC (permalink / raw)
  To: vodevsh@gmail.com; +Cc: pgsql-docs

On Thu, Jul 13, 2017 at 12:53 PM,  <vodevsh@gmail.com> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/config-setting.html
> Description:
>
> &gt; The already-mentioned ALTER SYSTEM command provides a SQL-accessible means
> of changing global defaults; it is functionally equivalent to editing
> postgresql.conf
>
> Should not it be ...to editing postgresql.auto.conf?.. I know user is not
> supposed to edit postgresql.auto.conf but this is what ALTER SYSTEM does,
> not touching the postgres.conf - isn&#39;t is confusing in manual?..

The documentation looks correctly shaped to me per this paragraph
above the one you mention here:
In addition to postgresql.conf, a PostgreSQL data directory contains a
file postgresql.auto.conf, which has the same format as
postgresql.conf but should never be edited manually.

So, citing postgresql.conf, which can be edited manually, looks correct to me.
-- 
Michael


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf
  2017-07-13 10:53 ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf vodevsh@gmail.com
@ 2017-07-13 15:35 ` David G. Johnston <david.g.johnston@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: David G. Johnston @ 2017-07-13 15:35 UTC (permalink / raw)
  To: Vladimir Svedov <vodevsh@gmail.com>; +Cc: pgsql-docs

On Thu, Jul 13, 2017 at 3:53 AM, <vodevsh@gmail.com> wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/config-setting.html
> Description:
>
> &gt; The already-mentioned ALTER SYSTEM command provides a SQL-accessible
> means
> of changing global defaults; it is functionally equivalent to editing
> postgresql.conf
>
> Should not it be ...to editing postgresql.auto.conf?.. I know user is not
> supposed to edit postgresql.auto.conf but this is what ALTER SYSTEM does,
> not touching the postgres.conf - isn&#39;t is confusing in manual?..
>

​I think it is fine; but if being picky I'd probably say:

"[...] of changing global default as an alternative to editing
postgres.conf"

It is functionally equivalent from the perspective of the runtime
environment of the system.  It is not mechanically equivalent since, as you
say, the contents of postgres.conf are not actually changed.

David J.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2017-07-13 15:35 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-13 10:53 ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf vodevsh@gmail.com
2017-07-13 10:57 ` Michael Paquier <michael.paquier@gmail.com>
2017-07-13 15:35 ` David G. Johnston <david.g.johnston@gmail.com>

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