Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihnu9-0006qR-0l for pgsql-pkg-yum@arkaria.postgresql.org; Thu, 19 Dec 2019 04:59:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ihnu7-0005Jt-Da for pgsql-pkg-yum@arkaria.postgresql.org; Thu, 19 Dec 2019 04:59:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihnu7-0005Jm-2A for pgsql-pkg-yum@lists.postgresql.org; Thu, 19 Dec 2019 04:59:15 +0000 Received: from mail-lj1-x241.google.com ([2a00:1450:4864:20::241]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ihnu3-0000Cw-8q for pgsql-pkg-yum@postgresql.org; Thu, 19 Dec 2019 04:59:14 +0000 Received: by mail-lj1-x241.google.com with SMTP id u71so4688200lje.11 for ; Wed, 18 Dec 2019 20:59:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=Lk12qRYD/zyY3zDDA4YZOMStccTKPpqIdVSEFu328cg=; b=aF6GaDqgVtaSh5i36K1Rl93mMbZcl0aY6aMJlXx07jveT8N4hGBj8tLl6GDhCgl5Pp Jfm8ODIXUlQnWLuydPvMCCAkXipTOG4k9EG6stCqegEYEdjo4NTt+KY5OqUN0IcaKXeK wOQ8NsTlCH5wpL35m5zLDm/ATZMmdPbWQJ09AqZNm9etE7phFnJVxAj+q0U3j61x2uK8 4zL+LaRPcuMP4QCQjYBC51nDZs2AZZsP512j2poITyQsSDiNOQQuucfDOwm25Th9iygK 720qDVJaWdiEerqavrl+dQkyyw/mOdOLwavE4Vmf+yFKUGBR8rLY/4JBkWibMnZ4PuPI 0krg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=Lk12qRYD/zyY3zDDA4YZOMStccTKPpqIdVSEFu328cg=; b=sbAzIN+EcLtQI3myMWB0MkY7SFdUcxVlNOUVKlvdscJ/0NK3Sg19zIB+OgpCB6Wu6F nGcEqtHDKfc0akK6U9ugencT9op5hJGqwia3EM3kclXNp9bvm5xItTHR2yqXKkKTefhL eodO5/YDe1gHnWleoTkyRrVNEbvv/JvERnM4Y6bgprwovyBj7sqcaJ2ZWbZFi02zz1t6 9jBeJrRFx8NbM2MyWxbXeadIfirMzkoH7Mge5KH7BNm8inxHtuiq7eaCqGCB8iolcMuo pa7mKii1Q/j1XdUZYVRwGuzrTTUBrJax8xpj8N2uzo1z0fMv57oMI4uWWVhjtB3R6lUh OmGA== X-Gm-Message-State: APjAAAVYfrF4dL4jqy+z9AYOAhDWZ6A88/QWIgHrHAIG+W+I97pKv485 3szHq+PU5UbEW0VRjb9hGwXjSjZAv+zEGEdqKmsEDRqU0G0= X-Google-Smtp-Source: APXvYqwDKIGVduOVQUzkBy65W+8esiYfTQ8mTc3IObJT8qIjpf0HzxCzpXMitmvgwbTXWBk6JKKS/Ykyh3RGPwre6zQ= X-Received: by 2002:a2e:8699:: with SMTP id l25mr4566816lji.159.1576731550200; Wed, 18 Dec 2019 20:59:10 -0800 (PST) MIME-Version: 1.0 From: Craig Ringer Date: Thu, 19 Dec 2019 12:58:59 +0800 Message-ID: Subject: Can we stop defaulting to 'ident'? To: pgsql-pkg-yum Content-Type: multipart/alternative; boundary="000000000000f4c8cb059a076b8a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000f4c8cb059a076b8a Content-Type: text/plain; charset="UTF-8" 'ident' doesn't work by default on any RPM disto. It's not clear why the initdb wrapper for the rpm packages defaults to generating 'host' entries with 'ident' auth, but I think it's pretty unhelpful. At least if we used 'md5' the user could set passwords and have them actually work. initdbcmd="$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" initdbcmd+=" $PGSETUP_INITDB_OPTIONS" I know you can override it easily enough, but most people won't know to. -- Craig Ringer http://www.2ndQuadrant.com/ 2ndQuadrant - PostgreSQL Solutions for the Enterprise --000000000000f4c8cb059a076b8a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
'ident' doesn't work by default on any RPM dis= to.

It's not clear why the initdb wrapper for the rp= m packages defaults to generating 'host' entries with 'ident= 9; auth, but I think it's pretty unhelpful. At least if we used 'md= 5' the user could set passwords and have them actually work.
=
=C2=A0 =C2=A0 initdbcmd=3D"$PGENGINE/initdb --pgdata=3D= '$PGDATA' --auth=3D'ident'"
=C2=A0 =C2=A0 initdbcmd= +=3D" $PGSETUP_INITDB_OPTIONS"

I kno= w you can override it easily enough, but most people won't know to.

--
=C2=A0Craig Ringer=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 http://www.2ndQuadrant= .com/
=C2=A02ndQuadrant - PostgreSQL Solutions for the Enterprise
--000000000000f4c8cb059a076b8a--