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 ?