Re: initdb recommendations - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: initdb recommendations
Date
Msg-id fcd8848c-618c-23d1-2b39-77b13cb2d0a1@2ndquadrant.com
Whole thread Raw
In response to Re: initdb recommendations  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: initdb recommendations
List pgsql-hackers
On 2019-05-23 18:54, Peter Eisentraut wrote:
> To recap, the idea here was to change the default authentication methods
> that initdb sets up, in place of "trust".
> 
> I think the ideal scenario would be to use "peer" for local and some
> appropriate password method (being discussed elsewhere) for host.

Patch for that attached.

> Looking through the buildfarm, I gather that the only platforms that
> don't support peer are Windows, AIX, and HP-UX.

Note that with this change, running initdb without arguments will now
error on those platforms: You need to supply either a password or select
a different default authentication method.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: "Li, Zheng"
Date:
Subject: Re: NOT IN subquery optimization
Next
From: Tomas Vondra
Date:
Subject: Choosing values for multivariate MCV lists