Redshift のユーザー名にハイフンとドットを使えることを確認したログをメモ。
[ec2-user@ip-172-31-0-101 ~]$ psql "host=redshift-cluster-poc-central.********.ap-northeast-1.redshift.amazonaws.com user=awsuser dbname=dev port=5439" Timing is on. psql (13.7, server 8.0.2) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help. awsuser 10:52 =# create user "ichiro-.suzuki" password 'Password123'; CREATE USER Time: 324.729 ms awsuser 10:53 =# select * from pg_user; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig ------------------------------+----------+-------------+----------+-----------+----------+----------+--------------------------------------- （中略） ichiro-.suzuki | 199 | f | f | f | ******** | | (25 rows) Time: 4.930 ms awsuser 10:53 =# \q [ec2-user@ip-172-31-0-101 ~]$ psql "host=redshift-cluster-poc-central.********.ap-northeast-1.redshift.amazonaws.com user=ichiro-.suzuki dbname=dev port=5439" Password for user ichiro-.suzuki: Timing is on. psql (13.7, server 8.0.2) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help. ichiro-.suzuki 10:54 => select current_user; current_user ---------------- ichiro-.suzuki (1 row) Time: 5.003 ms ichiro-.suzuki 10:54 =>
