{"width":"100%","version":"1.0","published":"2006-07-17 16:17:27","type":"rich","author_url":"https://blog.hatena.ne.jp/dayflower/","provider_name":"Hatena Blog","height":"190","image_url":null,"url":"https://dayflower.hatenablog.com/entry/20060717/1153120647","blog_title":"daily dayflower","provider_url":"https://hatena.blog","blog_url":"https://dayflower.hatenablog.com/","categories":["db"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdayflower.hatenablog.com%2Fentry%2F20060717%2F1153120647\" title=\" pg_restore \u3067 --table \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u306a\u3044\u307b\u3046\u304c\u3088\u3044 - daily dayflower\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"% pg_dump -Fc -t my_table -Z 9 -U dbuser mydb > my_table.dump\u307f\u305f\u3044\u306b\u30c6\u30fc\u30d6\u30eb\u5358\u4f4d\u3067\u5727\u7e2e\u30c0\u30f3\u30d7\u3057\u305f\u30c7\u30fc\u30bf\u3092\uff0c\u5ff5\u306e\u305f\u3081\u306b\uff0c\u3068\u601d\u3063\u3066 % pg_restore -c -Fc -t my_table -U dbuser -d mydb my_table.dump\u3068\u3057\u305f\u3089\uff0c\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u5fa9\u5e30\u3055\u308c\u306a\u3044\u308f GRANT \u306e\u60c5\u5831\u304c\u6d88\u3048\u308b\u308f\u3067\u56f0\u308a\u307e\u3057\u305f\u3002-t \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u305f\u3053\u3068\u3067\u300c\u307e\u3055\u306b\u305d\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30ad\u30fc\u30de\u3068\u30c7\u30fc\u30bf\u3060\u3051\u300d\u30ea\u30b9\u30c8\u30a2\u3057\u305f\u307f\u305f\u3044\u3067\u3059\u3002 % pg_restore -c -Fc -U dbuser -d mydb my_table.dum\u2026","title":" pg_restore \u3067 --table \u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u6307\u5b9a\u3057\u306a\u3044\u307b\u3046\u304c\u3088\u3044","author_name":"dayflower"}