Using SSL with database <-> webserver connections. - Mailing list pgsql-admin

From C. Bensend
Subject Using SSL with database <-> webserver connections.
Date
Msg-id Pine.BSO.4.33L2.0108092133280.28047-100000@fusion.bennyvision.com
Whole thread Raw
List pgsql-admin
Hey folks,

    I'm hoping this question is suitable for this group.
I did do some archive searches on the PHP mailing lists, with
either no hits, or a billion.

    My ultimate goal is to have all connections between
my webserver and the database server use SSL.  I have both
the database and psql (two separate OpenBSD machines)
compiled with SSL built-in, and that works fine.

    Now, within the PHP code on the webserver, I need
to open the connection using SSL if possible.  Using the
resources on php.net, I need to:

pg_Connect("host=myHost port=myPort tty=myTTY options=myOptions
dbname=myDB user=myUser password=myPassword ");

    That's fine - I can handle that.  However, that's as
much detail as they give towards the options.  My question is,
does anyone here know what specific option I can put in the
connect string to use SSL only?  Is this possible?

    I'm hoping that some kind soul can give me a quick
response - I'd rather not wade through the signal-to-noise
ratio over on the PHP lists.  If this is completely off-topic,
I will.  Just send me a polite "Go over there, idiot."  :)

Thanks much!

Benny


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"I find your lack of clue...disturbing" - Sysadmin Vader.
- Quote from a .sig file, on the MailMan users mailing list



pgsql-admin by date:

Previous
From: reina@nsi.edu (Tony Reina)
Date:
Subject: Re: Finding number of current connections
Next
From: Grant
Date:
Subject: Postgresql and large objects.