initdb: Change authentication defaults

Peter Eisentraut <peter@eisentraut.org>

Commit: 09f08930f0f6fd4a7350ac02f29124b919727198
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2019-07-22T13:14:27Z
Releases: 13.0
initdb: Change authentication defaults

Change the defaults for the pg_hba.conf generated by initdb to "peer"
for local (if supported, else "md5") and "md5" for host.

(Changing from "md5" to SCRAM is left as a separate exercise.)

"peer" is currently not supported on AIX, HP-UX, and Windows.  Users
on those operating systems will now either have to provide a password
to initdb or choose a different authentication method when running
initdb.

Reviewed-by: Julien Rouhaud <rjuju123@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/bec17f0a-ddb1-8b95-5e69-368d9d0a3390%40postgresql.org

Files

PathChange+/−
doc/src/sgml/ref/initdb.sgml modified +16 −1
doc/src/sgml/runtime.sgml modified +9 −14
doc/src/sgml/standalone-install.xml modified +0 −9
src/bin/initdb/initdb.c modified +10 −21
src/include/port.h modified +5 −0
src/test/regress/pg_regress.c modified +1 −1

Documentation touched

Discussion