{"description":"\u30d0\u30c3\u30af\u30a2\u30c3\u30d7 \u65e2\u5b58DB\u306e\u30c0\u30f3\u30d7 OID\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u5fd8\u308c\u306a\u3044\u3088\u3046\u306b\u3002 2. To back up your database installation, type: pg_dumpall > outputfile If you need to preserve OIDs (such as when using them as foreign keys), then use the \"-o\" option when running pg_dumpall. pg_dumpall -o > /home/cutxout/db.out su su pgsql pg_ctl stop \u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u518d\u69cb\u2026","author_name":"cutxout","version":"1.0","categories":["db"],"url":"https://cutxout.hatenadiary.jp/entry/20051112/p1","provider_url":"https://hatena.blog","width":"100%","type":"rich","provider_name":"Hatena Blog","blog_url":"https://cutxout.hatenadiary.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcutxout.hatenadiary.jp%2Fentry%2F20051112%2Fp1\" title=\"PostgreSQL 8.1.0 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb - cutxout\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"PostgreSQL 8.1.0 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb","height":"190","image_url":"https://cdn-ak.d.st-hatena.com/diary/cutxout/2005-11-12.jpg","author_url":"https://blog.hatena.ne.jp/cutxout/","published":"2005-11-12 00:00:00","blog_title":"cutxout\u306e\u65e5\u8a18"}