Re: Two things bit baffling in RDS PG

On Thu, May 3, 2018 at 1:18 PM, Ravi Krishna <srkrishna(at)yahoo(dot)com> wrote:

> I am playing around with RDS PG and I am not able to understand the
> following:
>
> 1. The database name I created via RDS console is in upper case with no
> quotes. From the remote machine via psql,
> if I try to use lower case db name with the -d option it errors out
> "database not found". Works only with upper case.
> This behavior does not exist in non RDS env.
>

​Their console is apparently case-sensitive, creating the database with the
​exact capitalization you supplied. Basically it puts whatever you type
into double-quotes. I see nothing wrong with that decision.

>
> 2. Two RDS parameter group
>
> rds.force_ssl
> ssl
> have been set to 1 (true)
>
> yet from a remote machine I can connect to the database via psql
> without specifying any option for ssl. How is it doing ?
>
> psql (10.3 (Debian 10.3-1.pgdg90+1))
> SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
> bits: 256, compression: off)
>

​psql uses SSL if it detects the possibility during the connection
handshake. This isn't RDS-specific.

https://www.postgresql.org/docs/10/static/ssl-tcp.html

David J.
​