Re: [gnome-db] Encrypted DB connection

[Vivien Malerba <vmalerba gmail com>]

On 15 December 2010 15:49, Catarina Fernandes <catarina m fernandes gmail com> wrote:
> Hi!
>
> I'm using libgda to get some data from a postgres database.
>
> Is there a way of using an encrypted connection to the database?

You can specify the USE_SSL=TRUE in your connection string.

To know all the parameters accepted by a database provider when opening a connection, you can use the gda-sql-4.0.exe program, for example:
vivien may11:~$ gda-sql-4.0 -L PostgreSQL
                    Provider 'PostgreSQL' description
Attribute      │ Value                                                     
───────────────┼───────────────────────────────────────────────────
Provider       │ PostgreSQL                                                
Description    │ Provider for PostgreSQL databases                         
DSN parameters │ DB_NAME,                                                  
                 SEARCHPATH,                                               
                 HOST,                                                     
                 PORT,                                                     
                 OPTIONS,                                                  
                 USE_SSL                                                   
Authentication │ USERNAME,                                                 
                 PASSWORD                                                  
File           │ /prefix/lib/libgda-4.0/providers/libgda-postgres.so
(5 rows)

Regards,

Vivien