diff options
Diffstat (limited to 'doc/src/sgml/ref/pg_restore.sgml')
| -rw-r--r-- | doc/src/sgml/ref/pg_restore.sgml | 29 |
1 files changed, 26 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index 3e7f2c6fcc0..aa87e2e6f44 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.24 2002/04/21 19:02:39 thomas Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_restore.sgml,v 1.25 2002/05/10 22:36:26 tgl Exp $ --> <refentry id="APP-PGRESTORE"> <docinfo> @@ -336,8 +336,8 @@ <term><option>--superuser=<replaceable class="parameter">username</replaceable></option></term> <listitem> <para> - Specify the superuser user name to use when disabling triggers and/or setting ownership of schema elements. - By default, <COMMAND>pg_restore</COMMAND> will use the current user name if it is a superuser. + Specify the superuser user name to use when disabling triggers. + This is only relevant if <option>--disable-triggers</> is used. </para> </listitem> </varlistentry> @@ -402,6 +402,29 @@ </listitem> </varlistentry> + <varlistentry> + <term><option>-X disable-triggers</></term> + <term><option>--disable-triggers</></term> + <listitem> + <para> + This option is only relevant when performing a data-only restore. + It instructs <command>pg_restore</command> to execute commands + to temporarily disable triggers on the target tables while + the data is reloaded. Use this if you have referential + integrity checks or other triggers on the tables that you + do not want to invoke during data reload. + </para> + + <para> + Presently, the commands emitted for <option>--disable-triggers</> + must be done as superuser. So, you should also specify + a superuser name with <option>-S</>, or preferably specify + <option>--use-set-session-authorization</> and run + <command>pg_restore</command> as a superuser. + </para> + </listitem> + </varlistentry> + </variablelist> </para> |