{"id":12976,"date":"2019-09-02T14:06:12","date_gmt":"2019-09-02T05:06:12","guid":{"rendered":"http:\/\/www.manageengine.jp\/support\/kb\/OpManager\/?p=12976"},"modified":"2022-06-13T14:51:26","modified_gmt":"2022-06-13T05:51:26","slug":"%e3%82%a4%e3%83%99%e3%83%b3%e3%83%88%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%81%ae%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%e3%83%aa%e3%82%b9%e3%83%88%e3%82%a2%e6%89%8b%e9%a0%86","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/?p=12976","title":{"rendered":"\u30a4\u30d9\u30f3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\/\u30ea\u30b9\u30c8\u30a2\u624b\u9806"},"content":{"rendered":"

\u8981\u671b<\/h2>\n

OpManager\/bin\/backup\/BackUp.bat(sh)\u3067\u306f\u30a4\u30d9\u30f3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306b
\n\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u304c\u3001\u30a4\u30d9\u30f3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\/\u30ea\u30b9\u30c8\u30a2\u3092\u884c\u3044\u305f\u3044\u3002<\/p>\n

\u89e3\u6c7a\u65b9\u6cd5<\/h2>\n

\u203b\u6b21\u306e\u624b\u9806\u306f\u540c\u4e00\u30d3\u30eb\u30c9\u3067\u5b9f\u65bd\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

1.\u30af\u30a8\u30ea\u306e\u5b9f\u884c<\/h5>\n

\u6b21\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3001\u30a4\u30d9\u30f3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n

\u3000select * from pg_tables where tablename like 'event_2%';<\/em><\/p>\n

\u30af\u30a8\u30ea\u5b9f\u884c\u7d50\u679c\u306etablename\u30ab\u30e9\u30e0\u3092\u53c2\u7167\u3057\u3001
\n\"event_YYYY_MM_DD_HH\"\u5f62\u5f0f\u306e\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u63a7\u3048\u307e\u3059\u3002
\n\u4f8b\uff1a
\nEvent_2018_08_28_22<\/p>\n

\u4e0a\u8a18\u30af\u30a8\u30ea\u306f\u3001OpManager\u306eGUI\u4e0a\u306e\u30af\u30a8\u30ea\u5b9f\u884c\u6a5f\u80fd\u3067\u306f\u5b9f\u884c\u3067\u304d\u305a\u3001
\nOpManager\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u76f4\u63a5\u63a5\u7d9a\u3057\u3066\u5b9f\u884c\u3059\u308b\u5fc5\u8981\u304c\u3054\u3056\u3044\u307e\u3059\u3002<\/p>\n

\u25cf\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(PostgreSQL)\u3078\u306e\u63a5\u7d9a\u65b9\u6cd5\uff1a
\nhttps:\/\/www.manageengine.jp\/support\/kb\/OpManager\/?p=3207<\/a><\/p>\n

2. \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u65b9\u6cd5<\/h5>\n

2-1. OpManager\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3057\u3001\u6b21\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u5b58\u5728\u3057\u306a\u3044\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002
\njava\u3001postgres\u3001wrapper<\/em>
\n\u203bOpManager\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u6b8b\u5b58\u3057\u3066\u3044\u308b\u5834\u5408\u306e\u5bfe\u5fdc\u65b9\u6cd5
\nhttp:\/\/www.manageengine.jp\/support\/kb\/OpManager\/?p=8535<\/a>
\n2-2. \u7ba1\u7406\u8005\u6a29\u9650\u3067\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8(Windows)\u307e\u305f\u306f\u30bf\u30fc\u30df\u30ca\u30eb(Linux)\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002
\n2-3. \\OpManager\\bin\\\u306b\u79fb\u52d5\u3057\u3001
\nstartPgSQL.bat(sh)<\/em>
\n\u3092\u5b9f\u884c\u3057\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002
\n2-4. \u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\/\u30bf\u30fc\u30df\u30ca\u30eb\u4e0a\u3067\\OpManager\\pgsql\\bin\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002
\n2-5. \u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u53d6\u5f97\u3057\u307e\u3059\u3002<\/p>\n

\u3000\u3000pg_dump -h 127.0.0.1 -p 13306 -U dbuser -a -t <TableName> -f \"<FilePath>\/<TableName>.bkp\" OpManagerDB<\/em>
\n\u4f8b\uff1a
\n\u3000\u3000pg_dump -h 127.0.0.1 -p 13306 -U dbuser -a -t event_2018_08_28_22 -f \"\/opt\/OpManager\/event_2018_08_28_22.bkp\"<\/em> OpManagerDB<\/em><\/p>\n

\u30d0\u30fc\u30b8\u30e7\u30f312.5\u672a\u6e80\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u3054\u5229\u7528\u306e\u5834\u5408\u306f\u300cdbuser\u300d\u3092\u300cpostgres\u300d\u306b\u7f6e\u304d\u63db\u3048\u3066\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044<\/div>\n

2-6. \\OpManager\\bin\\\u306b\u79fb\u52d5\u3057\u3001
\nstopPgSQL.bat(sh)<\/em>
\n\u3092\u5b9f\u884c\u3057\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u505c\u6b62\u3057\u307e\u3059\u3002<\/p>\n

3. \u30ea\u30b9\u30c8\u30a2\u65b9\u6cd5<\/h5>\n

3-1. \u6b21\u306eURL\u306e\u624b\u9806\u3067BackUp.bat(sh)\u3067\u53d6\u5f97\u3057\u305f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30ea\u30b9\u30c8\u30a2\u3057\u307e\u3059\u3002
\n\u30fbPostgreSQL\u3092\u4f7f\u7528\u3057\u305f\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30fb\u30ea\u30b9\u30c8\u30a2\u306e\u65b9\u6cd5\u3092\u77e5\u308a\u305f\u3044
\nhttps:\/\/www.manageengine.jp\/support\/kb\/OpManager\/?p=89<\/a>
\n3-2. \u7ba1\u7406\u8005\u6a29\u9650\u3067\u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8(Windows)\u307e\u305f\u306f\u30bf\u30fc\u30df\u30ca\u30eb(Linux)\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002
\n3-3. \\OpManager\\bin\\\u306b\u79fb\u52d5\u3057\u3001
\nstartPgSQL.bat(sh)<\/em>
\n\u3092\u5b9f\u884c\u3057\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8d77\u52d5\u3057\u307e\u3059\u3002
\n3-4. \u30b3\u30de\u30f3\u30c9\u30d7\u30ed\u30f3\u30d7\u30c8\/\u30bf\u30fc\u30df\u30ca\u30eb\u4e0a\u3067\\OpManager\\pgsql\\bin\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002
\n3-5. \u6b21\u306eURL\u3092\u53c2\u8003\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3001\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u305d\u308c\u305e\u308c\u5b9f\u884c\u3057\u307e\u3059\u3002
\n\u30fb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(PostgreSQL)\u3078\u306e\u63a5\u7d9a\u65b9\u6cd5
\nhttps:\/\/www.manageengine.jp\/support\/kb\/OpManager\/?p=3207<\/a><\/p>\n

DROP TABLE\u00a0<TableName>;<\/em><\/p>\n

CREATE TABLE <TableName> (id integer not null, text text,category character varying(100),ddomain character varying(100),network character varying(100),node character varying(100),entity character varying(250),severity integer,ttime bigint,source character varying(100),helpurl character varying(100),webnms character varying(100),groupname character varying(100),ownername character varying(25) not null,alarmcode text, displayname character varying(100),eventtype character varying(255), pollid bigint not null default (-1));<\/em><\/p>\n

ALTER TABLE <TableName> ADD CONSTRAINT <TableName>_pkey PRIMARY KEY(\"id\",\"ownername\");<\/em><\/p>\n

\u4f8b\uff1a<\/p>\n

DROP TABLE event_2018_08_28_22<\/em>;<\/em><\/p>\n

CREATE TABLE event_2018_08_28_22 (id integer not null, text text,category character varying(100),ddomain character varying(100),network character varying(100),node character varying(100),entity character varying(250),severity integer,ttime bigint,source character varying(100),helpurl character varying(100),webnms character varying(100),groupname character varying(100),ownername character varying(25) not null,alarmcode text, displayname character varying(100),eventtype character varying(255), pollid bigint not null default (-1));<\/em><\/p>\n

ALTER TABLE event_2018_08_28_22 ADD CONSTRAINT event_2018_08_28_22_pkey PRIMARY KEY(\"id\",\"ownername\");<\/em><\/p>\n

3-6. \u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001DB\u304b\u3089\u30ed\u30b0\u30a2\u30a6\u30c8\u3057\u307e\u3059\u3002
\n\\q
\n3-7. \u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u30ea\u30b9\u30c8\u30a2\u3057\u307e\u3059\u3002
\npsql -U postgres -h 127.0.0.1 -p 13306 -f \"<BKPFilePath>\" OpManagerDB<\/em>
\n\u4f8b\uff1a
\npsql -U postgres -h 127.0.0.1 -p 13306 -f \"\/opt\/OpManager\/event_2018_08_28_22.bkp\" OpManagerDB<\/em>
\n3-8. \\OpManager\\bin\\\u306b\u79fb\u52d5\u3057\u3001
\nstopPgSQL.bat(sh)<\/em>
\n\u3092\u5b9f\u884c\u3057\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u505c\u6b62\u3057\u307e\u3059\u3002<\/p>\n

\u3010\u5bfe\u5fdc\u30d3\u30eb\u30c9\u3011\u3059\u3079\u3066<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u8981\u671b OpManager\/bin\/backup\/BackUp.bat(sh)\u3067\u306f\u30a4\u30d9\u30f3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306b \u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u304c\u3001\u30a4\u30d9\u30f3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u2026 \uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"yes","_lmt_disable":"","footnotes":""},"categories":[9,13],"tags":[],"class_list":["post-12976","post","type-post","status-publish","format-standard","hentry","category-2-install-opm","category-4-config-opm"],"modified_by":"koki","_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=\/wp\/v2\/posts\/12976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12976"}],"version-history":[{"count":15,"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=\/wp\/v2\/posts\/12976\/revisions"}],"predecessor-version":[{"id":20062,"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=\/wp\/v2\/posts\/12976\/revisions\/20062"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/OpManager\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}