{"published":"2025-04-24 21:00:00","blog_title":"\u8eca\u8f2a\u306ex\u767a\u660e ~B.G's Blog~","version":"1.0","width":"100%","blog_url":"https://bg1.hatenablog.com/","author_name":"BG1","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbg1.hatenablog.com%2Fentry%2F2025%2F04%2F24%2F210000\" title=\"md5(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>","categories":["PostgreSQL"],"type":"rich","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/B/BG1/20250414/20250414201143.png","height":"190","author_url":"https://blog.hatena.ne.jp/BG1/","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","description":"md5\u306b\u3059\u308b\u3053\u3068\u3067\u3001Linux\u30e6\u30fc\u30b6\u306a\u3057\u306b\u3001\u30ed\u30fc\u30eb\u306b\u30bb\u30c3\u30c8\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u3060\u3051\u3067\u8a8d\u8a3c\u3059\u308b\u3088\u3046\u306b\u3059\u308b\u3002https://www.postgresql.jp/docs/9.4/auth-pg-hba-conf.html local\u3092md5\u306b\u3059\u308b\u3002local\u3092md5\u306b\u3059\u308b\u3002 postgres@vbox:~/data$ su \u30d1\u30b9\u30ef\u30fc\u30c9: root@vbox:/var/lib/pgsql/data# systemctl restart postgresql root@vbox:/var/lib/pgsql/data# exit exit postgres@vbox:~/data$ psql -U test\u2026","url":"https://bg1.hatenablog.com/entry/2025/04/24/210000","title":"md5(pg_hba.conf)"}