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: (view raw, whole thread or download thread mbox)
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?

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:

John DeSoi, Ph.D.
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-2017 The PostgreSQL Global Development Group