{"blog_title":"ablog","author_name":"yohei-a","published":"2024-06-20 11:16:56","provider_url":"https://hatena.blog","url":"https://yohei-a.hatenablog.jp/entry/20240620/1718849816","type":"rich","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20240620%2F1718849816\" title=\"Redshift \u306bRedshift-managed VPCE \u7d4c\u7531\u3067\u63a5\u7d9a\u3057\u305f\u5834\u5408\u306e stl_connection_log.remotehost \u306b\u63a5\u7d9a\u5143\u30db\u30b9\u30c8\u306e IP \u30a2\u30c9\u30ec\u30b9\u304c\u5165\u308b\u304b - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://yohei-a.hatenablog.jp/","description":"\u7d50\u8ad6\u3068\u3057\u3066\u306f\u30ea\u30e2\u30fc\u30c8\u30db\u30b9\u30c8\u306e IP \u30a2\u30c9\u30ec\u30b9\u304c\u5165\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u305f\u3002 \u901a\u5e38\u306e\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3068 VPCE \u7d4c\u7531\u306e\u4e21\u65b9\u3067\u63a5\u7d9a\u3059\u308b \u901a\u5e38\u306e\u30af\u30e9\u30b9\u30bf\u30fc\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u304b\u3089\u63a5\u7d9a\u3057\u3066\u3001\u30af\u30a8\u30ea\u3092\u767a\u884c\u3001\u5207\u65ad\u3059\u308b\u3002 [ec2-user@ip-172-31-0-101 ~]$ curl http://169.254.169.254/latest/meta-data/hostname ip-172-31-0-101.ap-northeast-1.compute.internal [ec2-user@ip-172-31-0-101 ~]$ psql \"host=redshift-cluster-poc-central.*\u2026","categories":[],"height":"190","width":"100%","version":"1.0","image_url":null,"author_url":"https://blog.hatena.ne.jp/yohei-a/","title":"Redshift \u306bRedshift-managed VPCE \u7d4c\u7531\u3067\u63a5\u7d9a\u3057\u305f\u5834\u5408\u306e stl_connection_log.remotehost \u306b\u63a5\u7d9a\u5143\u30db\u30b9\u30c8\u306e IP \u30a2\u30c9\u30ec\u30b9\u304c\u5165\u308b\u304b","provider_name":"Hatena Blog"}