Commit1c59e37

committed

Revert:

In pg_upgrade, remove pg_restore's --single-transaction option, as it throws errors in certain cases.

1 parent2097723 commit1c59e37Copy full SHA for 1c59e37

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -309,12 +309,11 @@ create_new_objects(void)`
`309`	`309`
`310`	`310`	`/*`
`311`	`311`	`*Using pg_restore --single-transaction is faster than other`
`312`		`- *methods, like --jobs. However, --single-transaction throws`
`313`		`- *an error. pg_dump only produces its output at the`
	`312`	`+ *methods, like --jobs. pg_dump only produces its output at the`
`314`	`313`	`*end, so there is little parallelism using the pipe.`
`315`	`314`	`*/`
`316`	`315`	`exec_prog(RESTORE_LOG_FILE,NULL, true,`
`317`		`-"\"%s/pg_restore\" %s --exit-on-error --verbose --dbname \"%s\" \"%s\"",`
	`316`	`+"\"%s/pg_restore\" %s --exit-on-error --single-transaction --verbose --dbname \"%s\" \"%s\"",`
`318`	`317`	`new_cluster.bindir,cluster_conn_opts(&new_cluster),`
`319`	`318`	`old_db->db_name,file_name);`
`320`	`319`	`}`

Comments

(0)