On 7/22/19 1:40 PM, Andres Freund wrote: > Hi, > > On 2019-07-22 13:02:13 -0400, Andrew Dunstan wrote: >> There are a few things we could do. We could force trust auth, or we >> could add an ident map that allowed $USER to login as buildfarm. Finding >> all the places we would need to fix that could be a fun project ... > Perhaps we could actually do so automatically when the initdb invoking > user isn't the same as the OS user? Imo that'd be generally quite > useful, and not just for the regression tets. >
yeah, although I think that's a separate exercise. So we'd have something like in pg_hba.conf local all all peer map=datadir_owner and in pg_ident.conf datadir_owner $USER $superuser cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
