Thanks and just an update....

The connection to AWS services requires an SSH Tunnel and a plain connection through it. I just have to use the PEM file and ssh command line to open a session whice enables the tunnel between a local port and the remote port in the server where Postgres runs. The only thing I had to do in my scripts was to change the local port number in the connection string in order to get into the tunnel and, as I supposed, the sslmode was not required.

Well, when I started this thread, I was thinking that there probably existed a module to provide the SSH tunnel without the dummy shell, but now I have to call an external non-perl script to set up the tunnel before trying to connect to the remote database, and deal with an unexpected close of the tunnel.

BTW, psql tool also requires the tunnel to reach AWS postgresql databases.

In reply to Re: Connecting to a database in AWS using SSL by vitoco
in thread Connecting to a database in AWS using SSL by vitoco

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.