pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Openssl v3_ca
4+ messages / 1 participants
[nested] [flat]

Commits from this thread:
  2020-08-31 b1ae70b3b4 01bcfe705d bdfd83f4a4 361217659d a8591cbb40 0756921abe 8924ca865b  docs:  clarify intermediate certificate creation instructions
* Openssl v3_ca
@ 2020-08-24 17:56  Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 2020-08-24 17:56 UTC (permalink / raw)
  To: pgsql-docs

A few years ago I figured out how to create intermediate certificates
that are transferred across OpenSSL connections by using the v3_ca
extension, and added this to the PG documentation.

I have now just figured out that v3_ca is just a heading in the openssl
configuration file, e.g., /etc/ssl/openssl.cnf, and that it is
specifically this line that enables this to work:

	basicConstraints = critical,CA:true

I have created the attached documentation patch to clarify exactly what
is needed, in case non-openssl tools are used.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

Attachments:

v3_ca.diff (text/x-diff, 689B) download diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index c8698898f3..f705c4fec1 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -2194,7 +2194,8 @@ pg_dumpall -p 5432 | psql -d postgres -p 5433 can also be appended to the file. Doing this avoids the necessity of storing intermediate certificates on clients, assuming the root and intermediate certificates were created with <literal>v3_ca</literal> - extensions. This allows easier expiration of intermediate certificates. + extensions (which sets <literal>CA:TRUE</literal> on certificates). + This allows easier expiration of intermediate certificates. </para> <para>
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: Openssl v3_ca
@ 2020-08-31 20:21  Bruce Momjian <bruce@momjian.us>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2020-08-31 20:21 UTC (permalink / raw)
  To: Stephen Frost <sfrost@snowman.net>; +Cc: pgsql-docs

On Mon, Aug 24, 2020 at 04:52:24PM -0400, Bruce Momjian wrote:
> > While true, there's certainly other reasons why someone might want to
> > run intermediate CAs.. I'm not sure that we really need to go into the
> > discussion about why they make sense to have.
> 
> Agreed.  If we wanted to get into that, we would need to make a new doc
> section about it.

Applied.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee






^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2020-08-31 20:21 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-24 17:56 Openssl v3_ca Bruce Momjian <bruce@momjian.us>
2020-08-31 20:21 ` Bruce Momjian <bruce@momjian.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox