diff options
author | Alexander <astrachan@gitlab.com> | 2018-04-06 02:35:44 +0000 |
---|---|---|
committer | Alexander <astrachan@gitlab.com> | 2018-04-06 02:35:44 +0000 |
commit | d3a3c5736bc537981c83587120109bfe9d089141 (patch) | |
tree | 1420e0578853d0ab8fe96d0043197744b062daac | |
parent | b9c62c21c6e1dd06e8b68fff5cfa6b13aaf87ae9 (diff) | |
download | gitlab-ce-43903-doc-update-to-mysql_to_postgresql-md-adding-timeout-parameters.tar.gz |
Update mysql_to_postgresql.md - increasing default timeouts to allow for slower network connections.43903-doc-update-to-mysql_to_postgresql-md-adding-timeout-parameters
-rw-r--r-- | doc/update/mysql_to_postgresql.md | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/doc/update/mysql_to_postgresql.md b/doc/update/mysql_to_postgresql.md index 44e9f6c5516..f586a3174e8 100644 --- a/doc/update/mysql_to_postgresql.md +++ b/doc/update/mysql_to_postgresql.md @@ -83,6 +83,9 @@ Now, you can use pgloader to migrate the data from MySQL to PostgreSQL: create no indexes, preserve index names, no foreign keys, data only + set net_read_timeout = '120' + set net_write_timeout = '240' + ALTER SCHEMA 'gitlabhq_production' RENAME TO 'public' ; @@ -224,7 +227,10 @@ Now, you can use pgloader to migrate the data from MySQL to PostgreSQL: WITH include no drop, truncate, disable triggers, create no tables, create no indexes, preserve index names, no foreign keys, data only - + + set net_read_timeout = '120' + set net_write_timeout = '240' + ALTER SCHEMA 'gitlabhq_production' RENAME TO 'public' ; |