PostgreSQL Discussion - Using PG 8.0 with OpenSSL

Author

Using PG 8.0 with OpenSSL

Kay-Uwe Genz

2005-05-24, 9:23 am

-----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/ AwUBQpIZCJdFGcTeBMrr
EQJCvwCfc10NIXLCX1w1
g2+Pay5wwYFejLIAoOlF

MgLSXg1ZU0D05gj7YsT4
2ZBR
=cl9h
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Joshua D. Drake

2005-05-25, 1:23 pm

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Sponsored Links