{"id":5470,"date":"2021-06-07T16:56:11","date_gmt":"2021-06-07T07:56:11","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=5470"},"modified":"2023-01-27T12:38:56","modified_gmt":"2023-01-27T03:38:56","slug":"heroku-postgres-%e3%81%a8-mysql%e3%81%ae%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e8%a9%a6%e3%81%97%e3%81%a6%e3%81%bf%e3%81%9fsyniti-dr","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/5470","title":{"rendered":"Heroku Postgres \u3068 \u7570\u7a2eDB\u9593\u3067\u306e\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30fb\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u691c\u8a3c\u30fb\u78ba\u8a8d[Syniti DR]"},"content":{"rendered":"\n

Heroku <\/a>\u306f\u7c21\u5358\u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u304b\u3089\u5b9f\u884c\u3001\u904b\u7528\u307e\u3067\u306e\u3059\u3079\u3066\u3092\u30af\u30e9\u30a6\u30c9\u3067\u5b8c\u7d50\u3067\u304d\u308b PaaS\u3067\u3059\u3002\u3053\u306eHeroku \u304c\u4f7f\u7528\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3042\u308b Heroku Postgres<\/strong> \u3068\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306e\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306e\u30c7\u30fc\u30bf\u306e\u9023\u643a\u3092\u7c21\u5358\u306b\u884c\u3044\u305f\u3044\u3068\u3044\u3046\u58f0\u3092\u3088\u304f\u805e\u304d\u307e\u3059\u3002<\/p>\n

\u4eca\u56de\u306f\u5b9f\u969b\u306bSyniti DR(Data Replication)\u306b\u3088\u308b\u3001Heroku Postgres \u3092\u4f7f\u7528\u3057\u305f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u8a66\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\n

Syniti DR<\/a>\u3068\u306f\uff1a
\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u9593\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3048\u308b\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2Syniti DR\u3002\u30a8\u30fc\u30b8\u30a7\u30f3\u30c8\u30ec\u30b9\u306a\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u3092\u63a1\u7528\u3057\u3066\u3044\u308b\u306e\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306b\u4f9d\u5b58\u305b\u305a\u3001\u4f8b\u3048\u3070Heroku Postgres\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3042\u3063\u3066\u3082\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u65bd\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\u307e\u305f\u3001Syniti DR \u306f\u3001\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u4e0a\u306b\u3042\u308b\u3001Oracle, SQL Server,DB2 (AS\/400)\u3068\u3044\u3063\u305f\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3042\u3063\u3066\u3082\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<\/blockquote>\n

\"\"<\/a><\/p>\n

\u00a0<\/p>\n\n\n\n

\u3053\u3061\u3089<\/a>\u3088\u308a\u3001Heroku Postgres \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u7d10\u3065\u3051\u308b\u4eee\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u3001Heroku Postgres \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u3092\u3057\u307e\u3059\u3002<\/p>\n

\u307e\u305a\u306f\u3001\u4eee\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002
Create new app \u3092\u30af\u30ea\u30c3\u30af\u3057\u3001\u65b0\u898f\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002
\"\"<\/a>\u4efb\u610f\u306e\u30a2\u30d7\u30ea\u540d(herokupostgres-app)\u3092\u5165\u529b\u3057\u3001Create app \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u4eee\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u5b8c\u6210\u3067\u3059\u3002
\"\"<\/a><\/p>\n

\u6b21\u306bHeroku Postgres \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002
\u53f3\u4e0a\u306e\u30bf\u30d6\u3088\u308a\u3001Data \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\"\"<\/a>\u305d\u306e\u5f8c\u3001Heroku Postgres \u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u3001Create one \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\"\"<\/a>\u6b21\u306b\u3001Install heroku Postgres \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\"\"<\/a>\u6b21\u306b\u3001Heroku Postgres \u3068\u7d10\u3065\u3051\u3092\u884c\u3046\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u9078\u629e\u3057\u307e\u3059\u3002
\u4eca\u56de\u306f\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f\u3001\u4eee\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3(herokupostgres-app)\u3092\u6307\u5b9a\u3057\u3001Submit Order Form \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u3067\u3001Heroku Postgres \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002
\"\"<\/a>

<\/p>\n

Heroku Postgres \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210\u304c\u5b8c\u4e86\u3057\u305f\u306e\u3067\u3001\u8a8d\u8a3c\u60c5\u5831\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002
\u5148\u307b\u3069\u7d10\u3065\u3051\u3092\u884c\u3063\u305f\u3001Heroku Postgres \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001
\"\"<\/a>Setting \u30bf\u30d6\u3088\u308a\u3001View Credentials… \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002
\"\"<\/a>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u304c\u5fc5\u8981\u306a\u8a8d\u8a3c\u60c5\u5831(Host,Database,User,Port,Password) \u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002
\"\"<\/a><\/p>\n

\u3053\u308c\u306b\u3066\u3001Heroku Postgres \u306e\u8a8d\u8a3c\u60c5\u5831\u306e\u78ba\u8a8d\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n

\u5f8c\u306f\u3001\u5148\u307b\u3069\u78ba\u8a8d\u3057\u305f\u8a8d\u8a3c\u60c5\u5831\u3092\u5143\u306bSyniti DR\u306e\u753b\u9762\u3067\u63a5\u7d9a\u8a2d\u5b9a\u3092\u884c\u3044\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u8a2d\u5b9a\u3092\u884c\u3046\u3060\u3051\u3067\u3059\u3002
\"\"<\/a><\/p>\n

\u3053\u306e\u3088\u3046\u306b\u3001Syniti DR\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306e\u3042\u3089\u3086\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092Heroku Postgres \u306b\u79fb\u884c\u3059\u308b\u3053\u3068\u3084\u3001Heroku Postgres \u306e\u30c7\u30fc\u30bf\u3092\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u79fb\u884c\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002
\u4ed6\u306b\u3082\u3001\u307b\u307c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306a\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u3088\u308a\u3001\u30aa\u30f3\u30d7\u30ec\u30df\u30b9DB\u306e\u30c7\u30fc\u30bf\u3092\u5229\u7528\u3057\u3066\u3001Heroku\u4e0a\u3067\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u958b\u767a\u304c\u53ef\u80fd\u3067\u3059\u3002
\u307e\u305f\u3001\u53cc\u65b9\u5411\u306e\u5dee\u5206\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3082\u5b9f\u65bd\u3067\u304d\u3001\u30cf\u30a4\u30d6\u30ea\u30c3\u30c9\u30af\u30e9\u30a6\u30c9\u306e\u904b\u7528\u304c\u53ef\u80fd\u3068\u306a\u3063\u3066\u304a\u308a\u307e\u3059\u3002
Syniti DR\u306e\u8a73\u7d30\u306b\u95a2\u3057\u3066\u306f\u3001\u3053\u3061\u3089<\/a>\u3088\u308a\u304a\u554f\u3044\u5408\u308f\u305b\u304f\u3060\u3055\u3044\u3002

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

Heroku \u306f\u7c21\u5358\u306b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u958b\u767a\u304b\u3089\u5b9f\u884c\u3001\u904b\u7528\u307e\u3067\u306e\u3059\u3079\u3066\u3092\u30af\u30e9\u30a6\u30c9\u3067\u5b8c\u7d50\u3067\u304d\u308b PaaS\u3067\u3059\u3002\u3053\u306eHeroku \u304c\u4f7f\u7528\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3042\u308b Heroku Postgres \u3068\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u306e\u7570\u7a2e\u30c7\u30fc\u30bf\u30d9 … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[66,171,339,362,363],"class_list":["post-5470","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-postgresql","tag-salesforce","tag-339","tag-heroku-postgres","tag-heroku"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=5470"}],"version-history":[{"count":40,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5470\/revisions"}],"predecessor-version":[{"id":6370,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5470\/revisions\/6370"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=5470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=5470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=5470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}