Commit17a56c0

committed

Disable statement timeouts while making or restoring dumps.

Joshua Drake.

1 parentc88850f commit17a56c0Copy full SHA for 17a56c0

File tree

+13

-2

lines changed

+13

-2

lines changed

Lines changed: 6 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -15,7 +15,7 @@`
`15`	`15`	`*`
`16`	`16`	`*`
`17`	`17`	`* IDENTIFICATION`
`18`		`- *$PostgreSQL: pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.154 2008/04/13 03:49:21 tgl Exp $`
	`18`	`+ *$PostgreSQL: pgsql/src/bin/pg_dump/pg_backup_archiver.c,v 1.155 2008/05/03 23:32:32 adunstan Exp $`
`19`	`19`	`*`
`20`	`20`	`*-------------------------------------------------------------------------`
`21`	`21`	`*/`
`@@ -219,6 +219,11 @@ RestoreArchive(Archive AHX, RestoreOptions ropt)`
`219`	`219`	`ahprintf(AH,"BEGIN;\n\n");`
`220`	`220`	`}`
`221`	`221`
	`222`	`+/*`
	`223`	`+ * Disable statement_timeout in archive for pg_restore/psql`
	`224`	`+ */`
	`225`	`+ahprintf(AH,"SET statement_timeout = 0;\n");`
	`226`	`+`
`222`	`227`	`/*`
`223`	`228`	`* Establish important parameter values right away.`
`224`	`229`	`*/`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -12,7 +12,7 @@`
`12`	`12`	`*by PostgreSQL`
`13`	`13`	`*`
`14`	`14`	`* IDENTIFICATION`
`15`		`- * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.488 2008/04/14 17:05:33 tgl Exp $`
	`15`	`+ * $PostgreSQL: pgsql/src/bin/pg_dump/pg_dump.c,v 1.489 2008/05/03 23:32:32 adunstan Exp $`
`16`	`16`	`*`
`17`	`17`	`*-------------------------------------------------------------------------`
`18`	`18`	`*/`
`@@ -570,6 +570,12 @@ main(int argc, char **argv)`
`570`	`570`	`if (g_fout->remoteVersion >=80300)`
`571`	`571`	`do_sql_command(g_conn,"SET synchronize_seqscans TO off");`
`572`	`572`
	`573`	`+/*`
	`574`	`+ * Disable timeouts if supported.`
	`575`	`+ */`
	`576`	`+if (g_fout->remoteVersion >=70300)`
	`577`	`+do_sql_command(g_conn,"SET statement_timeout = 0");`
	`578`	`+`
`573`	`579`	`/*`
`574`	`580`	`* Start serializable transaction to dump consistent data.`
`575`	`581`	`*/`

Comments

(0)