{"action":"created","comment":{"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/comments/26199695","id":26199695,"diff_hunk":"@@ -0,0 +1,63 @@\n+# UnifiedPush Server - Migration guide\n+\n+For the database migration you may need to run a simple shell script\n+\n+# 1.0.x users\n+\n+For the migration to our 1.0.3 release we are only supporting the 1.0.x series of the UnifiedPush Server:\n+\n+* 1.0.0\n+* 1.0.1\n+* 1.0.2\n+\n+In terms of supported databases, we are supporting MySQL 5.5 and PostgreSQL 9. \n+\n+## Getting started\n+\n+Extract the `unifiedpush-migrator-dist.zip` file to your desired location. \n+\n+_NOTE:_ It is recommended to shutdown the application server, while performing the migration.\n+\n+### Database Migration\n+\n+Below you find information on how to perform the migration on each of the supported databases.\n+\n+#### PostgreSQL\n+\n+Inside of the extracted zip file, there is a `liquibase-postgresql-example.properties`, copy that to `liquibase.properties`.\n+\n+    cp liquibase-postgresql-example.properties liquibase.properties\n+\n+Once done, you need to edit the new file to match your database credentials.","path":"migrator/README.md","position":31,"original_position":31,"commit_id":"423d7ef3cd9bb68b1d0ffed1611a8bcd9e5703ed","original_commit_id":"60506b6bf9f53ab687b51becfbffd7f41f67cb86","user":{"login":"sebastienblanc","id":335133,"avatar_url":"https://avatars.githubusercontent.com/u/335133?v=3","gravatar_id":"","url":"https://api.github.com/users/sebastienblanc","html_url":"https://github.com/sebastienblanc","followers_url":"https://api.github.com/users/sebastienblanc/followers","following_url":"https://api.github.com/users/sebastienblanc/following{/other_user}","gists_url":"https://api.github.com/users/sebastienblanc/gists{/gist_id}","starred_url":"https://api.github.com/users/sebastienblanc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebastienblanc/subscriptions","organizations_url":"https://api.github.com/users/sebastienblanc/orgs","repos_url":"https://api.github.com/users/sebastienblanc/repos","events_url":"https://api.github.com/users/sebastienblanc/events{/privacy}","received_events_url":"https://api.github.com/users/sebastienblanc/received_events","type":"User","site_admin":false},"body":"we could add \"and database name\" , I had to change that since it was postfix with some unwanted extra chars ","created_at":"2015-03-11T09:56:10Z","updated_at":"2015-03-11T09:56:10Z","html_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/510#discussion_r26199695","pull_request_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510","_links":{"self":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/comments/26199695"},"html":{"href":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/510#discussion_r26199695"},"pull_request":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510"}}},"pull_request":{"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510","id":30927616,"html_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/510","diff_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/510.diff","patch_url":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/510.patch","issue_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/510","number":510,"state":"open","locked":false,"title":"Migration cleanup","user":{"login":"matzew","id":157646,"avatar_url":"https://avatars.githubusercontent.com/u/157646?v=3","gravatar_id":"","url":"https://api.github.com/users/matzew","html_url":"https://github.com/matzew","followers_url":"https://api.github.com/users/matzew/followers","following_url":"https://api.github.com/users/matzew/following{/other_user}","gists_url":"https://api.github.com/users/matzew/gists{/gist_id}","starred_url":"https://api.github.com/users/matzew/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matzew/subscriptions","organizations_url":"https://api.github.com/users/matzew/orgs","repos_url":"https://api.github.com/users/matzew/repos","events_url":"https://api.github.com/users/matzew/events{/privacy}","received_events_url":"https://api.github.com/users/matzew/received_events","type":"User","site_admin":false},"body":"Some clean ups for migration, also removed the old `.sql` scripts as well as adding an initial `README` for instructions.\r\n\r\n","created_at":"2015-03-11T09:47:19Z","updated_at":"2015-03-11T09:56:10Z","closed_at":null,"merged_at":null,"merge_commit_sha":"d5327d06e978d96d87c24e8cb415240b4edf5c60","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510/commits","review_comments_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510/comments","review_comment_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/comments{/number}","comments_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/510/comments","statuses_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/statuses/423d7ef3cd9bb68b1d0ffed1611a8bcd9e5703ed","head":{"label":"aerogear:migrationCleanup","ref":"migrationCleanup","sha":"423d7ef3cd9bb68b1d0ffed1611a8bcd9e5703ed","user":{"login":"aerogear","id":954205,"avatar_url":"https://avatars.githubusercontent.com/u/954205?v=3","gravatar_id":"","url":"https://api.github.com/users/aerogear","html_url":"https://github.com/aerogear","followers_url":"https://api.github.com/users/aerogear/followers","following_url":"https://api.github.com/users/aerogear/following{/other_user}","gists_url":"https://api.github.com/users/aerogear/gists{/gist_id}","starred_url":"https://api.github.com/users/aerogear/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aerogear/subscriptions","organizations_url":"https://api.github.com/users/aerogear/orgs","repos_url":"https://api.github.com/users/aerogear/repos","events_url":"https://api.github.com/users/aerogear/events{/privacy}","received_events_url":"https://api.github.com/users/aerogear/received_events","type":"Organization","site_admin":false},"repo":{"id":10624930,"name":"aerogear-unifiedpush-server","full_name":"aerogear/aerogear-unifiedpush-server","owner":{"login":"aerogear","id":954205,"avatar_url":"https://avatars.githubusercontent.com/u/954205?v=3","gravatar_id":"","url":"https://api.github.com/users/aerogear","html_url":"https://github.com/aerogear","followers_url":"https://api.github.com/users/aerogear/followers","following_url":"https://api.github.com/users/aerogear/following{/other_user}","gists_url":"https://api.github.com/users/aerogear/gists{/gist_id}","starred_url":"https://api.github.com/users/aerogear/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aerogear/subscriptions","organizations_url":"https://api.github.com/users/aerogear/orgs","repos_url":"https://api.github.com/users/aerogear/repos","events_url":"https://api.github.com/users/aerogear/events{/privacy}","received_events_url":"https://api.github.com/users/aerogear/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/aerogear/aerogear-unifiedpush-server","description":"AeroGear UnifiedPush Server","fork":false,"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server","forks_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/forks","keys_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/teams","hooks_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/hooks","issue_events_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/events{/number}","events_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/events","assignees_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/assignees{/user}","branches_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/branches{/branch}","tags_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/tags","blobs_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/refs{/sha}","trees_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/statuses/{sha}","languages_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/languages","stargazers_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/stargazers","contributors_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/contributors","subscribers_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/subscribers","subscription_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/subscription","commits_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/commits{/sha}","git_commits_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/commits{/sha}","comments_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/comments{/number}","issue_comment_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/comments{/number}","contents_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/contents/{+path}","compare_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/merges","archive_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/downloads","issues_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues{/number}","pulls_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls{/number}","milestones_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/milestones{/number}","notifications_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/labels{/name}","releases_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/releases{/id}","created_at":"2013-06-11T15:48:01Z","updated_at":"2015-03-11T07:58:24Z","pushed_at":"2015-03-11T09:55:05Z","git_url":"git://github.com/aerogear/aerogear-unifiedpush-server.git","ssh_url":"git@github.com:aerogear/aerogear-unifiedpush-server.git","clone_url":"https://github.com/aerogear/aerogear-unifiedpush-server.git","svn_url":"https://github.com/aerogear/aerogear-unifiedpush-server","homepage":"aerogear.org","size":22802,"stargazers_count":135,"watchers_count":135,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":77,"mirror_url":null,"open_issues_count":2,"forks":77,"open_issues":2,"watchers":135,"default_branch":"master"}},"base":{"label":"aerogear:1.0.x","ref":"1.0.x","sha":"debe4a88fd3fdc5bc3ab4fe2b36cafd8422fcf04","user":{"login":"aerogear","id":954205,"avatar_url":"https://avatars.githubusercontent.com/u/954205?v=3","gravatar_id":"","url":"https://api.github.com/users/aerogear","html_url":"https://github.com/aerogear","followers_url":"https://api.github.com/users/aerogear/followers","following_url":"https://api.github.com/users/aerogear/following{/other_user}","gists_url":"https://api.github.com/users/aerogear/gists{/gist_id}","starred_url":"https://api.github.com/users/aerogear/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aerogear/subscriptions","organizations_url":"https://api.github.com/users/aerogear/orgs","repos_url":"https://api.github.com/users/aerogear/repos","events_url":"https://api.github.com/users/aerogear/events{/privacy}","received_events_url":"https://api.github.com/users/aerogear/received_events","type":"Organization","site_admin":false},"repo":{"id":10624930,"name":"aerogear-unifiedpush-server","full_name":"aerogear/aerogear-unifiedpush-server","owner":{"login":"aerogear","id":954205,"avatar_url":"https://avatars.githubusercontent.com/u/954205?v=3","gravatar_id":"","url":"https://api.github.com/users/aerogear","html_url":"https://github.com/aerogear","followers_url":"https://api.github.com/users/aerogear/followers","following_url":"https://api.github.com/users/aerogear/following{/other_user}","gists_url":"https://api.github.com/users/aerogear/gists{/gist_id}","starred_url":"https://api.github.com/users/aerogear/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aerogear/subscriptions","organizations_url":"https://api.github.com/users/aerogear/orgs","repos_url":"https://api.github.com/users/aerogear/repos","events_url":"https://api.github.com/users/aerogear/events{/privacy}","received_events_url":"https://api.github.com/users/aerogear/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/aerogear/aerogear-unifiedpush-server","description":"AeroGear UnifiedPush Server","fork":false,"url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server","forks_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/forks","keys_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/keys{/key_id}","collaborators_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/teams","hooks_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/hooks","issue_events_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/events{/number}","events_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/events","assignees_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/assignees{/user}","branches_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/branches{/branch}","tags_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/tags","blobs_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/refs{/sha}","trees_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/trees{/sha}","statuses_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/statuses/{sha}","languages_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/languages","stargazers_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/stargazers","contributors_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/contributors","subscribers_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/subscribers","subscription_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/subscription","commits_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/commits{/sha}","git_commits_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/git/commits{/sha}","comments_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/comments{/number}","issue_comment_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/comments{/number}","contents_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/contents/{+path}","compare_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/compare/{base}...{head}","merges_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/merges","archive_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/downloads","issues_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues{/number}","pulls_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls{/number}","milestones_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/milestones{/number}","notifications_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/labels{/name}","releases_url":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/releases{/id}","created_at":"2013-06-11T15:48:01Z","updated_at":"2015-03-11T07:58:24Z","pushed_at":"2015-03-11T09:55:05Z","git_url":"git://github.com/aerogear/aerogear-unifiedpush-server.git","ssh_url":"git@github.com:aerogear/aerogear-unifiedpush-server.git","clone_url":"https://github.com/aerogear/aerogear-unifiedpush-server.git","svn_url":"https://github.com/aerogear/aerogear-unifiedpush-server","homepage":"aerogear.org","size":22802,"stargazers_count":135,"watchers_count":135,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":77,"mirror_url":null,"open_issues_count":2,"forks":77,"open_issues":2,"watchers":135,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510"},"html":{"href":"https://github.com/aerogear/aerogear-unifiedpush-server/pull/510"},"issue":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/510"},"comments":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/issues/510/comments"},"review_comments":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510/comments"},"review_comment":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/pulls/510/commits"},"statuses":{"href":"https://api.github.com/repos/aerogear/aerogear-unifiedpush-server/statuses/423d7ef3cd9bb68b1d0ffed1611a8bcd9e5703ed"}}}}