<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.77 2009/01/05 16:54:36tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.78 2009/02/02 20:07:36adunstan Exp $ -->

<refentry id="APP-PGRESTORE">

<refmeta>

</listitem>

</varlistentry>

<varlistentry>

<term><option>-m <replaceable class="parameter">number-of-threads</replaceable></option></term>

<term><option>--multi-thread=<replaceable class="parameter">number-of-threads</replaceable></option></term>

<listitem>

<para>

Run the most time-consuming parts of <application>pg_restore</>

&mdash; those which load data, create indexes, or create

constraints &mdash; using multiple concurrent connections to the

database. This option can dramatically reduce the time to restore a

large database to a server running on a multi-processor machine.

</para>

<para>

This option is ignored when emitting a script rather than connecting

directly to a database server. Multiple threads cannot be used

together with <option>--single-transaction</option>. Also, the input

must be a plain file (not, for example, a pipe), and at present only

the custom archive format is supported.

</para>

</listitem>

</varlistentry>

<varlistentry>

<term><option>-n <replaceable class="parameter">namespace</replaceable></option></term>

<term><option>--schema=<replaceable class="parameter">schema</replaceable></option></term>

}ArchiveMode;

{

SECTION_NONE=1,/* COMMENTs, ACLs, etc; can be anywhere */

SECTION_PRE_DATA,/* stuff to be processed before data */

SECTION_DATA,/* TABLE DATA, BLOBS, BLOB COMMENTS */

}teSection;

intsuppressDumpWarnings;/* Suppress output of WARNING entries

boolsingle_txn;

intnumber_of_threads;

bool*idWanted;/* array showing which dump IDs to emit */

}RestoreOptions;

constchar*tag,

constchar*namespace,constchar*tablespace,

constchar*owner,boolwithOids,

constchar*desc,constchar*defn,

constchar*desc,teSectionsection,

constchar*defn,

constchar*dropStmt,constchar*copyStmt,

constDumpId*deps,intnDeps,

DataDumperPtrdumpFn,void*dumpArg);