X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9DD719FB1E0 for ; Thu, 14 Sep 2006 11:17:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 76620-04 for ; Thu, 14 Sep 2006 14:17:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from socrates.thinkhost.com (mailpipe.socrates.thinkhost.com [64.40.100.194]) by postgresql.org (Postfix) with ESMTP id CD3739FA0FC for ; Thu, 14 Sep 2006 11:17:07 -0300 (ADT) Received: from geier (adsl-64-91-71-139-rb.lax.customer.centurytel.net [64.91.71.139]) by socrates.thinkhost.com (8.13.6/8.13.5) with SMTP id k8EEGKGK070051 for ; Thu, 14 Sep 2006 10:16:20 -0400 (EDT) (envelope-from jgeier@apt-cafm.com) Message-ID: <009801c6d808$7200a260$6700a8c0@geier> From: "Jeanna Geier" To: Subject: Beginning SSL Questions Date: Thu, 14 Sep 2006 09:17:00 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0095_01C6D7DE.88B0FD90" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Antivirus: avast! (VPS 0637-1, 09/13/2006), Outbound message X-Antivirus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200609/133 X-Sequence-Number: 23047 This is a multi-part message in MIME format. ------=_NextPart_000_0095_01C6D7DE.88B0FD90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All- We are going to start implementing SSL with Postgres v8.1.4 (finally got = it working with Tomcat after a few long weeks!); and I've been doing = some reading in the docs and on the mailing lists and I have a couple of = questions before we start down this path: - In the docs, it says that when using SSL in Postgres "This requires = that OpenSSL is installed on both client and server systems and that = support in PostgreSQL is enabled at build time" - is this correct? Or = can we use the certificates and keystore file we generated using the = Jave keytool implementing SSL with Tomcat? - In perusing the mailing list, it appears that this is not going to be = a 'simple' task...any pointers that anyone can give to me before we = start? If possible, I'd like to avoid another hair-pulling three week = task! =3Do) Thanks in advance for any help and for your time! -Jeanna ------=_NextPart_000_0095_01C6D7DE.88B0FD90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi = All-
 
We are going = to start=20 implementing SSL with Postgres v8.1.4 (finally got it working with = Tomcat=20 after a few long weeks!); and I've been doing some reading in the docs = and on=20 the mailing lists and I have a couple of questions before we start down = this=20 path:
 
 - In the = docs, it says=20 that when using SSL in Postgres "This requires that OpenSSL is installed = on both=20 client and server systems and that support in PostgreSQL is enabled at = build=20 time" - is this correct?  Or can we use the certificates and = keystore=20 file we generated using the Jave keytool implementing SSL with=20 Tomcat?
 
 - In = perusing the=20 mailing list, it appears that this is not going to be a 'simple' = task...any=20 pointers that anyone can give to me before we start?  If possible, = I'd like=20 to avoid another hair-pulling three week task! =3Do)
 
Thanks in = advance for any=20 help and for your time!
-Jeanna
------=_NextPart_000_0095_01C6D7DE.88B0FD90--