pg_dump with ssl certificates I would like to run the pg_dump command from a remote host off my database server that only allows fully verified certificate based connections. How should I go about doing this? The man pages for 9.1 state the instructions for connecting via password from what I could see.
The following worked for me:

pg_dump "port=&lt;port&gt; host=&lt;host&gt; user=&lt;user&gt; dbname=&lt;db&gt; sslcert=&lt;cert&gt; sslkey=&lt;key&gt; sslrootcert=&lt;ca.crt&gt; sslmode=verify-ca" -f &lt;file&gt;