{"url":"https://itoasuka.hatenadiary.org/entry/20061224/1166927090","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fitoasuka.hatenadiary.org%2Fentry%2F20061224%2F1166927090\" title=\" ubuntu \u30e1\u30e2 - \u30a4\u30c8\u30a6 \u30a2\u30b9\u30ab blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2006-12-24 11:24:50","description":"\u3044\u3064\u3082\u306e Linux \u30e6\u30fc\u30b6\uff08\u975eroot\u3001\u975epostgres\uff09\u304b\u3089 PostgreSQL \u306b postgres \u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u307e\u3067\u3002 \u307e\u305a Linux \u30e6\u30fc\u30b6 postgres \u306b\u306a\u308b\u3002 $ sudo su - postgres PostgreSQL \u306b\u63a5\u7d9a\u3059\u308b\u3002 $ psql template1 PostgreSQL \u30a2\u30ab\u30a6\u30f3\u30c8 postgres \u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3002 template1=# alter user postgres with password '\u30d1\u30b9\u30ef\u30fc\u30c9'; ALTER USER template1=# \\q \u4ee5\u4e0a\u3002","categories":["Linux","PostgreSQL"],"type":"rich","author_url":"https://blog.hatena.ne.jp/itoasuka/","image_url":null,"blog_url":"https://itoasuka.hatenadiary.org/","blog_title":"\u30a4\u30c8\u30a6 \u30a2\u30b9\u30ab blog","version":"1.0","provider_url":"https://hatena.blog","author_name":"itoasuka","height":"190","title":" ubuntu \u30e1\u30e2","width":"100%","provider_name":"Hatena Blog"}