Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using PG 8.0 with OpenSSL

Using PG 8.0 with OpenSSL

From
Kay-Uwe Genz
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi @ all,

I'm need a little bit help on OpenSSL in combination with PG 8.0.2
under Mac OS X, but I think that is the same thing like under BSD or
Linux.

My PG running with OpenSSL and I have no problems  connecting from my
laptop (running the client) to my desktop (running the server) over
ethernet. But I wish, that PG use certificated connections. I've create
certificates for every user (all user are in pg_hba.conf with hostssl),
but I didn't find information, where I should save the certificates, in
Users home directory?

Thanks a lot.

Kay-Uwe Genz
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3 - not licensed for commercial use: www.pgp.com

iQA/AwUBQpIZCJdFGcTeBMrrEQJCvwCfc10NIXLCX1w1g2+Pay5wwYFejLIAoOlF
MgLSXg1ZU0D05gj7YsT42ZBR
=cl9h
-----END PGP SIGNATURE-----

Re: Using PG 8.0 with OpenSSL

From
"Joshua D. Drake"
Date:
> My PG running with OpenSSL and I have no problems  connecting from my
> laptop (running the client) to my desktop (running the server) over
> ethernet. But I wish, that PG use certificated connections. I've create
> certificates for every user (all user are in pg_hba.conf with hostssl),
> but I didn't find information, where I should save the certificates, in
> Users home directory?

I don't think that PG can do that. I think the SSL is server wide.

Sincerely,

Joshua D. Drake


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

Re: Using PG 8.0 with OpenSSL

From
Kay-Uwe Genz
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Joshua,

you're right. But it's no problem for me, if I change the concept.

Thanks a lot.

Kay-Uwe Genz
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3 - not licensed for commercial use: www.pgp.com

iQA/AwUBQph3lpdFGcTeBMrrEQK1awCg7Fa0D2Zp86s394mHlCTxNyGB0GYAn2Pb
ddgHgK2VIDnr5vNcE8SiPCJ5
=8Ot0
-----END PGP SIGNATURE-----



Am 25.05.2005 um 19:10 schrieb Joshua D. Drake:

>
>> My PG running with OpenSSL and I have no problems  connecting from my
>> laptop (running the client) to my desktop (running the server) over
>> ethernet. But I wish, that PG use certificated connections. I've
>> create certificates for every user (all user are in pg_hba.conf with
>> hostssl), but I didn't find information, where I should save the
>> certificates, in Users home directory?
>
> I don't think that PG can do that. I think the SSL is server wide.
>
> Sincerely,
>
> Joshua D. Drake
>
>
> --
> Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>
>