Mike,<br><br>OGR's postgresql/postgis driver makes the connection using PQconnectdb() method from the libpq library.<br>You can set the option 'sslmode' to 'require', 'verify-ca' or 'verify-full' for a secure connection. Look for the documentation of PQconnectdb() for further details.<br>
<br><div class="gmail_quote">On Fri, Jan 28, 2011 at 12:13 AM, Mike Axelrod <span dir="ltr"><<a href="mailto:mike.axelrod@pictometry.com">mike.axelrod@pictometry.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Does ogr2ogr (and ogrinfo) natively support secure
connections to postgresql? </span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I need to run ogrinfo and ogr2ogr where the target is a
postgresql server elsewhere on the network (in a different domain) and secure
the communication.</span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p class="MsoNormal"><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Mike</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN">Mike
Axelrod, Software Engineer<br>
Pictometry International Corp.<br>
Suite A, 100 Town Centre Drive,
Rochester, NY 14623<br>
Phone: 585-775-7711<br>
E-mail: <a href="mailto:mike.axelrod@pictometry.com" target="_blank">mike.axelrod@pictometry.com</a> Web: </span><a href="http://www.pictometry.com/" target="_blank"><font size="2"><span style="font-size: 10pt;" lang="EN">http://www.Pictometry.com/</span></font></a></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
NOTICE: This message is covered by the Electronic Communications Privacy Act, Title 18, United States Code, Sections 2510-2521. This e-mail and any attached files are the exclusive property of Pictometry International Corp., are deemed privileged and confidential, and are intended solely for the use of the individual(s) or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or believe that you have received this message in error, please delete this e-mail and any attachments and notify the sender immediately. Any other use, re-creation, dissemination, forwarding or copying of this e-mail is strictly prohibited and may be unlawful.
</div>
<br>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br>
/tʃaɪθənjə/ /kʊmɑr/ <br>+91-9494447584<br>17.2416N 80.1426E<br>