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 1hqHow-0003N5-Dv for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2019 14:00:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hqHov-00010G-7l for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2019 14:00:41 +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 1hqHou-0000tA-Sq for pgsql-hackers@lists.postgresql.org; Wed, 24 Jul 2019 14:00:40 +0000 Received: from mail-oi1-x244.google.com ([2607:f8b0:4864:20::244]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqHos-00027r-3g for pgsql-hackers@lists.postgresql.org; Wed, 24 Jul 2019 14:00:40 +0000 Received: by mail-oi1-x244.google.com with SMTP id l12so35095966oil.1 for ; Wed, 24 Jul 2019 07:00:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=VhHRDkZ0mQAtdodo2qh8McobCOxCdwNh4wgCmyOY4Gs=; b=ADPwyZG32lb3YpZsdSpPHfoEWwH7dCiU4/GS2b8p0WFANTDC47l9J4T2rEPMHTFRZE 1iHhjkvd2gl2cp7Yg5NXNeU0wdznWNPzv7GVLrnDw/wwXGi8tehqpHN9JtVLFoIosnLO mPqINbv51vt+UgfY5rOC83Cc2x6nwcxi0TQGHTi6t75Q/wEMaOS9Hnde9Z9qC2KBFhp4 wvwughcShuHZJQrxtHN7TQw4KB67sekqAUpW0qBi+w/DWbHRk48rrzlrFzDr9ivR+hft NdOjV4qRcCcCdzQvcLkevqeckooVWA7qW5h0tC9vmYBp+g3UjPLsdTbfo6843J1tuttE jHDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-transfer-encoding:content-language; bh=VhHRDkZ0mQAtdodo2qh8McobCOxCdwNh4wgCmyOY4Gs=; b=qmYZ0LYkBeBqcdzY74VBJjbC4yYBSeGfS2gyuFghTYZ5tIysV55S9+ZV56fG7Wik5q LvhWsGdA7VFKEABkJbJrgizqfsaC9K8hN/YsEr1u7RJvgC1lapA9C96ZiVvCb3lRi+QR t1y2hunFM8wyrD8bOqPS+cFzyYmsPS2H2MEVIqE/+rpZawaZLxa6IMzX95QR8PukjU7+ yvrOtQnJMKp0Rbm9trMqPYnAan20oEJTM6XDzL30xlibWdVn1PGHDpUValAKH1s/olxX ekAr40OJRearj5e9tiRxt4Af0FDGyMTHit2rK+Qm/htHitKa3ZOySDp7BG/a1xL6fYti 1klA== X-Gm-Message-State: APjAAAXQ3GH+bQk5wW/8ub0taeUzvMT4K24ksBGfw7XDyM1MWlilNxrv +BbB0mpnH8p5loARcmcoGHnOMd+m8nUZfw/iTMkbLy6GDDosyNfPTfZo5Iy55rvG0sYvKIM2khP LZsRTS4I3OxjroCM8mswadmgBsPDlTGWaLxD808POpLhlIO6CE9RjwP1SOeiqSlIMztvM9NT8Z5 Nu/LM5i4cRMJM4UWQ2e87RdsI= X-Google-Smtp-Source: APXvYqyWmNvINU03nqZlEWLCPpvRNy4Ilc00H4jNYu2TLfPFNxJOQdPZgNgdoowxOgmDHsBZKze+RQ== X-Received: by 2002:aca:c3d7:: with SMTP id t206mr36938907oif.138.1563976835955; Wed, 24 Jul 2019 07:00:35 -0700 (PDT) Received: from [192.168.10.146] (99-10-92-30.lightspeed.rlghnc.sbcglobal.net. [99.10.92.30]) by smtp.gmail.com with ESMTPSA id t15sm16197132oie.34.2019.07.24.07.00.35 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Wed, 24 Jul 2019 07:00:35 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: initdb recommendations To: Peter Eisentraut , Tom Lane Cc: pgsql-hackers@lists.postgresql.org References: <20190406180839.GA1921989@rfd.leadboat.com> <96389374-9454-d26d-6f79-7c7b15ec14bd@2ndquadrant.com> <91f8272f-117f-2a04-862b-871a7b86eeed@2ndquadrant.com> <7b6c4220-e5ef-2a13-18ad-af596c52b71a@2ndquadrant.com> <23654.1563804669@sss.pgh.pa.us> <7886.1563812705@sss.pgh.pa.us> <27724.1563813541@sss.pgh.pa.us> <4bfcca1d-220c-850d-a3e2-5f44261331c2@2ndquadrant.com> Openpgp: preference=signencrypt Autocrypt: addr=andrew.dunstan@2ndQuadrant.com; prefer-encrypt=mutual; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNL0FuZHJldyBEdW5zdGFuIDxhbmRyZXcuZHVuc3RhbkAybmRRdWFkcmFudC5jb20+wsCY BBMBAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAUJDyV6hBYhBOQ+WEYd/Hy/RGkV pZn6f8tZ/DuBBQJcH/EVAhkBAAoJEJn6f8tZ/DuB7BEH/iDWZEbVft2m2MT6SPjARzTupt/l xLLZ/Cl6n2US2hov5+fBbnR5xvECk/YCOfG9ICvKNlpFjceqNLRKStd8cmndnI+kDw91uNM2 hpL4aJMeW65XCHvqXlOLSwv5chBpXz9NG7FMaJ+q+59sWEWjcTNmjXgkEHn53y+1pc7nSLDe cr5ZI1aB3nGXRm1SoDY5PYZkUKMykW+YBZwgcs/Q5tRaE+siN7DKbz8E628+PerwAkmHPVXN MdJFD6gs4S0gDFA8IxcyIwZU2v4By+brzcJ9Se3FK5BYxBDHtaYZxgSrJAvOUOrLIZPQTQfL TtnVs3C3JTfrxCH1ceHtnA6dRuTOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oK Waqf+wmW4tpDe/VVcxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7 llV0xSSoFiieQBsrGvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8 BoVrRFcdzlIY/NFNhFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C 4R+M6w7o2PLGOjdZ+kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaY L++LAEOqrlvm2TvqQqZRtnEAEQEAAcLAZQQYAQIADwIbDAUCXA6fpAUJDyV6xAAKCRCZ+n/L Wfw7geU4B/9vFFsVmWxerDWgNjyiK80zIPmlw/iwdUlU6FIu0JWLMg4093kvxBs7RMZV9hBq n3ekBvD4IvFsVLJrw9qzSI2FH3UeYy5WXpEs01Ppia60NOlvRDqXbryzuvfe+iYo6bVP3Ikr TPTNYL/BePUTD2DPvSI82SbGTyzuA7SJv6NRqqQDMIy1fU6KyQFLmQJp/QJyhKWzm9jWh8ee w8jVaoMY0Kbq5N7RqisEx1Lu/Iw646UphdYzQNymf+kbiU5Kf4I6DhzV8w9sie1Bo1juNj3I c5/fFJsmxljbnaDbXPcnFsur1Oo9mIHFakgWgOBMuxoWfjONiLjjLh/9+ZIqSSLX Message-ID: <654cbc96-0b32-6d00-09a8-5caf5d051103@2ndQuadrant.com> Date: Wed, 24 Jul 2019 10:00:34 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <4bfcca1d-220c-850d-a3e2-5f44261331c2@2ndquadrant.com> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 7/23/19 2:12 AM, Peter Eisentraut wrote: > On 2019-07-22 21:16, Andrew Dunstan wrote: >> Modulo this issue, experimentation shows that adding '-A trust' to the >> line in run_build.pl where initdb is called fixes the issue. If we're >> going to rely on a buildfarm client fix that one seems simplest. > Yes, that is the right fix. It's what the in-tree test drivers > (pg_regress, PostgresNode.pm) do. > I have done that, I will put out a new release probably right after the CF closes. I think we also need to change vcregress.pl to use trust explicitly for upgrade checks, just like the Unix upgrade test script does. That should help to future-proof us a bit. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services