Using PG 8.0 with OpenSSL

Started by Kay-Uwe Genzalmost 21 years ago3 messagesgeneral
Jump to latest
#1Kay-Uwe Genz
kug1977@web.de

-----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-----

#2Joshua D. Drake
jd@commandprompt.com
In reply to: Kay-Uwe Genz (#1)
Re: Using PG 8.0 with OpenSSL

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/

#3Kay-Uwe Genz
kug1977@web.de
In reply to: Joshua D. Drake (#2)
Re: Using PG 8.0 with OpenSSL

-----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:

Show quoted text

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/