{"action":"created","comment":{"url":"https://api.github.com/repos/dcos/examples/pulls/comments/197306542","pull_request_review_id":131023746,"id":197306542,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDE5NzMwNjU0Mg==","diff_hunk":"@@ -0,0 +1,62 @@\n+# Setting up Postgres on DC/OS for Artifactory\n+\n+## Prerequisites\n+\n+- DC/OS 1.11 or later with at least one public agent\n+- [DC/OS CLI installed](https://dcos.io/docs/1.10/usage/cli/install/) and\n+  configured to use your cluster\n+\n+## Setting up Postgres:\n+\n+1. Create a new file called `postgresql-options.json` with following content:\n+\n+```\n+{\n+  \"service\": {\n+    \"name\": \"postgresql\"\n+  },\n+  \"postgresql\": {\n+    \"cpus\": 0.5,\n+    \"mem\": 512\n+  },\n+  \"database\": {\n+    \"username\": \"jfrogdcos\",\n+    \"password\": \"jfrogdcos\",\n+    \"dbname\": \"artifactory\"\n+  },\n+  \"storage\": {\n+    \"host_volume\": \"/tmp\",\n+    \"pgdata\": \"pgdata\",\n+    \"persistence\": {\n+      \"enable\": false,\n+      \"volume_size\": 512,\n+      \"external\": {\n+        \"enable\": false,\n+        \"volume_name\": \"postgresql\",\n+        \"provider\": \"dvdi\",\n+        \"driver\": \"rexray\"\n+      }\n+    }\n+  },\n+  \"networking\": {\n+    \"port\": 5432,\n+    \"host_mode\": true,\n+    \"external_access\": {\n+      \"enable\": false,\n+      \"external_access_port\": 15432\n+    }\n+  }\n+}\n+```\n+\n+2. Run this command to install Postgres:\n+\n+```\n+dcos package install --options=postgresql-options.json postgresql\n+```\n+\n+3. Make sure Postgres is running and is healthy by looking under the Services tab\n+   in the DC/OS UI.\n+\n+This should be sufficient to trial the Artifactory package but we do not\n+currently recommend using this for a production deployment of Artifactory.","path":"artifactory/1.11/install-postgres.md","position":62,"original_position":62,"commit_id":"4c40231aaad26124487ff137dd56aa049a9dffbd","original_commit_id":"4c40231aaad26124487ff137dd56aa049a9dffbd","user":{"login":"pleia2","id":879924,"node_id":"MDQ6VXNlcjg3OTkyNA==","avatar_url":"https://avatars1.githubusercontent.com/u/879924?v=4","gravatar_id":"","url":"https://api.github.com/users/pleia2","html_url":"https://github.com/pleia2","followers_url":"https://api.github.com/users/pleia2/followers","following_url":"https://api.github.com/users/pleia2/following{/other_user}","gists_url":"https://api.github.com/users/pleia2/gists{/gist_id}","starred_url":"https://api.github.com/users/pleia2/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pleia2/subscriptions","organizations_url":"https://api.github.com/users/pleia2/orgs","repos_url":"https://api.github.com/users/pleia2/repos","events_url":"https://api.github.com/users/pleia2/events{/privacy}","received_events_url":"https://api.github.com/users/pleia2/received_events","type":"User","site_admin":false},"body":"Could you give a hint here as to what you would want to use for production? A different database? Something that's HA or somehow distributed?","created_at":"2018-06-21T23:36:35Z","updated_at":"2018-06-21T23:38:26Z","html_url":"https://github.com/dcos/examples/pull/365#discussion_r197306542","pull_request_url":"https://api.github.com/repos/dcos/examples/pulls/365","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/dcos/examples/pulls/comments/197306542"},"html":{"href":"https://github.com/dcos/examples/pull/365#discussion_r197306542"},"pull_request":{"href":"https://api.github.com/repos/dcos/examples/pulls/365"}}},"pull_request":{"url":"https://api.github.com/repos/dcos/examples/pulls/365","id":195975919,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk1OTc1OTE5","html_url":"https://github.com/dcos/examples/pull/365","diff_url":"https://github.com/dcos/examples/pull/365.diff","patch_url":"https://github.com/dcos/examples/pull/365.patch","issue_url":"https://api.github.com/repos/dcos/examples/issues/365","number":365,"state":"open","locked":false,"title":"Updated Artifactory examples to version 5.11.1 on dcos 1.11","user":{"login":"maheshjfrog","id":35077604,"node_id":"MDQ6VXNlcjM1MDc3NjA0","avatar_url":"https://avatars0.githubusercontent.com/u/35077604?v=4","gravatar_id":"","url":"https://api.github.com/users/maheshjfrog","html_url":"https://github.com/maheshjfrog","followers_url":"https://api.github.com/users/maheshjfrog/followers","following_url":"https://api.github.com/users/maheshjfrog/following{/other_user}","gists_url":"https://api.github.com/users/maheshjfrog/gists{/gist_id}","starred_url":"https://api.github.com/users/maheshjfrog/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maheshjfrog/subscriptions","organizations_url":"https://api.github.com/users/maheshjfrog/orgs","repos_url":"https://api.github.com/users/maheshjfrog/repos","events_url":"https://api.github.com/users/maheshjfrog/events{/privacy}","received_events_url":"https://api.github.com/users/maheshjfrog/received_events","type":"User","site_admin":false},"body":"","created_at":"2018-06-19T22:29:33Z","updated_at":"2018-06-21T23:38:26Z","closed_at":null,"merged_at":null,"merge_commit_sha":"857216a916ceb3054623227ffc46424228ed3c83","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/dcos/examples/pulls/365/commits","review_comments_url":"https://api.github.com/repos/dcos/examples/pulls/365/comments","review_comment_url":"https://api.github.com/repos/dcos/examples/pulls/comments{/number}","comments_url":"https://api.github.com/repos/dcos/examples/issues/365/comments","statuses_url":"https://api.github.com/repos/dcos/examples/statuses/4c40231aaad26124487ff137dd56aa049a9dffbd","head":{"label":"maheshjfrog:master","ref":"master","sha":"4c40231aaad26124487ff137dd56aa049a9dffbd","user":{"login":"maheshjfrog","id":35077604,"node_id":"MDQ6VXNlcjM1MDc3NjA0","avatar_url":"https://avatars0.githubusercontent.com/u/35077604?v=4","gravatar_id":"","url":"https://api.github.com/users/maheshjfrog","html_url":"https://github.com/maheshjfrog","followers_url":"https://api.github.com/users/maheshjfrog/followers","following_url":"https://api.github.com/users/maheshjfrog/following{/other_user}","gists_url":"https://api.github.com/users/maheshjfrog/gists{/gist_id}","starred_url":"https://api.github.com/users/maheshjfrog/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maheshjfrog/subscriptions","organizations_url":"https://api.github.com/users/maheshjfrog/orgs","repos_url":"https://api.github.com/users/maheshjfrog/repos","events_url":"https://api.github.com/users/maheshjfrog/events{/privacy}","received_events_url":"https://api.github.com/users/maheshjfrog/received_events","type":"User","site_admin":false},"repo":{"id":135764621,"node_id":"MDEwOlJlcG9zaXRvcnkxMzU3NjQ2MjE=","name":"examples","full_name":"maheshjfrog/examples","owner":{"login":"maheshjfrog","id":35077604,"node_id":"MDQ6VXNlcjM1MDc3NjA0","avatar_url":"https://avatars0.githubusercontent.com/u/35077604?v=4","gravatar_id":"","url":"https://api.github.com/users/maheshjfrog","html_url":"https://github.com/maheshjfrog","followers_url":"https://api.github.com/users/maheshjfrog/followers","following_url":"https://api.github.com/users/maheshjfrog/following{/other_user}","gists_url":"https://api.github.com/users/maheshjfrog/gists{/gist_id}","starred_url":"https://api.github.com/users/maheshjfrog/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maheshjfrog/subscriptions","organizations_url":"https://api.github.com/users/maheshjfrog/orgs","repos_url":"https://api.github.com/users/maheshjfrog/repos","events_url":"https://api.github.com/users/maheshjfrog/events{/privacy}","received_events_url":"https://api.github.com/users/maheshjfrog/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/maheshjfrog/examples","description":"DC/OS examples","fork":true,"url":"https://api.github.com/repos/maheshjfrog/examples","forks_url":"https://api.github.com/repos/maheshjfrog/examples/forks","keys_url":"https://api.github.com/repos/maheshjfrog/examples/keys{/key_id}","collaborators_url":"https://api.github.com/repos/maheshjfrog/examples/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/maheshjfrog/examples/teams","hooks_url":"https://api.github.com/repos/maheshjfrog/examples/hooks","issue_events_url":"https://api.github.com/repos/maheshjfrog/examples/issues/events{/number}","events_url":"https://api.github.com/repos/maheshjfrog/examples/events","assignees_url":"https://api.github.com/repos/maheshjfrog/examples/assignees{/user}","branches_url":"https://api.github.com/repos/maheshjfrog/examples/branches{/branch}","tags_url":"https://api.github.com/repos/maheshjfrog/examples/tags","blobs_url":"https://api.github.com/repos/maheshjfrog/examples/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/maheshjfrog/examples/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/maheshjfrog/examples/git/refs{/sha}","trees_url":"https://api.github.com/repos/maheshjfrog/examples/git/trees{/sha}","statuses_url":"https://api.github.com/repos/maheshjfrog/examples/statuses/{sha}","languages_url":"https://api.github.com/repos/maheshjfrog/examples/languages","stargazers_url":"https://api.github.com/repos/maheshjfrog/examples/stargazers","contributors_url":"https://api.github.com/repos/maheshjfrog/examples/contributors","subscribers_url":"https://api.github.com/repos/maheshjfrog/examples/subscribers","subscription_url":"https://api.github.com/repos/maheshjfrog/examples/subscription","commits_url":"https://api.github.com/repos/maheshjfrog/examples/commits{/sha}","git_commits_url":"https://api.github.com/repos/maheshjfrog/examples/git/commits{/sha}","comments_url":"https://api.github.com/repos/maheshjfrog/examples/comments{/number}","issue_comment_url":"https://api.github.com/repos/maheshjfrog/examples/issues/comments{/number}","contents_url":"https://api.github.com/repos/maheshjfrog/examples/contents/{+path}","compare_url":"https://api.github.com/repos/maheshjfrog/examples/compare/{base}...{head}","merges_url":"https://api.github.com/repos/maheshjfrog/examples/merges","archive_url":"https://api.github.com/repos/maheshjfrog/examples/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/maheshjfrog/examples/downloads","issues_url":"https://api.github.com/repos/maheshjfrog/examples/issues{/number}","pulls_url":"https://api.github.com/repos/maheshjfrog/examples/pulls{/number}","milestones_url":"https://api.github.com/repos/maheshjfrog/examples/milestones{/number}","notifications_url":"https://api.github.com/repos/maheshjfrog/examples/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/maheshjfrog/examples/labels{/name}","releases_url":"https://api.github.com/repos/maheshjfrog/examples/releases{/id}","deployments_url":"https://api.github.com/repos/maheshjfrog/examples/deployments","created_at":"2018-06-01T21:23:27Z","updated_at":"2018-06-19T22:25:11Z","pushed_at":"2018-06-19T22:25:09Z","git_url":"git://github.com/maheshjfrog/examples.git","ssh_url":"git@github.com:maheshjfrog/examples.git","clone_url":"https://github.com/maheshjfrog/examples.git","svn_url":"https://github.com/maheshjfrog/examples","homepage":null,"size":108495,"stargazers_count":0,"watchers_count":0,"language":"Shell","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"dcos:master","ref":"master","sha":"0b98301e1a9c4b399deb363bbb0aa3f6a643e0a5","user":{"login":"dcos","id":17648048,"node_id":"MDEyOk9yZ2FuaXphdGlvbjE3NjQ4MDQ4","avatar_url":"https://avatars1.githubusercontent.com/u/17648048?v=4","gravatar_id":"","url":"https://api.github.com/users/dcos","html_url":"https://github.com/dcos","followers_url":"https://api.github.com/users/dcos/followers","following_url":"https://api.github.com/users/dcos/following{/other_user}","gists_url":"https://api.github.com/users/dcos/gists{/gist_id}","starred_url":"https://api.github.com/users/dcos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dcos/subscriptions","organizations_url":"https://api.github.com/users/dcos/orgs","repos_url":"https://api.github.com/users/dcos/repos","events_url":"https://api.github.com/users/dcos/events{/privacy}","received_events_url":"https://api.github.com/users/dcos/received_events","type":"Organization","site_admin":false},"repo":{"id":72442987,"node_id":"MDEwOlJlcG9zaXRvcnk3MjQ0Mjk4Nw==","name":"examples","full_name":"dcos/examples","owner":{"login":"dcos","id":17648048,"node_id":"MDEyOk9yZ2FuaXphdGlvbjE3NjQ4MDQ4","avatar_url":"https://avatars1.githubusercontent.com/u/17648048?v=4","gravatar_id":"","url":"https://api.github.com/users/dcos","html_url":"https://github.com/dcos","followers_url":"https://api.github.com/users/dcos/followers","following_url":"https://api.github.com/users/dcos/following{/other_user}","gists_url":"https://api.github.com/users/dcos/gists{/gist_id}","starred_url":"https://api.github.com/users/dcos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dcos/subscriptions","organizations_url":"https://api.github.com/users/dcos/orgs","repos_url":"https://api.github.com/users/dcos/repos","events_url":"https://api.github.com/users/dcos/events{/privacy}","received_events_url":"https://api.github.com/users/dcos/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/dcos/examples","description":"DC/OS examples","fork":false,"url":"https://api.github.com/repos/dcos/examples","forks_url":"https://api.github.com/repos/dcos/examples/forks","keys_url":"https://api.github.com/repos/dcos/examples/keys{/key_id}","collaborators_url":"https://api.github.com/repos/dcos/examples/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/dcos/examples/teams","hooks_url":"https://api.github.com/repos/dcos/examples/hooks","issue_events_url":"https://api.github.com/repos/dcos/examples/issues/events{/number}","events_url":"https://api.github.com/repos/dcos/examples/events","assignees_url":"https://api.github.com/repos/dcos/examples/assignees{/user}","branches_url":"https://api.github.com/repos/dcos/examples/branches{/branch}","tags_url":"https://api.github.com/repos/dcos/examples/tags","blobs_url":"https://api.github.com/repos/dcos/examples/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/dcos/examples/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/dcos/examples/git/refs{/sha}","trees_url":"https://api.github.com/repos/dcos/examples/git/trees{/sha}","statuses_url":"https://api.github.com/repos/dcos/examples/statuses/{sha}","languages_url":"https://api.github.com/repos/dcos/examples/languages","stargazers_url":"https://api.github.com/repos/dcos/examples/stargazers","contributors_url":"https://api.github.com/repos/dcos/examples/contributors","subscribers_url":"https://api.github.com/repos/dcos/examples/subscribers","subscription_url":"https://api.github.com/repos/dcos/examples/subscription","commits_url":"https://api.github.com/repos/dcos/examples/commits{/sha}","git_commits_url":"https://api.github.com/repos/dcos/examples/git/commits{/sha}","comments_url":"https://api.github.com/repos/dcos/examples/comments{/number}","issue_comment_url":"https://api.github.com/repos/dcos/examples/issues/comments{/number}","contents_url":"https://api.github.com/repos/dcos/examples/contents/{+path}","compare_url":"https://api.github.com/repos/dcos/examples/compare/{base}...{head}","merges_url":"https://api.github.com/repos/dcos/examples/merges","archive_url":"https://api.github.com/repos/dcos/examples/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/dcos/examples/downloads","issues_url":"https://api.github.com/repos/dcos/examples/issues{/number}","pulls_url":"https://api.github.com/repos/dcos/examples/pulls{/number}","milestones_url":"https://api.github.com/repos/dcos/examples/milestones{/number}","notifications_url":"https://api.github.com/repos/dcos/examples/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/dcos/examples/labels{/name}","releases_url":"https://api.github.com/repos/dcos/examples/releases{/id}","deployments_url":"https://api.github.com/repos/dcos/examples/deployments","created_at":"2016-10-31T14:13:28Z","updated_at":"2018-06-06T23:38:29Z","pushed_at":"2018-06-19T22:29:34Z","git_url":"git://github.com/dcos/examples.git","ssh_url":"git@github.com:dcos/examples.git","clone_url":"https://github.com/dcos/examples.git","svn_url":"https://github.com/dcos/examples","homepage":null,"size":107807,"stargazers_count":109,"watchers_count":109,"language":"Shell","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":136,"mirror_url":null,"archived":false,"open_issues_count":78,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":136,"open_issues":78,"watchers":109,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/dcos/examples/pulls/365"},"html":{"href":"https://github.com/dcos/examples/pull/365"},"issue":{"href":"https://api.github.com/repos/dcos/examples/issues/365"},"comments":{"href":"https://api.github.com/repos/dcos/examples/issues/365/comments"},"review_comments":{"href":"https://api.github.com/repos/dcos/examples/pulls/365/comments"},"review_comment":{"href":"https://api.github.com/repos/dcos/examples/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/dcos/examples/pulls/365/commits"},"statuses":{"href":"https://api.github.com/repos/dcos/examples/statuses/4c40231aaad26124487ff137dd56aa049a9dffbd"}},"author_association":"NONE"}}
{"actor":{"display_login":"pleia2"}}