[ADMIN] secure connections

2008-09-07 Thread c k
Hello,
I have a question regarding secure connections between pg clients and pg
server. As per manual for 8.3 we can use openssl for this purpose. does odbc
driver supports it and how? Is there any other method for this?

Thanks

CPK


Re: [ADMIN] [GENERAL] secure connections

2008-09-07 Thread Filip RembiaƂkowski
2008/9/7 c k <[EMAIL PROTECTED]>:
> Hello,
> I have a question regarding secure connections between pg clients and pg
> server. As per manual for 8.3 we can use openssl for this purpose. does odbc
> driver supports it and how? Is there any other method for this?

Yes the ODBC driver (as well as all decent postgres clients) does
support SSL. You can choose SSL mode: disable/prefer/allow/require.

Other method? Encrypted tunnels. VPNs. this kind of stuff.

Remember that establishing SSL session is resource - expensive. This
can be important if you plan lots of connections.

cheers

-- 
Filip RembiaƂkowski

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[ADMIN] update to 8.3.3

2008-09-07 Thread Jumping
Hi,all!
I plan to update my database from 8.1.9 to 8.3.3.
Is there any tricks or tips ?
Thanks in advance.

-- 
Don't tell me how many the enemies,but where they are!
(ADV:Perl -- It's like Java, only it lets you deliver on time and under
budget.)