Commita193cbe

committed

Add pg_dumpall --rows-per-insert

Commit7e413a0 added that option to pg_dump, but neglected to teachpg_dumpall how to pass it along. Repair.Author: Fabien CoelhoReported-by: Peter EisentrautReviewed-by: David RowleyDiscussion:https://postgr.es/m/45f50c59-ddbb-8cf2-eedb-81003f603528@2ndquadrant.com

1 parent313f56c commita193cbeCopy full SHA for a193cbe

File tree

+21

-0

lines changed

+21

-0

lines changed

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -501,6 +501,20 @@ PostgreSQL documentation`
`501`	`501`	`</listitem>`
`502`	`502`	`</varlistentry>`
`503`	`503`
	`504`	`+ <varlistentry>`
	`505`	`+ <term><option>--rows-per-insert=<replaceable class="parameter">nrows</replaceable></option></term>`
	`506`	`+ <listitem>`
	`507`	`+ <para>`
	`508`	`+ Dump data as <command>INSERT</command> commands (rather than`
	`509`	`+ <command>COPY</command>). Controls the maximum number of rows per`
	`510`	`+ <command>INSERT</command> command. The value specified must be a`
	`511`	`+ number greater than zero. Any error during reloading will cause only`
	`512`	`+ rows that are part of the problematic <command>INSERT</command> to be`
	`513`	`+ lost, rather than the entire table contents.`
	`514`	`+ </para>`
	`515`	`+ </listitem>`
	`516`	`+ </varlistentry>`
	`517`	`+`
`504`	`518`	`<varlistentry>`
`505`	`519`	`<term><option>--use-set-session-authorization</option></term>`
`506`	`520`	`<listitem>`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -146,6 +146,7 @@ main(int argc, char *argv[])`
`146`	`146`	`{"no-sync",no_argument,NULL,4},`
`147`	`147`	`{"no-unlogged-table-data",no_argument,&no_unlogged_table_data,1},`
`148`	`148`	`{"on-conflict-do-nothing",no_argument,&on_conflict_do_nothing,1},`
	`149`	`+{"rows-per-insert",required_argument,NULL,7},`
`149`	`150`
`150`	`151`	`{NULL,0,NULL,0}`
`151`	`152`	`};`
`@@ -329,6 +330,11 @@ main(int argc, char *argv[])`
`329`	`330`	`simple_string_list_append(&database_exclude_patterns,optarg);`
`330`	`331`	`break;`
`331`	`332`
	`333`	`+case7:`
	`334`	`+appendPQExpBufferStr(pgdumpopts," --rows-per-insert ");`
	`335`	`+appendShellString(pgdumpopts,optarg);`
	`336`	`+break;`
	`337`	`+`
`332`	`338`	`default:`
`333`	`339`	`fprintf(stderr,_("Try \"%s --help\" for more information.\n"),progname);`
`334`	`340`	`exit_nicely(1);`
`@@ -648,6 +654,7 @@ help(void)`
`648`	`654`	`printf(_(" --no-unlogged-table-data do not dump unlogged table data\n"));`
`649`	`655`	`printf(_(" --on-conflict-do-nothing add ON CONFLICT DO NOTHING to INSERT commands\n"));`
`650`	`656`	`printf(_(" --quote-all-identifiers quote all identifiers, even if not key words\n"));`
	`657`	`+printf(_(" --rows-per-insert=NROWS number of rows per INSERT; implies --inserts\n"));`
`651`	`658`	`printf(_(" --use-set-session-authorization\n"`
`652`	`659`	`" use SET SESSION AUTHORIZATION commands instead of\n"`
`653`	`660`	`" ALTER OWNER commands to set ownership\n"));`

Comments

(0)