diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2020-03-03 06:08:31 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2020-03-03 06:08:31 +0300 |
commit | 612a849a6cba1765bc41d30d4e931195dcdf64cf (patch) | |
tree | e4062e4c9852496b731a7de9016553b64a7a433d /doc/update/mysql_to_postgresql.md | |
parent | bd8fb5668ae739a83d55ec5ca4a04344eef2167e (diff) |
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'doc/update/mysql_to_postgresql.md')
-rw-r--r-- | doc/update/mysql_to_postgresql.md | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/update/mysql_to_postgresql.md b/doc/update/mysql_to_postgresql.md index 08794b8a101..9ad77a80d50 100644 --- a/doc/update/mysql_to_postgresql.md +++ b/doc/update/mysql_to_postgresql.md @@ -54,13 +54,13 @@ pgloader within the container as it is not included in the container image. 1. Start a shell session in the context of the running container: - ``` bash + ```shell docker exec -it gitlab bash ``` 1. Install pgloader: - ``` bash + ```shell apt-get update apt-get -y install pgloader ``` @@ -78,7 +78,7 @@ need to enable the bundled PostgreSQL: 1. Edit `/etc/gitlab/gitlab.rb` to enable bundled PostgreSQL: - ``` + ```ruby postgresql['enable'] = true ``` @@ -116,7 +116,7 @@ new PostgreSQL one: 1. Save the following snippet in a `commands.load` file, and edit with your MySQL database `username`, `password` and `host`: - ``` + ```sql LOAD DATABASE FROM mysql://username:password@host/gitlabhq_production INTO postgresql://gitlab-psql@unix://var/opt/gitlab/postgresql:/gitlabhq_production @@ -143,7 +143,7 @@ new PostgreSQL one: 1. Once the migration finishes, you should see a summary table that looks like the following: - ``` + ```plaintext table name read imported errors total time ----------------------------------------------- --------- --------- --------- -------------- fetch meta data 119 119 0 0.388s @@ -217,7 +217,7 @@ new PostgreSQL one: 1. Save the following snippet in a `commands.load` file, and edit with your MySQL `username`, `password` and `host`: - ``` + ```sql LOAD DATABASE FROM mysql://username:password@host/gitlabhq_production INTO postgresql://postgres@unix://var/run/postgresql:/gitlabhq_production @@ -244,7 +244,7 @@ new PostgreSQL one: 1. Once the migration finishes, you should see a summary table that looks like the following: - ``` + ```plaintext table name read imported errors total time ----------------------------------------------- --------- --------- --------- -------------- fetch meta data 119 119 0 0.388s @@ -284,7 +284,7 @@ Sometimes, you might encounter some errors during or after the migration. The PostgreSQL user that you use for the migration MUST have **superuser** privileges. Otherwise, you may see a similar message to the following: -``` +```plaintext debugger invoked on a CL-POSTGRES-ERROR:INSUFFICIENT-PRIVILEGE in thread #<THREAD "lparallel" RUNNING {10078A3513}>: Database error 42501: permission denied: "RI_ConstraintTrigger_a_20937" is a system trigger |