Horton

use_file_copy_for_pg_upgrade.patch

text/plain

Download
Filename: use_file_copy_for_pg_upgrade.patch
Type: text/plain
Part: 0
Message: use CREATE DATABASE STRATEGY = FILE_COPY in pg_upgrade

Patch

Format: unified
File+−
src/bin/pg_dump/pg_dump.c 3 1 
diff --git a/src/bin/pg_dump/pg_dump.c b/src/bin/pg_dump/pg_dump.c
index e324070828..bc9fef4198 100644
--- a/src/bin/pg_dump/pg_dump.c
+++ b/src/bin/pg_dump/pg_dump.c
@@ -3126,7 +3126,9 @@ dumpDatabase(Archive *fout)
 	 */
 	if (dopt->binary_upgrade)
 	{
-		appendPQExpBuffer(creaQry, "CREATE DATABASE %s WITH TEMPLATE = template0 OID = %u",
+		appendPQExpBuffer(creaQry,
+						  "CREATE DATABASE %s WITH TEMPLATE = template0 "
+						  "OID = %u STRATEGY = FILE_COPY",
 						  qdatname, dbCatId.oid);
 	}
 	else