Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dLHaP-0005gf-BI for pgsql-admin@arkaria.postgresql.org; Wed, 14 Jun 2017 23:20:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dLHaO-0004qo-Pg for pgsql-admin@arkaria.postgresql.org; Wed, 14 Jun 2017 23:20:28 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dLHYY-00072Q-Lo for pgsql-admin@postgresql.org; Wed, 14 Jun 2017 23:18:34 +0000 Received: from mail-qt0-x22f.google.com ([2607:f8b0:400d:c0d::22f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dLHYW-0008HJ-3u for pgsql-admin@postgresql.org; Wed, 14 Jun 2017 23:18:33 +0000 Received: by mail-qt0-x22f.google.com with SMTP id w1so19916103qtg.2 for ; Wed, 14 Jun 2017 16:18:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Y+XT8iHijzsSyCP46aUqDB1ISPVqNb3XFA4TMdrRMAA=; b=mN0vSl6vXpSR+Qc7QjwKzqceZW8/OZ/vMH8hM/Pbt6TdcWvJzT2acbSRJDrIkW78Ew bLbIUwH/Xiuj2b82O6Vp6TwehEzc8ZAbH5XCkbfZS8T965odaNMZlE6LebNIVCJ3gyQj wvknngEA7iqTikD1QR/nCEpDznYEx77QSGY4iLFTKrCEpRGsC3DW/8Nd22i27PjSNdLK sV7x0Tgm33BerSNhY2x/WkXUqGIrVXvJNu4F6RE32XZN/N/9Sk7vioqMKs+dCKc4MHC7 FlQnPkD1qmveH1pZSj6QZPUqxL++iBJ/wxmF3MdWHRqk9JZs45iIxHr/SbyJWCocZSwb T1tQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Y+XT8iHijzsSyCP46aUqDB1ISPVqNb3XFA4TMdrRMAA=; b=Ic6Xw1E/3mROCyYCJB9Il4rvKpR9OjIkKMN8x/UWhoRYGcVXlIlP7hQ/4k97KVHqwm Z6BE+IWRcDpldXrQAyhWOMYz0/WPXPQL6bB6oCK/XNi00qUevG0DiyAx1cprKU6cfamt 3c71vIgHUeyYpeEW4R39wxJE3Z5dnDoBIlDSGDjLeK9TZsB2h6xBFnLpjXrgFizmZnDy Zv3uv597+X5ViCnYi2FUYvnqceuZf67FR9TbwzO2d91+PC/JmdfUiLhkJmLxx/syL0qw aP2pd77/MDyt+Simx3+PYFMlCItyabBL/++IVYxbz+ue4JC761vTzh5N81tEBEbRdVyP 9DlA== X-Gm-Message-State: AKS2vOwHti0YBmNhZbaSOw6z3PV5nd79eaBwzqGMiYiP5K+kCBcQVCxj Adhr7fSZG/bT6gcwdPw= X-Received: by 10.55.217.6 with SMTP id u6mr2964704qki.151.1497482310200; Wed, 14 Jun 2017 16:18:30 -0700 (PDT) Received: from [192.168.1.152] (pool-71-179-177-60.bltmmd.fios.verizon.net. [71.179.177.60]) by smtp.gmail.com with ESMTPSA id d16sm1018698qke.5.2017.06.14.16.18.29 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 14 Jun 2017 16:18:29 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (1.0) Subject: Re: SSL certificate revocation file will not load From: John Scalia X-Mailer: iPad Mail (14F89) In-Reply-To: <26527.1497478022@sss.pgh.pa.us> Date: Wed, 14 Jun 2017 19:18:28 -0400 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <23871.1497473425@sss.pgh.pa.us> <68DC7C40-A815-4F80-924A-45C07A463D55@gmail.com> <26527.1497478022@sss.pgh.pa.us> To: Tom Lane List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Thanks, I'll try to convince the management to upgrade ASAP once 10 makes i= t into a production release. Sent from my iPad > On Jun 14, 2017, at 6:07 PM, Tom Lane wrote: >=20 > John Scalia writes: >> Well, it turned out that the CRL was in the wrong format. So, I managed >> to convert it with OpenSSL and it loaded properly. I do have one more >> question... the Treasury Department, which produces these certificates >> for us, expires all the CRL's in just 6 hours, >=20 > Ugh. >=20 >> so does that mean I'd have to do restart on the database each time I got >> a new one or would a reload work? >=20 > As of PG 10, a reload would work, but in prior versions you'll have to > restart to get it to pick up new SSL config files. >=20 > If you're feeling desperate you could try back-patching commit de41869b6, > but keep in mind that hasn't made it through a beta-test cycle yet. >=20 > regards, tom lane --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin