{"url":"https://naga-sawa.hatenadiary.org/entry/20120918/1347967306","provider_url":"https://hatena.blog","version":"1.0","published":"2012-09-18 20:21:46","blog_url":"https://naga-sawa.hatenadiary.org/","width":"100%","blog_title":"..\u305f\u308c\u308d\u3050..","categories":["tips"],"author_name":"naga_sawa","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fnaga-sawa.hatenadiary.org%2Fentry%2F20120918%2F1347967306\" title=\" PostgreSQL pg_restore \u300c\u7b26\u53f7\u5316\u65b9\u5f0f&quot;UTF8&quot;\u3067\u7121\u52b9\u306a\u30d0\u30a4\u30c8\u30b7\u30fc\u30b1\u30f3\u30b9\u3067\u3059\u300d\u304b\u3089\u306e\u9003\u3052\u65b9 - ..\u305f\u308c\u308d\u3050..\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","author_url":"https://blog.hatena.ne.jp/naga_sawa/","title":" PostgreSQL pg_restore \u300c\u7b26\u53f7\u5316\u65b9\u5f0f\"UTF8\"\u3067\u7121\u52b9\u306a\u30d0\u30a4\u30c8\u30b7\u30fc\u30b1\u30f3\u30b9\u3067\u3059\u300d\u304b\u3089\u306e\u9003\u3052\u65b9","height":"190","description":"\u53e4\u3044 PostgreSQL \u3067 pg_dump \u3057\u305f\u30c0\u30f3\u30d7\u3092\u3001\u6700\u8fd1\u306e PostgreSQL \u3067 pg_restore \u3057\u3088\u3046\u3068\u3057\u305f\u3068\u304d\u306b\u3001\u300cUTF-8\u306e\u30d0\u30a4\u30c8\u30b7\u30fc\u30b1\u30f3\u30b9\u304c\u304a\u304b\u3057\u3044\u300d\u3068\u6012\u3089\u308c\u305f\u5834\u5408\u306e\u9003\u3052\u65b9\u3002 $ pg_restore -U postgres -d db3 db3_dump.pgdmp pg_restore: [\u30a2\u30fc\u30ab\u30a4\u30d0(db)] TOC\u51e6\u7406\u4e2d\u306b\u30a8\u30e9\u30fc\u304c\u3042\u308a\u307e\u3057\u305f: pg_restore: [\u30a2\u30fc\u30ab\u30a4\u30d0(db)] TOC\u30a8\u30f3\u30c8\u30ea194; 0 48277 TABLE DATA attachments postgres\u306e\u30a8\u30e9\u30fc\u3067\u3059 pg_restore: [\u30a2\u30fc\u30ab\u30a4\u30d0(db)] CO\u2026","provider_name":"Hatena Blog"}