codekingpro/portable-devtools

1�����sphinx.addnodes��document���)��}�(�	rawsource����children�]�(�docutils.nodes��target���)��}�(h�.. _restore_dialog:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��restore-dialog�u�tagname�h3�line�K
�parent�h�	_document�h�source��iD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\restore_dialog.rst�ubh	�section���)��}�(hhh]�(h	�title���)��}�(h�`Restore Dialog`:index:�h]�(h�index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Restore Dialog��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh	�Text����Restore Dialog�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh	�	paragraph���)��}�(hX7
The *Restore* dialog provides an easy way to use a Custom, tar, or Directory5format backup taken with the pgAdmin *Backup* dialog to recreate a database or6database object.  The *Backup* dialog invokes options of the pg_dump client7utility; the *Restore* dialog invokes options of the pg_restore client utility.�h]�(hJ�The �����}�(h hWh!hh"NhNubh	�emphasis���)��}�(h�	*Restore*�h]�hJ�Restore�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�e dialog provides an easy way to use a Custom, tar, or Directory8format backup taken with the pgAdmin �����}�(h hWh!hh"NhNubh`)��}�(h�*Backup*�h]�hJ�Backup�����}�(h hsh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�8 dialog to recreate a database or9database object.  The �����}�(h hWh!hh"NhNubh`)��}�(h�*Backup*�h]�hJ�Backup�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�; dialog invokes options of the pg_dump client10utility; the �����}�(h hWh!hh"NhNubh`)��}�(h�	*Restore*�h]�hJ�Restore�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�9 dialog invokes options of the pg_restore client utility.�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(hXe
You can use the *Query Tool* to play back the script created during a plain-text11backup made with the *Backup* dialog.  For more information about backing up or12restoring, please refer to the documentation for13`pg_dump <https://www.postgresql.org/docs/current/app-pgdump.html>`_ or14`pg_restore <https://www.postgresql.org/docs/current/app-pgrestore.html>`_.�h]�(hJ�You can use the �����}�(h h�h!hh"NhNubh`)��}�(h�*Query Tool*�h]�hJ�15Query Tool�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ�J to play back the script created during a plain-text16backup made with the �����}�(h h�h!hh"NhNubh`)��}�(h�*Backup*�h]�hJ�Backup�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ�d dialog.  For more information about backing up or17restoring, please refer to the documentation for18�����}�(h h�h!hh"NhNubh	�	reference���)��}�(h�D`pg_dump <https://www.postgresql.org/docs/current/app-pgdump.html>`_�h]�hJ�pg_dump�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]��name��pg_dump��refuri��7https://www.postgresql.org/docs/current/app-pgdump.html�uhh�h h�ubh)��}�(h�: <https://www.postgresql.org/docs/current/app-pgdump.html>�h]�h}�(h]��pg-dump�ah]�h]��pg_dump�ah]�h]��refuri�h�uhh19�20referenced�K
h h�ubhJ� or21�����}�(h h�h!hh"NhNubh�)��}�(h�J`pg_restore <https://www.postgresql.org/docs/current/app-pgrestore.html>`_�h]�hJ�22pg_restore�����}�(h j

h!hh"NhNubah}�(h]�h]�h]�h]�h]��name��23pg_restore�h�:https://www.postgresql.org/docs/current/app-pgrestore.html�uhh�h h�ubh)��}�(h�= <https://www.postgresql.org/docs/current/app-pgrestore.html>�h]�h}�(h]��24pg-restore�ah]�h]��25pg_restore�ah]�h]��refuri�j
uhh26h�K
h h�ubhJ�
.�����}�(h h�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�image���)��}�(h�^.. image:: images/restore_general.png27    :alt: Restore dialog general tab28    :align: center29�h]�h}�(h]�h]�h]�h]�h]��alt��Restore dialog general tab��align��center��uri��images/restore_general.png��30candidates�}��
*�j:
suhj)
h"h#hKh h&h!hubhV)��}�(h�]Use the fields on the *General* tab to specify general information about the31restore process:�h]�(hJ�Use the fields on the �����}�(h j>
h!hh"NhNubh`)��}�(h�	*General*�h]�hJ�General�����}�(h jF
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j>
ubhJ�> tab to specify general information about the32restore process:�����}�(h j>
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh	�bullet_list���)��}�(hhh]�(h	�	list_item���)��}�(hX
Use the drop-down listbox in the *Format* field to select the format of your33backup file.34 35 * Select *Custom or tar* to restore from a custom archive file to create a36   copy of the backed-up object.37 * Select *Directory* to restore from a compressed directory-format archive.38�h]�(hV)��}�(h�YUse the drop-down listbox in the *Format* field to select the format of your39backup file.�h]�(hJ�!Use the drop-down listbox in the �����}�(h ji
h!hh"NhNubh`)��}�(h�*Format*�h]�hJ�Format�����}�(h jq
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ji
ubhJ�0 field to select the format of your40backup file.�����}�(h ji
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh je
ubh	�block_quote���)��}�(h��* Select *Custom or tar* to restore from a custom archive file to create a41  copy of the backed-up object.42* Select *Directory* to restore from a compressed directory-format archive.43�h]�j_
)��}�(hhh]�(jd
)��}�(h�fSelect *Custom or tar* to restore from a custom archive file to create a44copy of the backed-up object.�h]�hV)��}�(h�fSelect *Custom or tar* to restore from a custom archive file to create a45copy of the backed-up object.�h]�(hJ�Select �����}�(h j�
h!hh"NhNubh`)��}�(h�*Custom or tar*�h]�hJ�
Custom or tar�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubhJ�P to restore from a custom archive file to create a46copy of the backed-up object.�����}�(h j�
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j�
ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKh j�
ubjd
)��}�(h�JSelect *Directory* to restore from a compressed directory-format archive.47�h]�hV)��}�(h�ISelect *Directory* to restore from a compressed directory-format archive.�h]�(hJ�Select �����}�(h j�
h!hh"NhNubh`)��}�(h�*Directory*�h]�hJ�	Directory�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubhJ�7 to restore from a compressed directory-format archive.�����}�(h j�
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j�
ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKh j�
ubeh}�(h]�h]�h]�h]�h]��bullet�j=
uhj^
h"h#hKh j�
ubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hKh je
ubeh}�(h]�h]�h]�h]�h]�uhjc
h"h#hKh j`
h!hubjd
)��}�(h��Enter the complete path to the backup file in the *Filename* field.48Optionally, select the *Browse* icon (ellipsis) to the right to navigate49into a directory and select the file that contains the archive.�h]�hV)��}�(h��Enter the complete path to the backup file in the *Filename* field.50Optionally, select the *Browse* icon (ellipsis) to the right to navigate51into a directory and select the file that contains the archive.�h]�(hJ�2Enter the complete path to the backup file in the �����}�(h j�
h!hh"NhNubh`)��}�(h�52*Filename*�h]�hJ�Filename�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubhJ� field.53Optionally, select the �����}�(h j�
h!hh"NhNubh`)��}�(h�*Browse*�h]�hJ�Browse�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�
ubhJ�i icon (ellipsis) to the right to navigate54into a directory and select the file that contains the archive.�����}�(h j�
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK h j�
ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK h j`
h!hubjd
)��}�(h��Use the *Number of Jobs* field to specify if pg_restore should use multiple55(concurrent) jobs to process the restore.  Each job uses a separate connection56to the server.�h]�hV)��}�(h��Use the *Number of Jobs* field to specify if pg_restore should use multiple57(concurrent) jobs to process the restore.  Each job uses a separate connection58to the server.�h]�(hJ�Use the �����}�(h j9h!hh"NhNubh`)��}�(h�*Number of Jobs*�h]�hJ�Number of Jobs�����}�(h jAh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j9ubhJ�� field to specify if pg_restore should use multiple59(concurrent) jobs to process the restore.  Each job uses a separate connection60to the server.�����}�(h j9h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK#h j5ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK#h j`
h!hubjd
)��}�(h��Use the drop-down listbox next to *Rolename* to specify the role that will be61used to authenticate with the server during the restore process.62�h]�hV)��}�(h��Use the drop-down listbox next to *Rolename* to specify the role that will be63used to authenticate with the server during the restore process.�h]�(hJ�"Use the drop-down listbox next to �����}�(h jch!hh"NhNubh`)��}�(h�64*Rolename*�h]�hJ�Rolename�����}�(h jkh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jcubhJ�b to specify the role that will be65used to authenticate with the server during the restore process.�����}�(h jch!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK&h j_ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK&h j`
h!hubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hKh h&h!hubhV)��}�(h��Click the *Data Options* tab to continue. Use the fields in the *Data Options*66tab to provide options related to data or pgAdmin objects that correspond to *pg_restore*.�h]�(hJ�67Click the �����}�(h j�h!hh"NhNubh`)��}�(h�*Data Options*�h]�hJ�Data Options�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�( tab to continue. Use the fields in the �����}�(h j�h!hh"NhNubh`)��}�(h�*Data Options*�h]�hJ�Data Options�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�N68tab to provide options related to data or pgAdmin objects that correspond to �����}�(h j�h!hh"NhNubh`)��}�(h�*pg_restore*�h]�hJ�69pg_restore�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�
.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK)h h&h!hubj*
)��}�(h�c.. image:: images/restore_sections.png70    :alt: Restore dialog options section71    :align: center72�h]�h}�(h]�h]�h]�h]�h]��alt��Restore dialog options section��align��center��uri��images/restore_sections.png�j;
}�j=
j�suhj)
h"h#hK,h h&h!hubj_
)��}�(hhh]�jd
)��}�(hX5Move switches in the **Sections** field box to specify the content that will be73restored:74 75 * Move the switch next to *Pre-data* towards right position to restore all76   data definition items not included in the data or post-data item lists.77 78 * Move the switch next to *Data* towards right position to restore actual79   table data, large-object contents, and sequence values.80 81 * Move the switch next to *Post-data* towards right position position to restore82   definitions of indexes, triggers, rules, and constraints (other than83   validated check constraints).84�h]�(hV)��}�(h�YMove switches in the **Sections** field box to specify the content that will be85restored:�h]�(hJ�Move switches in the �����}�(h j�h!hh"NhNubh	�strong���)��}�(h�**Sections**�h]�hJ�Sections�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�8 field box to specify the content that will be86restored:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK0h j�ubj�
)��}�(hX�
* Move the switch next to *Pre-data* towards right position to restore all87  data definition items not included in the data or post-data item lists.88 89* Move the switch next to *Data* towards right position to restore actual90  table data, large-object contents, and sequence values.91 92* Move the switch next to *Post-data* towards right position position to restore93  definitions of indexes, triggers, rules, and constraints (other than94  validated check constraints).95�h]�j_
)��}�(hhh]�(jd
)��}�(h��Move the switch next to *Pre-data* towards right position to restore all96data definition items not included in the data or post-data item lists.97�h]�hV)��}�(h��Move the switch next to *Pre-data* towards right position to restore all98data definition items not included in the data or post-data item lists.�h]�(hJ�Move the switch next to �����}�(h jh!hh"NhNubh`)��}�(h�99*Pre-data*�h]�hJ�Pre-data�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�n towards right position to restore all100data definition items not included in the data or post-data item lists.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h jubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK3h jubjd
)��}�(h��Move the switch next to *Data* towards right position to restore actual101table data, large-object contents, and sequence values.102�h]�hV)��}�(h�Move the switch next to *Data* towards right position to restore actual103table data, large-object contents, and sequence values.�h]�(hJ�Move the switch next to �����}�(h jBh!hh"NhNubh`)��}�(h�*Data*�h]�hJ�Data�����}�(h jJh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jBubhJ�a towards right position to restore actual104table data, large-object contents, and sequence values.�����}�(h jBh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK6h j>ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK6h jubjd
)��}�(h��Move the switch next to *Post-data* towards right position position to restore105definitions of indexes, triggers, rules, and constraints (other than106validated check constraints).107�h]�hV)��}�(h��Move the switch next to *Post-data* towards right position position to restore108definitions of indexes, triggers, rules, and constraints (other than109validated check constraints).�h]�(hJ�Move the switch next to �����}�(h jlh!hh"NhNubh`)��}�(h�*Post-data*�h]�hJ�	Post-data�����}�(h jth!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jlubhJ�� towards right position position to restore110definitions of indexes, triggers, rules, and constraints (other than111validated check constraints).�����}�(h jlh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK9h jhubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK9h jubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hK3h j
ubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hK3h j�ubeh}�(h]�h]�h]�h]�h]�uhjc
h"h#hK0h j�h!hubah}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hK0h h&h!hubj*
)��}�(h�c.. image:: images/restore_objects.png112    :alt: Restore dialog sections section113    :align: center114�h]�h}�(h]�h]�h]�h]�h]��alt��Restore dialog sections section��align��center��uri��images/restore_objects.png�j;
}�j=
j�suhj)
h"h#hK=h h&h!hubj_
)��}�(hhh]�jd
)��}�(hX-
Move switches in the **Type of objects** field box to specify the objects that115will be restored:116 117 * Move the switch next to *Only data* towards right position to limit the118   restoration to data.119 120 * Move the switch next to *Only schema* to limit the restoration to121   schema-level database objects.122�h]�(hV)��}�(h�`Move switches in the **Type of objects** field box to specify the objects that123will be restored:�h]�(hJ�Move switches in the �����}�(h j�h!hh"NhNubj�)��}�(h�**Type of objects**�h]�hJ�Type of objects�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�8 field box to specify the objects that124will be restored:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKAh j�ubj�
)��}�(h��* Move the switch next to *Only data* towards right position to limit the125  restoration to data.126 127* Move the switch next to *Only schema* to limit the restoration to128  schema-level database objects.129�h]�j_
)��}�(hhh]�(jd
)��}�(h�]Move the switch next to *Only data* towards right position to limit the130restoration to data.131�h]�hV)��}�(h�\Move the switch next to *Only data* towards right position to limit the132restoration to data.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Only data*�h]�hJ�	Only data�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�9 towards right position to limit the133restoration to data.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKDh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKDh j�ubjd
)��}�(h�aMove the switch next to *Only schema* to limit the restoration to134schema-level database objects.135�h]�hV)��}�(h�`Move the switch next to *Only schema* to limit the restoration to136schema-level database objects.�h]�(hJ�Move the switch next to �����}�(h jh!hh"NhNubh`)��}�(h�
*Only schema*�h]�hJ�Only schema�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�; to limit the restoration to137schema-level database objects.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKGh jubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKGh j�ubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hKDh j�ubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hKDh j�ubeh}�(h]�h]�h]�h]�h]�uhjc
h"h#hKAh j�h!hubah}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hKAh h&h!hubj*
)��}�(h�j.. image:: images/restore_do_not_save.png138    :alt: Restore dialog do not save section139    :align: center140�h]�h}�(h]�h]�h]�h]�h]��alt��"Restore dialog do not save section��align��center��uri��images/restore_do_not_save.png�j;
}�j=
jdsuhj)
h"h#hKJh h&h!hubj_
)��}�(hhh]�jd
)��}�(hXGMove switches in the **Do not save** box to specify which objects will not141be restored:142 143 * Move the switch next to *Owner* towards right position to exclude commands144   that set object ownership.145 146 * Move the switch next to *Privileges* towards right position to exclude147   commands that create access privileges.148 149 * Move the switch next to *Tablespaces* towards right position to exclude150   tablespaces.151 152 * Move the switch next to *Comments* towards right position to exclude153   commands that set the comments. **Note:** This option is visible only for154   database server greater than or equal to 11.155 156 * Move the switch next to *Publications* towards right position to exclude157   publications.158 159 * Move the switch next to *Subscriptions* towards right position to exclude160   subscriptions.161 162 * Move the switch next to *Security labels* towards right position to exclude163   Security labels.164 165 * Move the switch next to *Table access methods* towards right position to exclude166   Table access methods. **Note:** This option is visible only for167   database server greater than or equal to 15.168�h]�(hV)��}�(h�WMove switches in the **Do not save** box to specify which objects will not169be restored:�h]�(hJ�Move switches in the �����}�(h jmh!hh"NhNubj�)��}�(h�**Do not save**�h]�hJ�Do not save�����}�(h juh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h jmubhJ�3 box to specify which objects will not170be restored:�����}�(h jmh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKNh jiubj�
)��}�(hX�* Move the switch next to *Owner* towards right position to exclude commands171  that set object ownership.172 173* Move the switch next to *Privileges* towards right position to exclude174  commands that create access privileges.175 176* Move the switch next to *Tablespaces* towards right position to exclude177  tablespaces.178 179* Move the switch next to *Comments* towards right position to exclude180  commands that set the comments. **Note:** This option is visible only for181  database server greater than or equal to 11.182 183* Move the switch next to *Publications* towards right position to exclude184  publications.185 186* Move the switch next to *Subscriptions* towards right position to exclude187  subscriptions.188 189* Move the switch next to *Security labels* towards right position to exclude190  Security labels.191 192* Move the switch next to *Table access methods* towards right position to exclude193  Table access methods. **Note:** This option is visible only for194  database server greater than or equal to 15.195�h]�j_
)��}�(hhh]�(jd
)��}�(h�fMove the switch next to *Owner* towards right position to exclude commands196that set object ownership.197�h]�hV)��}�(h�eMove the switch next to *Owner* towards right position to exclude commands198that set object ownership.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Owner*�h]�hJ�Owner�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�F towards right position to exclude commands199that set object ownership.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKQh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKQh j�ubjd
)��}�(h�oMove the switch next to *Privileges* towards right position to exclude200commands that create access privileges.201�h]�hV)��}�(h�nMove the switch next to *Privileges* towards right position to exclude202commands that create access privileges.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�203Privileges�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�J towards right position to exclude204commands that create access privileges.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKTh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKTh j�ubjd
)��}�(h�UMove the switch next to *Tablespaces* towards right position to exclude205tablespaces.206�h]�hV)��}�(h�TMove the switch next to *Tablespaces* towards right position to exclude207tablespaces.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�
*Tablespaces*�h]�hJ�Tablespaces�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�/ towards right position to exclude208tablespaces.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKWh j�ubjd
)��}�(h��Move the switch next to *Comments* towards right position to exclude209commands that set the comments. **Note:** This option is visible only for210database server greater than or equal to 11.211�h]�hV)��}�(h��Move the switch next to *Comments* towards right position to exclude212commands that set the comments. **Note:** This option is visible only for213database server greater than or equal to 11.�h]�(hJ�Move the switch next to �����}�(h jh!hh"NhNubh`)��}�(h�214*Comments*�h]�hJ�Comments�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jubhJ�C towards right position to exclude215commands that set the comments. �����}�(h jh!hh"NhNubj�)��}�(h�	**Note:**�h]�hJ�Note:�����}�(h j0h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h jubhJ�M This option is visible only for216database server greater than or equal to 11.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKZh jubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKZh j�ubjd
)��}�(h�WMove the switch next to *Publications* towards right position to exclude217publications.218�h]�hV)��}�(h�VMove the switch next to *Publications* towards right position to exclude219publications.�h]�(hJ�Move the switch next to �����}�(h jRh!hh"NhNubh`)��}�(h�*Publications*�h]�hJ�Publications�����}�(h jZh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jRubhJ�0 towards right position to exclude220publications.�����}�(h jRh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK^h jNubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK^h j�ubjd
)��}�(h�YMove the switch next to *Subscriptions* towards right position to exclude221subscriptions.222�h]�hV)��}�(h�XMove the switch next to *Subscriptions* towards right position to exclude223subscriptions.�h]�(hJ�Move the switch next to �����}�(h j|h!hh"NhNubh`)��}�(h�*Subscriptions*�h]�hJ�
Subscriptions�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j|ubhJ�1 towards right position to exclude224subscriptions.�����}�(h j|h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKah jxubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKah j�ubjd
)��}�(h�]Move the switch next to *Security labels* towards right position to exclude225Security labels.226�h]�hV)��}�(h�\Move the switch next to *Security labels* towards right position to exclude227Security labels.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Security labels*�h]�hJ�Security labels�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�3 towards right position to exclude228Security labels.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKdh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKdh j�ubjd
)��}�(h��Move the switch next to *Table access methods* towards right position to exclude229Table access methods. **Note:** This option is visible only for230database server greater than or equal to 15.231�h]�hV)��}�(h��Move the switch next to *Table access methods* towards right position to exclude232Table access methods. **Note:** This option is visible only for233database server greater than or equal to 15.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Table access methods*�h]�hJ�Table access methods�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�9 towards right position to exclude234Table access methods. �����}�(h j�h!hh"NhNubj�)��}�(h�	**Note:**�h]�hJ�Note:�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�M This option is visible only for235database server greater than or equal to 15.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKgh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKgh j�ubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hKQh j�ubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hKQh jiubeh}�(h]�h]�h]�h]�h]�uhjc
h"h#hKNh jfh!hubah}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hKNh h&h!hubj*
)��}�(h�b.. image:: images/restore_queries.png236    :alt: Restore dialog queries section237    :align: center238�h]�h}�(h]�h]�h]�h]�h]��alt��Restore dialog queries section��align��center��uri��images/restore_queries.png�j;
}�j=
j/suhj)
h"h#hKkh h&h!hubhV)��}�(h��Click the *Query Options* tab to continue. Use these additional fields to specify239the type of statements that should be included in the restore:�h]�(hJ�240Click the �����}�(h j1h!hh"NhNubh`)��}�(h�*Query Options*�h]�hJ�
Query Options�����}�(h j9h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j1ubhJ�w tab to continue. Use these additional fields to specify241the type of statements that should be included in the restore:�����}�(h j1h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKoh h&h!hubj�
)��}�(hXC* Move the switch next to *Include CREATE DATABASE statement* towards right position242  to include a command that creates a new database before performing the restore.243 244* Move the switch next to *Clean before restore* towards right position to245  drop each existing database object (and data) before restoring.246 247* Move the switch next to *Include IF EXISTS clause* towards right248  position to add an IF EXISTS clause to drop databases and other objects.249  This option is not valid unless *Clean before restore* is also set.250 251* Move the switch next to *Single transaction* towards right position to252  execute the restore as a single transaction (that is, wrap the emitted253  commands in *BEGIN/COMMIT*). This ensures that either all the commands254  complete successfully, or no changes are applied. This option implies255  *--exit-on-error*.256�h]�j_
)��}�(hhh]�(jd
)��}�(h��Move the switch next to *Include CREATE DATABASE statement* towards right position257to include a command that creates a new database before performing the restore.258�h]�hV)��}�(h��Move the switch next to *Include CREATE DATABASE statement* towards right position259to include a command that creates a new database before performing the restore.�h]�(hJ�Move the switch next to �����}�(h j\h!hh"NhNubh`)��}�(h�#*Include CREATE DATABASE statement*�h]�hJ�!Include CREATE DATABASE statement�����}�(h jdh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j\ubhJ�g towards right position260to include a command that creates a new database before performing the restore.�����}�(h j\h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKsh jXubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKsh jUubjd
)��}�(h��Move the switch next to *Clean before restore* towards right position to261drop each existing database object (and data) before restoring.262�h]�hV)��}�(h��Move the switch next to *Clean before restore* towards right position to263drop each existing database object (and data) before restoring.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Clean before restore*�h]�hJ�Clean before restore�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�Z towards right position to264drop each existing database object (and data) before restoring.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKvh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKvh jUubjd
)��}�(h��Move the switch next to *Include IF EXISTS clause* towards right265position to add an IF EXISTS clause to drop databases and other objects.266This option is not valid unless *Clean before restore* is also set.267�h]�hV)��}�(h��Move the switch next to *Include IF EXISTS clause* towards right268position to add an IF EXISTS clause to drop databases and other objects.269This option is not valid unless *Clean before restore* is also set.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Include IF EXISTS clause*�h]�hJ�Include IF EXISTS clause�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�x towards right270position to add an IF EXISTS clause to drop databases and other objects.271This option is not valid unless �����}�(h j�h!hh"NhNubh`)��}�(h�*Clean before restore*�h]�hJ�Clean before restore�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�
 is also set.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKyh j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hKyh jUubjd
)��}�(hX.
Move the switch next to *Single transaction* towards right position to272execute the restore as a single transaction (that is, wrap the emitted273commands in *BEGIN/COMMIT*). This ensures that either all the commands274complete successfully, or no changes are applied. This option implies275*--exit-on-error*.276�h]�hV)��}�(hX-
Move the switch next to *Single transaction* towards right position to277execute the restore as a single transaction (that is, wrap the emitted278commands in *BEGIN/COMMIT*). This ensures that either all the commands279complete successfully, or no changes are applied. This option implies280*--exit-on-error*.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Single transaction*�h]�hJ�Single transaction�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�n towards right position to281execute the restore as a single transaction (that is, wrap the emitted282commands in �����}�(h j�h!hh"NhNubh`)��}�(h�*BEGIN/COMMIT*�h]�hJ�BEGIN/COMMIT�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�s). This ensures that either all the commands283complete successfully, or no changes are applied. This option implies284�����}�(h j�h!hh"NhNubh`)��}�(h�*--exit-on-error*�h]�hJ�–exit-on-error�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�
.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK}h j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK}h jUubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hKsh jQubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hKsh h&h!hubj*
)��}�(h�_.. image:: images/restore_table.png285    :alt: Restore dialog tables section286    :align: center287�h]�h}�(h]�h]�h]�h]�h]��alt��Restore dialog tables section��align��center��uri��images/restore_table.png�j;
}�j=
jQsuhj)
h"h#hK�h h&h!hubhV)��}�(h��Click the *Table Options* tab to continue. Use the fields in the *Table Options*288tab related to tables that should be included in the backup.�h]�(hJ�289Click the �����}�(h jSh!hh"NhNubh`)��}�(h�*Table Options*�h]�hJ�
Table Options�����}�(h j[h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jSubhJ�( tab to continue. Use the fields in the �����}�(h jSh!hh"NhNubh`)��}�(h�*Table Options*�h]�hJ�
Table Options�����}�(h jmh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jSubhJ�=290tab related to tables that should be included in the backup.�����}�(h jSh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h h&h!hubj�
)��}�(hX�
* Move the switch next to *Enable row security* towards right position to291  set row_security to on instead, allowing the user to dump the parts of the292  contents of the table that they have access to. This option is relevant293  only when dumping the contents of a table which has row security.294 295* Move the switch next to *No data for failed tables* towards right position296  to ignore data that fails a trigger.297�h]�j_
)��}�(hhh]�(jd
)��}�(hX
Move the switch next to *Enable row security* towards right position to298set row_security to on instead, allowing the user to dump the parts of the299contents of the table that they have access to. This option is relevant300only when dumping the contents of a table which has row security.301�h]�hV)��}�(hX
Move the switch next to *Enable row security* towards right position to302set row_security to on instead, allowing the user to dump the parts of the303contents of the table that they have access to. This option is relevant304only when dumping the contents of a table which has row security.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Enable row security*�h]�hJ�Enable row security�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�� towards right position to305set row_security to on instead, allowing the user to dump the parts of the306contents of the table that they have access to. This option is relevant307only when dumping the contents of a table which has row security.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j�ubjd
)��}�(h�pMove the switch next to *No data for failed tables* towards right position308to ignore data that fails a trigger.309�h]�hV)��}�(h�oMove the switch next to *No data for failed tables* towards right position310to ignore data that fails a trigger.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*No data for failed tables*�h]�hJ�No data for failed tables�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�< towards right position311to ignore data that fails a trigger.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hK�h h&h!hubhV)��}�(h�jClick the *Options* tab to continue. Use the fields in the *Options*312tab to provide other restore options.�h]�(hJ�313Click the �����}�(h j�h!hh"NhNubh`)��}�(h�	*Options*�h]�hJ�Options�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�( tab to continue. Use the fields in the �����}�(h j�h!hh"NhNubh`)��}�(h�	*Options*�h]�hJ�Options�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ�&314tab to provide other restore options.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h h&h!hubj*
)��}�(h�n.. image:: images/restore_miscellaneous.png315    :alt: Restore dialog miscellaneous section316    :align: center317�h]�h}�(h]�h]�h]�h]�h]��alt��$Restore dialog miscellaneous section��align��center��uri�� images/restore_miscellaneous.png�j;
}�j=
j-suhj)
h"h#hK�h h&h!hubj_
)��}�(hhh]�(jd
)��}�(hXC
Move switches in the **Disable** box to specify the type of statements that318should be excluded from the restore:319 320 * Move the switch next to *Triggers* (active when creating a data-only321   restore) towards right position to include commands that will disable322   triggers on the target table while the data is being loaded.323�h]�(hV)��}�(h�pMove switches in the **Disable** box to specify the type of statements that324should be excluded from the restore:�h]�(hJ�Move switches in the �����}�(h j6h!hh"NhNubj�)��}�(h�**Disable**�h]�hJ�Disable�����}�(h j>h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j6ubhJ�P box to specify the type of statements that325should be excluded from the restore:�����}�(h j6h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j2ubj�
)��}�(h��* Move the switch next to *Triggers* (active when creating a data-only326  restore) towards right position to include commands that will disable327  triggers on the target table while the data is being loaded.328�h]�j_
)��}�(hhh]�jd
)��}�(h��Move the switch next to *Triggers* (active when creating a data-only329restore) towards right position to include commands that will disable330triggers on the target table while the data is being loaded.331�h]�hV)��}�(h��Move the switch next to *Triggers* (active when creating a data-only332restore) towards right position to include commands that will disable333triggers on the target table while the data is being loaded.�h]�(hJ�Move the switch next to �����}�(h jah!hh"NhNubh`)��}�(h�334*Triggers*�h]�hJ�Triggers�����}�(h jih!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jaubhJ�� (active when creating a data-only335restore) towards right position to include commands that will disable336triggers on the target table while the data is being loaded.�����}�(h jah!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j]ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h jZubah}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hK�h jVubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hK�h j2ubeh}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j/h!hubjd
)��}�(hXMove switches in the **Miscellaneous/Behavior** box to specify337miscellaneous restore options:338 339 * Move the switch next to *Verbose messages* towards left to instruct340   *pg_restore* to exclude verbose messages.341 342 * Move the switch next to *Use SET SESSION AUTHORIZATION* towards right position343   to include a statement that will use a SET SESSION AUTHORIZATION344   command to determine object ownership (instead of an ALTER OWNER command).345 346 * Move the switch next to *Exit on error* towards right position to instruct347   *pg_restore* to exit restore if there is an error in sending SQL commands.348   The default is to continue and to display a count of errors at the end of349   the restore.350 351 * Use the *Exclude schema* field to not dump schemas whose name matches352   pattern.353�h]�(hV)��}�(h�]Move switches in the **Miscellaneous/Behavior** box to specify354miscellaneous restore options:�h]�(hJ�Move switches in the �����}�(h j�h!hh"NhNubj�)��}�(h�**Miscellaneous/Behavior**�h]�hJ�Miscellaneous/Behavior�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj�h j�ubhJ�. box to specify355miscellaneous restore options:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubj�
)��}�(hX�* Move the switch next to *Verbose messages* towards left to instruct356  *pg_restore* to exclude verbose messages.357 358* Move the switch next to *Use SET SESSION AUTHORIZATION* towards right position359  to include a statement that will use a SET SESSION AUTHORIZATION360  command to determine object ownership (instead of an ALTER OWNER command).361 362* Move the switch next to *Exit on error* towards right position to instruct363  *pg_restore* to exit restore if there is an error in sending SQL commands.364  The default is to continue and to display a count of errors at the end of365  the restore.366 367* Use the *Exclude schema* field to not dump schemas whose name matches368  pattern.369�h]�j_
)��}�(hhh]�(jd
)��}�(h�nMove the switch next to *Verbose messages* towards left to instruct370*pg_restore* to exclude verbose messages.371�h]�hV)��}�(h�mMove the switch next to *Verbose messages* towards left to instruct372*pg_restore* to exclude verbose messages.�h]�(hJ�Move the switch next to �����}�(h j�h!hh"NhNubh`)��}�(h�*Verbose messages*�h]�hJ�Verbose messages�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� towards left to instruct373�����}�(h j�h!hh"NhNubh`)��}�(h�*pg_restore*�h]�hJ�374pg_restore�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�ubhJ� to exclude verbose messages.�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j�ubjd
)��}�(h��Move the switch next to *Use SET SESSION AUTHORIZATION* towards right position375to include a statement that will use a SET SESSION AUTHORIZATION376command to determine object ownership (instead of an ALTER OWNER command).377�h]�hV)��}�(h��Move the switch next to *Use SET SESSION AUTHORIZATION* towards right position378to include a statement that will use a SET SESSION AUTHORIZATION379command to determine object ownership (instead of an ALTER OWNER command).�h]�(hJ�Move the switch next to �����}�(h j	h!hh"NhNubh`)��}�(h�*Use SET SESSION AUTHORIZATION*�h]�hJ�Use SET SESSION AUTHORIZATION�����}�(h j	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j	ubhJ�� towards right position380to include a statement that will use a SET SESSION AUTHORIZATION381command to determine object ownership (instead of an ALTER OWNER command).�����}�(h j	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j	ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j�ubjd
)��}�(h��Move the switch next to *Exit on error* towards right position to instruct382*pg_restore* to exit restore if there is an error in sending SQL commands.383The default is to continue and to display a count of errors at the end of384the restore.385�h]�hV)��}�(h��Move the switch next to *Exit on error* towards right position to instruct386*pg_restore* to exit restore if there is an error in sending SQL commands.387The default is to continue and to display a count of errors at the end of388the restore.�h]�(hJ�Move the switch next to �����}�(h j.	h!hh"NhNubh`)��}�(h�*Exit on error*�h]�hJ�
Exit on error�����}�(h j6	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j.	ubhJ�$ towards right position to instruct389�����}�(h j.	h!hh"NhNubh`)��}�(h�*pg_restore*�h]�hJ�390pg_restore�����}�(h jH	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j.	ubhJ�� to exit restore if there is an error in sending SQL commands.391The default is to continue and to display a count of errors at the end of392the restore.�����}�(h j.	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j*	ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j�ubjd
)��}�(h�OUse the *Exclude schema* field to not dump schemas whose name matches393pattern.394�h]�hV)��}�(h�NUse the *Exclude schema* field to not dump schemas whose name matches395pattern.�h]�(hJ�Use the �����}�(h jj	h!hh"NhNubh`)��}�(h�*Exclude schema*�h]�hJ�Exclude schema�����}�(h jr	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jj	ubhJ�6 field to not dump schemas whose name matches396pattern.�����}�(h jj	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jf	ubah}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hK�h j�ubah}�(h]�h]�h]�h]�h]�uhj�
h"h#hK�h j�ubeh}�(h]�h]�h]�h]�h]�uhjc
h"h#hK�h j/h!hubeh}�(h]�h]�h]�h]�h]�j�
j=
uhj^
h"h#hK�h h&h!hubhV)��}�(h��When you’ve specified the details that will be incorporated into the pg_restore397command, click the *Restore* button to start the process, or click the *Cancel*398button to exit without saving your work. A popup will confirm if the restore is399successful.�h]�(hJ�eWhen you’ve specified the details that will be incorporated into the pg_restore400command, click the �����}�(h j�	h!hh"NhNubh`)��}�(h�	*Restore*�h]�hJ�Restore�����}�(h j�	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�	ubhJ�+ button to start the process, or click the �����}�(h j�	h!hh"NhNubh`)��}�(h�*Cancel*�h]�hJ�Cancel�����}�(h j�	h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j�	ubhJ�\401button to exit without saving your work. A popup will confirm if the restore is402successful.�����}�(h j�	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h h&h!hubhV)��}�(h��pgAdmin will run the restore process in background. You can view all the background403process with there running status and logs on the :ref:`Processes <processes>`404tab�h]�(hJ��pgAdmin will run the restore process in background. You can view all the background405process with there running status and logs on the �����}�(h j�	h!hh"NhNubh�pending_xref���)��}�(h�:ref:`Processes <processes>`�h]�h	�inline���)��}�(hj�	h]�hJ�	Processes�����}�(h j�	h!hh"NhNubah}�(h]�h]�(�xref��std��std-ref�eh]�h]�h]�uhj�	h j�	ubah}�(h]�h]�h]�h]�h]��refdoc��restore_dialog��	refdomain�j�	�reftype��ref��refexplicit���refwarn���	reftarget��	processes�uhj�	h"h#hK�h j�	ubhJ�406tab�����}�(h j�	h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h h&h!hubeh}�(h]�(h�id1�eh]�h]�(�restore dialog��restore_dialog�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�j407hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�408translated�Kuuhh
�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N�	generator�N�	datestamp�N�root_prefix��
/��source_link�N�409source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�410halt_level�K�exit_status_level�K�debug�N�warning_stream�N�	traceback���input_encoding��	utf-8-sig��input_encoding_error_handler��strict��output_encoding��utf-8��output_encoding_error_handler�jJ411�error_encoding��cp1252��error_encoding_error_handler��backslashreplace��
language_code��en��record_dependencies�N�config�N�	id_prefix�h�auto_id_prefix��id��
dump_settings�N�dump_internals�N�dump_transforms�N�dump_pseudo_xml�N�expose_internals�N�strict_visitor�N�_disable_config�N�_source�h#�_destination�N�
_config_files�]��file_insertion_enabled���raw_enabled�K
�line_length_limit�M'�pep_references�N�pep_base_url��https://peps.python.org/��pep_file_url_template��pep-%04d��rfc_references�N�rfc_base_url��&https://datatracker.ietf.org/doc/html/��	tab_width�K�trim_footnote_reference_space���syntax_highlight��long��smart_quotes���smartquotes_locales�]��character_level_inline_markup���doctitle_xform���
docinfo_xform���sectsubtitle_xform���
image_loading��link��embed_stylesheet���cloak_email_addresses���section_self_link���env�Nub�reporter�N�indirect_targets�]��substitution_defs�}��substitution_names�}��refnames�}��refids�}�h]�has�nameids�}�(j412hj413j414h�h�j
j
u�	nametypes�}�(j415�j416�h��j
�uh}�(hh&j417h&h�h�j
j
u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]��	footnotes�]��	citations�]��autofootnote_start�K
�symbol_footnote_start�K�418id_counter��collections��Counter���}�jX419K
s��R��parse_messages�]��transform_messages�]�(h	�system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�4Hyperlink target "restore-dialog" is not referenced.�����}�h j�420sbah}�(h]�h]�h]�h]�h]�uhhUh j�421ubah}�(h]�h]�h]�h]�h]��level�K
�type��INFO��source�h#�line�K
uhj�422ubj�423)��}�(hhh]�hV)��}�(hhh]�hJ�-Hyperlink target "index-0" is not referenced.�����}�h j�424sbah}�(h]�h]�h]�h]�h]�uhhUh j�425ubah}�(h]�h]�h]�h]�h]��level�K
�type�j�426�source�h#�line�Kuhj�427ube�transformer�N�include_log�]��428decoration�Nh!hub.