{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fint128.hatenablog.com%2Fentry%2F2017%2F12%2F20%2F202236\" title=\"GitLab\u3067RDS for PostgreSQL\u3092\u4f7f\u3046 - GeekFactory\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","image_url":null,"published":"2017-12-20 20:22:36","blog_title":"GeekFactory","description":"GitLab\u3067RDS for PostgreSQL\u3092\u4f7f\u3046\u5834\u5408\u306b\u30cf\u30de\u3063\u305f\u306e\u3067\u30e1\u30e2\u3067\u3059\u3002 TL;DR GitLab\u3092\u8d77\u52d5\u3057\u305f\u969b\u306e\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u30b9\u30af\u30ea\u30d7\u30c8\u3067 CREATE EXTENSION pg_trgm; \u304c\u5b9f\u884c\u3055\u308c\u308b\u304c\u3001\u4e00\u822c\u30e6\u30fc\u30b6\u306f CREATE EXTENSION \u306e\u6a29\u9650\u3092\u6301\u3063\u3066\u3044\u306a\u3044\u306e\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3059\u3002 \u3042\u3089\u304b\u3058\u3081\u3001\u30b9\u30fc\u30d1\u30fc\u30e6\u30fc\u30b6\u3067\u5f53\u8a72SQL\u3092\u5b9f\u884c\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 \u5177\u4f53\u7684\u306a\u4e8b\u8c61\u3068\u5bfe\u7b56 \u307e\u305a\u3001GitLab\u304c\u4f7f\u3046\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002 # postgres\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a psql -h $RDS_HOST -U $RDS_ADMIN postgres -- \u30c7\u30fc\u30bf\u2026","type":"rich","blog_url":"https://int128.hatenablog.com/","height":"190","categories":["gitlab"],"provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/int128/","provider_name":"Hatena Blog","title":"GitLab\u3067RDS for PostgreSQL\u3092\u4f7f\u3046","version":"1.0","author_name":"int128","url":"https://int128.hatenablog.com/entry/2017/12/20/202236"}