I'd like to build some SSL functionality into my C functions that
access the PostgreSQL database. My C functions are calling the
routines from libpq. By chance, are there any SSL functions inherent
to libpq for establishing a secure connection to the postmaster?

I mention this because I noticed in the source code for psql, the c
file startup.c has the following line:

ssl = PQgetssl(pset.db);

I didn't seem to find any other SSL references in the /src/bin/psql
directory using grep, but I know that psql can be built with SSL
support so I was hoping to use the code for that as a template.

Thanks.
-Tony


10 Apr 2003 23:17:22 -0700
gar8@pitt.edu (Tony Reina)
Does libpq have SSL functions?

Yes.  Take a look at pg_hba.conf's hostssl option.  That will force SSL
for certain hosts.  You can also use 'requiressl' in your libpq
connection string.

---------------------------------------------------------------------------

Tony Reina wrote:
> I'd like to build some SSL functionality into my C functions that
> access the PostgreSQL database. My C functions are calling the
> routines from libpq. By chance, are there any SSL functions inherent
> to libpq for establishing a secure connection to the postmaster?
> 
> I mention this because I noticed in the source code for psql, the c
> file startup.c has the following line:
> 
> ssl = PQgetssl(pset.db);
> 
> I didn't seem to find any other SSL references in the /src/bin/psql
> directory using grep, but I know that psql can be built with SSL
> support so I was hoping to use the code for that as a template.
> 
> Thanks.
> -Tony
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073


Tue, 15 Apr 2003 17:19:27 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Does libpq have SSL functions?