Commit2097723

committed

Remove pg_restore's --single-transaction option, as it throws errors in

certain cases.

1 parent02aea36 commit2097723Copy full SHA for 2097723

File tree

-2

lines changed

-2

lines changed

Lines changed: 3 additions & 2 deletions

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

Comments

(0)