From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ravi Krishna <srkrishna(at)yahoo(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Two things bit baffling in RDS PG |
Date: | 2018-05-03 21:05:03 |
Message-ID: | CAKFQuwaBDfvw1F2vsSLc27gZ61R4-y4dbxjxfstYGA+rNPThHQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Markus | 2018-05-04 08:09:13 | Query planner riddle (array-related?) |
Previous Message | Ravi Krishna | 2018-05-03 20:18:44 | Two things bit baffling in RDS PG |