{"height":"190","provider_url":"https://hatena.blog","url":"https://bg1.hatenablog.com/entry/2025/04/23/210000","categories":["PostgreSQL"],"published":"2025-04-23 21:00:00","version":"1.0","provider_name":"Hatena Blog","type":"rich","author_name":"BG1","width":"100%","blog_url":"https://bg1.hatenablog.com/","blog_title":"\u8eca\u8f2a\u306ex\u767a\u660e ~B.G's Blog~","title":"peer(pg_hba.conf)","description":"\u65b0\u3057\u3044\u30ed\u30fc\u30eb\u3092\u8ffd\u52a0\u3057\u3066\u3001\u305d\u308c\u3067psql\u8d77\u52d5\u3057\u3088\u3046\u3068\u3057\u3066\u5931\u6557\u3059\u308b\u306e\u306f\u3001pg_hba.conf\u306e\u8a2d\u5b9a\u304c\u539f\u56e0\u3002https://www.postgresql.jp/docs/9.4/auth-pg-hba-conf.htmlcreateuser\u306b\"-P\"\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u30bb\u30c3\u30c8\u3059\u308b\u5f62\u3067\u8ffd\u52a0\u3002 postgres@vbox:~$ createuser -P testuser1 \u65b0\u3057\u3044\u30ed\u30fc\u30eb\u306e\u305f\u3081\u306e\u30d1\u30b9\u30ef\u30fc\u30c9: \u3082\u3046\u4e00\u5ea6\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\uff1a postgres@vbox:~$ psql psql (16.8) \"help\"\u3067\u30d8\u30eb\u30d7\u3092\u8868\u793a\u3057\u307e\u3059\u3002 postgres=# \\du \u30ed\u30fc\u30eb\u4e00\u89a7 \u30ed\u30fc\u30eb\u540d | \u5c5e\u2026","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/B/BG1/20250414/20250414194918.png","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbg1.hatenablog.com%2Fentry%2F2025%2F04%2F23%2F210000\" title=\"peer(pg_hba.conf) - \u8eca\u8f2a\u306ex\u767a\u660e ~B.G&#39;s Blog~\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/BG1/"}