On May 16, 2007, at 10:23 AM, Andreas wrote:
is there a documentation on how to secure a connection withe SSL?
That is an option of the ODBC driver, isn't it?
http://www.postgresql.org/docs/8.2/interactive/ssl-tcp.html
I don't know about ODBC.
The motivation is that I need to rent a remote server for PG.
Their admin proposes to open port 5432 on the outside of their
firewall but he has no idea how to secure the access besides PG's
user/password.
I couldn't even restrict the accessing IPs within PG because they
will be dynamic.
If they won't setup PostgreSQL properly with SSL support, your best
bet is to setup a SSH tunnel. This will also work with ODBC. If they
don't support SSH, find another provider :). Here is some background
on setting it up:
http://pgedit.com/tip/postgresql/ssh_tunneling
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
