From ba7c3d25e5721002e46f5cea3dc2f2a8b8547c9e Mon Sep 17 00:00:00 2001 From: Alexander Strachan Date: Mon, 9 Sep 2019 14:03:51 +0000 Subject: docs update to mysql_to_postgresql.md adding timeout parameters --- doc/update/mysql_to_postgresql.md | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/doc/update/mysql_to_postgresql.md b/doc/update/mysql_to_postgresql.md index f6a1b6abdbf..701caf0102e 100644 --- a/doc/update/mysql_to_postgresql.md +++ b/doc/update/mysql_to_postgresql.md @@ -13,7 +13,7 @@ NOTE: **Note:** Support for MySQL was removed in GitLab 12.1. This procedure should be performed **before** installing GitLab 12.1. -[pgloader](https://pgloader.io/) 3.4.1+ is required. +[pgloader](https://pgloader.io/) 3.4.1+ is required, confirm with `pgloader -V`. You can install it directly from your distribution, for example in Debian/Ubuntu: @@ -125,6 +125,10 @@ new PostgreSQL one: create no indexes, preserve index names, no foreign keys, data only + SET MySQL PARAMETERS + net_read_timeout = '90', + net_write_timeout = '180' + ALTER SCHEMA 'gitlabhq_production' RENAME TO 'public' ; @@ -221,6 +225,10 @@ new PostgreSQL one: WITH include no drop, truncate, disable triggers, create no tables, create no indexes, preserve index names, no foreign keys, data only + + SET MySQL PARAMETERS + net_read_timeout = '90', + net_write_timeout = '180' ALTER SCHEMA 'gitlabhq_production' RENAME TO 'public' -- cgit v1.2.1