Skip site navigation (1) Skip section navigation (2)

Re: HowTo SSL probaply with ODBC ?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: HowTo SSL probaply with ODBC ?
Date: 2007-05-16 23:56:56
Message-ID: 76D7FC25-6A9D-4889-8BDB-02D76EACF3B5@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
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


In response to

pgsql-odbc by date

Next:From: Dr. MaybeDate: 2007-05-18 05:26:17
Subject: postgres odbc with crystal reports server xi on linux
Previous:From: AndreasDate: 2007-05-16 14:23:06
Subject: HowTo SSL probaply with ODBC ?

pgsql-general by date

Next:From: John D. BurgerDate: 2007-05-17 02:15:02
Subject: Re: cube operations
Previous:From: Joshua D. DrakeDate: 2007-05-16 23:41:45
Subject: Re: Vacuum non-clustered tables only

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group