pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: "Martin Münstermann" <mmuenst@gmx.de>
To: Bruce Momjian <bruce@momjian.us>
To: joseberardo@gmail.com
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL with SSL
Date: Thu, 15 Apr 2010 09:45:42 +0200
Message-ID: <20100415074542.137300@gmx.net> (raw)
In-Reply-To: <201004150206.o3F26U427784@momjian.us>
References: <201004150206.o3F26U427784@momjian.us>

Hello.

> > don't know how to export the private key and when I use the keytool
> > certificate, the server crashes with this message:
> > 
> >  FATAL:  could not load server certificate file "server.crt": no start
> line
> > 
> > Sorry about too many questions, but anyone can help me to understand
> more
> > about ssl in PostgreSQL?
> 
> Have you read the documentation about creating a server key?
> 
> 	http://www.postgresql.org/docs/8.4/static/ssl-tcp.html

It is important that the server.crt and server.key files are in so-called PEM format. 
So they have to be text files and look like:

-----BEGIN CERTIFICATE-----
<some base64 encoded data>
-----END CERTIFICATE-----

and 

-----BEGIN RSA PRIVATE KEY-----
<some base64 encoded data>
-----END RSA PRIVATE KEY-----

This is the default format produced by openssl. 
The private key format is also openssl-specific, so probably you are out of luck with keytool.

Regards,
 Martin

-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01

view thread (11+ messages)  latest in thread

Message-ID: <20100415074542.137300@gmx.net>
Permalink:  ../20100415074542.137300@gmx.net/
Also on:    postgresql.org/message-id/20100415074542.137300@gmx.net

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mmuenst@gmx.de, bruce@momjian.us, joseberardo@gmail.com
  Subject: Re: PostgreSQL with SSL
  In-Reply-To: <20100415074542.137300@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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