delta/postgresql.git/contrib/start-scripts, branch master git.postgresql.org: git/postgresql.git Remove gratuitous references to postmaster program 2023-01-26T09:48:32+00:00 Peter Eisentraut peter@eisentraut.org 2023-01-26T09:48:32+00:00 81266442fbcb19ec184134f0a256207f05026520 "postgres" has long been officially preferred over "postmaster" as the name of the program to invoke to run the server. Some example scripts and code comments still used the latter. Change those. Discussion: https://www.postgresql.org/message-id/flat/ece84b69-8f94-8b88-925f-64207cb3a2f0@enterprisedb.com 
"postgres" has long been officially preferred over "postmaster" as the
name of the program to invoke to run the server.  Some example scripts
and code comments still used the latter.  Change those.

Discussion: https://www.postgresql.org/message-id/flat/ece84b69-8f94-8b88-925f-64207cb3a2f0@enterprisedb.com
Remove contrib/start-scripts/osx/. 2017-11-17T17:53:20+00:00 Tom Lane tgl@sss.pgh.pa.us 2017-11-17T17:53:20+00:00 527878635030489e464d965b3b64f6caf178f641 Since those scripts haven't worked at all in macOS releases of 2014 and later, and aren't the recommended way to do it on any release since 2005, there seems little point carrying them into the future. It's very unlikely that anyone would be installing PG >= 11 on a macOS release where they couldn't use contrib/start-scripts/macos/. Discussion: https://postgr.es/m/31338.1510763554@sss.pgh.pa.us 
Since those scripts haven't worked at all in macOS releases of 2014
and later, and aren't the recommended way to do it on any release
since 2005, there seems little point carrying them into the future.
It's very unlikely that anyone would be installing PG >= 11 on a
macOS release where they couldn't use contrib/start-scripts/macos/.

Discussion: https://postgr.es/m/31338.1510763554@sss.pgh.pa.us
Provide modern examples of how to auto-start Postgres on macOS. 2017-11-17T17:46:52+00:00 Tom Lane tgl@sss.pgh.pa.us 2017-11-17T17:46:52+00:00 ac3b9626812b1dd1482ec201711f26af733800f9 The scripts in contrib/start-scripts/osx don't work at all on macOS 10.10 (Yosemite) or later, because they depend on SystemStarter which Apple deprecated long ago and removed in 10.10. Add a new subdirectory contrib/start-scripts/macos with scripts that use the newer launchd infrastructure. Since this problem is independent of which Postgres version you're using, back-patch to all supported branches. Discussion: https://postgr.es/m/31338.1510763554@sss.pgh.pa.us 
The scripts in contrib/start-scripts/osx don't work at all on macOS
10.10 (Yosemite) or later, because they depend on SystemStarter which
Apple deprecated long ago and removed in 10.10.  Add a new subdirectory
contrib/start-scripts/macos with scripts that use the newer launchd
infrastructure.

Since this problem is independent of which Postgres version you're using,
back-patch to all supported branches.

Discussion: https://postgr.es/m/31338.1510763554@sss.pgh.pa.us
start-scripts: switch to $PGUSER before opening $PGLOG. 2017-11-06T15:11:10+00:00 Noah Misch noah@leadboat.com 2017-11-06T15:11:10+00:00 dfc015dcf46c1996bd7ed5866e9e045d258604b3 By default, $PGUSER has permission to unlink $PGLOG. If $PGUSER replaces $PGLOG with a symbolic link, the server will corrupt the link-targeted file by appending log messages. Since these scripts open $PGLOG as root, the attack works regardless of target file ownership. "make install" does not install these scripts anywhere. Users having manually installed them in the past should repeat that process to acquire this fix. Most script users have $PGLOG writable to root only, located in $PGDATA. Just before updating one of these scripts, such users should rename $PGLOG to $PGLOG.old. The script will then recreate $PGLOG with proper ownership. Reviewed by Peter Eisentraut. Reported by Antoine Scemama. Security: CVE-2017-12172 
By default, $PGUSER has permission to unlink $PGLOG.  If $PGUSER
replaces $PGLOG with a symbolic link, the server will corrupt the
link-targeted file by appending log messages.  Since these scripts open
$PGLOG as root, the attack works regardless of target file ownership.

"make install" does not install these scripts anywhere.  Users having
manually installed them in the past should repeat that process to
acquire this fix.  Most script users have $PGLOG writable to root only,
located in $PGDATA.  Just before updating one of these scripts, such
users should rename $PGLOG to $PGLOG.old.  The script will then recreate
$PGLOG with proper ownership.

Reviewed by Peter Eisentraut.  Reported by Antoine Scemama.

Security: CVE-2017-12172
Fix typos in comments. 2017-02-06T09:33:58+00:00 Heikki Linnakangas heikki.linnakangas@iki.fi 2017-02-06T09:33:58+00:00 181bdb90ba1f2361aec5a621c8f1e01736f8cad2 Backpatch to all supported versions, where applicable, to make backpatching of future fixes go more smoothly. Josh Soref Discussion: https://www.postgresql.org/message-id/CACZqfqCf+5qRztLPgmmosr-B0Ye4srWzzw_mo4c_8_B_mtjmJQ@mail.gmail.com 
Backpatch to all supported versions, where applicable, to make backpatching
of future fixes go more smoothly.

Josh Soref

Discussion: https://www.postgresql.org/message-id/CACZqfqCf+5qRztLPgmmosr-B0Ye4srWzzw_mo4c_8_B_mtjmJQ@mail.gmail.com
pg_ctl: Change default to wait for all actions 2017-01-14T14:15:08+00:00 Peter Eisentraut peter_e@gmx.net 2017-01-13T17:00:00+00:00 05cd12ed5bc74c853a161c5a138a0cb6f9b0cb8a The different actions in pg_ctl had different defaults for -w and -W, mostly for historical reasons. Most users will want the -w behavior, so make that the default. Remove the -w option in most example and test code, so avoid confusion and reduce verbosity. pg_upgrade is not touched, so it can continue to work with older installations. Reviewed-by: Beena Emerson <memissemerson@gmail.com> Reviewed-by: Ryan Murphy <ryanfmurphy@gmail.com> 
The different actions in pg_ctl had different defaults for -w and -W,
mostly for historical reasons.  Most users will want the -w behavior, so
make that the default.

Remove the -w option in most example and test code, so avoid confusion
and reduce verbosity.  pg_upgrade is not touched, so it can continue to
work with older installations.

Reviewed-by: Beena Emerson <memissemerson@gmail.com>
Reviewed-by: Ryan Murphy <ryanfmurphy@gmail.com>
Updates to reflect that pg_ctl stop -m fast is the default 2017-01-14T02:25:36+00:00 Peter Eisentraut peter_e@gmx.net 2017-01-13T17:00:00+00:00 e574f15d6295b12c03ef8810c00976b65933711a Various example and test code used -m fast explicitly, but since it's the default, this can be omitted now or should be replaced by a better example. pg_upgrade is not touched, so it can continue to operate with older installations. 
Various example and test code used -m fast explicitly, but since it's
the default, this can be omitted now or should be replaced by a better
example.

pg_upgrade is not touched, so it can continue to operate with older
installations.
Make whitespace consistent inside some script files 2017-01-12T15:17:37+00:00 Peter Eisentraut peter_e@gmx.net 2017-01-12T17:00:00+00:00 da0dbea9c30e7c91e9e78d72ab3dbee77d7ca0cd I don't know what the global standard might be, but at least adjacent code should use the same whitespace. 
I don't know what the global standard might be, but at least adjacent
code should use the same whitespace.
Fix typo in linux startup script. 2015-04-26T13:43:15+00:00 Tom Lane tgl@sss.pgh.pa.us 2015-04-26T13:43:15+00:00 f320cbb615e0374b18836337713239da58705cf3 Missed a "$" in what was meant to be a variable substitution. Careless mistake in commit f23425fa950fec3aff458de117037c9caadbc35c. 
Missed a "$" in what was meant to be a variable substitution.  Careless
mistake in commit f23425fa950fec3aff458de117037c9caadbc35c.
doc: Reflect renaming of Mac OS X to OS X 2014-09-09T17:56:29+00:00 Peter Eisentraut peter_e@gmx.net 2014-09-09T17:56:29+00:00 220bb39dee8044937a963e81be8796e99bd8508b bug #10528 
bug #10528