codekingpro/portable-devtools

1��4g�sphinx.addnodes��document���)��}�(�	rawsource����children�]�(�docutils.nodes��target���)��}�(h�.. _import_export_servers:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��import-export-servers�u�tagname�h3�line�K
�parent�h�	_document�h�source��pD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\import_export_servers.rst�ubh	�section���)��}�(hhh]�(h	�title���)��}�(h�`Import/Export Servers`:index:�h]�(h�index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Import/Export Servers��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh	�Text����Import/Export Servers�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh	�	paragraph���)��}�(h��Server definitions (and their groups) can be exported to a JSON file and5re-imported to the same or a different system to enable easy pre-configuration6of pgAdmin.�h]�hJ��Server definitions (and their groups) can be exported to a JSON file and7re-imported to the same or a different system to enable easy pre-configuration8of pgAdmin.�����}�(h hWh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh%)��}�(hhh]�(h*)��}�(h�Using pgAdmin 4 GUI�h]�hJ�Using pgAdmin 4 GUI�����}�(h hhh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h heh!hh"h#hKubhV)��}�(h��To launch the *Import/Export Servers...* tool, navigate through *Tools* on the9menu bar to click on the *Import/Export Servers* option.�h]�(hJ�To launch the �����}�(h hvh!hh"NhNubh	�emphasis���)��}�(h�*Import/Export Servers...*�h]�hJ�Import/Export Servers…�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h hvubhJ� tool, navigate through �����}�(h hvh!hh"NhNubh)��}�(h�*Tools*�h]�hJ�Tools�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h hvubhJ�! on the10menu bar to click on the �����}�(h hvh!hh"NhNubh)��}�(h�*Import/Export Servers*�h]�hJ�Import/Export Servers�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h hvubhJ� option.�����}�(h hvh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh heh!hubh	�image���)��}�(h�s.. image:: images/import_export_servers_step1.png11    :alt: Import/Export Servers step one page12    :align: center13�h]�h}�(h]�h]�h]�h]�h]��alt��#Import/Export Servers step one page��align��center��uri��&images/import_export_servers_step1.png��14candidates�}��
*�h�suhh�h"h#hKh heh!hubh	�bullet_list���)��}�(hhh]�(h	�	list_item���)��}�(h�^Use the *Import/Export* field to select the Server Groups/Servers15to be imported or exported.16�h]�hV)��}�(h�]Use the *Import/Export* field to select the Server Groups/Servers17to be imported or exported.�h]�(hJ�Use the �����}�(h h�h!hh"NhNubh)��}�(h�*Import/Export*�h]�hJ�
Import/Export�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h h�ubhJ�F field to select the Server Groups/Servers18to be imported or exported.�����}�(h h�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hKh h�h!hubh�)��}�(h��Use the *Filename* field to select the JSON file to import servers or create the19new file in case of Export where the servers to be exported in the JSON format.20�h]�hV)��}�(h��Use the *Filename* field to select the JSON file to import servers or create the21new file in case of Export where the servers to be exported in the JSON format.�h]�(hJ�Use the �����}�(h j
h!hh"NhNubh)��}�(h�22*Filename*�h]�hJ�Filename�����}�(h j
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h j
ubhJ�� field to select the JSON file to import servers or create the23new file in case of Export where the servers to be exported in the JSON format.�����}�(h j
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j
ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hKh h�h!hubh�)��}�(h��Use the *Remove all the existing servers?* field to specify whether to remove all the24existing servers or not before importing the new selected servers.25This field is applicable only in case of Import Servers.26�h]�hV)��}�(h��Use the *Remove all the existing servers?* field to specify whether to remove all the27existing servers or not before importing the new selected servers.28This field is applicable only in case of Import Servers.�h]�(hJ�Use the �����}�(h j0
h!hh"NhNubh)��}�(h�"*Remove all the existing servers?*�h]�hJ� Remove all the existing servers?�����}�(h j8
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h j0
ubhJ�� field to specify whether to remove all the29existing servers or not before importing the new selected servers.30This field is applicable only in case of Import Servers.�����}�(h j0
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j,
ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hKh h�h!hubeh}�(h]�h]�h]�h]�h]��bullet�h�uhh�h"h#hKh heh!hubhV)��}�(h�KClick the *Next* button to continue, or the *X* button to close the wizard.�h]�(hJ�31Click the �����}�(h j]
h!hh"NhNubh)��}�(h�*Next*�h]�hJ�Next�����}�(h je
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h j]
ubhJ� button to continue, or the �����}�(h j]
h!hh"NhNubh)��}�(h�*X*�h]�hJ�
X�����}�(h jw
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h j]
ubhJ� button to close the wizard.�����}�(h j]
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh heh!hubh�)��}�(h�s.. image:: images/import_export_servers_step2.png32    :alt: Import/Export Servers step two page33    :align: center34�h]�h}�(h]�h]�h]�h]�h]��alt��#Import/Export Servers step two page��align��center��uri��&images/import_export_servers_step2.png�h�}�h�j�
suhh�h"h#hK!h heh!hubh�)��}�(hhh]�h�)��}�(h�;Select the Server Groups/ Servers to be imported/exported.35�h]�hV)��}�(h�:Select the Server Groups/ Servers to be imported/exported.�h]�hJ�:Select the Server Groups/ Servers to be imported/exported.�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK%h j�
ubah}�(h]�h]�h]�h]�h]�uhh�h"h#hK%h j�
h!hubah}�(h]�h]�h]�h]�h]�j\
h�uhh�h"h#hK%h heh!hubhV)��}�(h�KClick the *Next* button to continue, or the *X* button to close the wizard.�h]�(hJ�36Click the �����}�(h j�
h!hh"NhNubh)��}�(h�*Next*�h]�hJ�Next�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h j�
ubhJ� button to continue, or the �����}�(h j�
h!hh"NhNubh)��}�(h�*X*�h]�hJ�
X�����}�(h j�
h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h j�
ubhJ� button to close the wizard.�����}�(h j�
h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h heh!hubh�)��}�(h�u.. image:: images/import_export_servers_step3.png37    :alt: Import/Export Servers step three page38    :align: center39�h]�h}�(h]�h]�h]�h]�h]��alt��%Import/Export Servers step three page��align��center��uri��&images/import_export_servers_step3.png�h�}�h�jsuhh�h"h#hK)h heh!hubhV)��}�(h�\Check the summary of the servers that are going to be imported/exported on the40Summary page.�h]�hJ�\Check the summary of the servers that are going to be imported/exported on the41Summary page.�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK-h heh!hubhV)��}�(h�.Click the *Finish* button to close the wizard.�h]�(hJ�42Click the �����}�(h jh!hh"NhNubh)��}�(h�*Finish*�h]�hJ�Finish�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh~h jubhJ� button to close the wizard.�����}�(h jh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK0h heh!hubeh}�(h]��using-pgadmin-4-gui�ah]�h]��using pgadmin 4 gui�ah]�h]�uhh$h h&h!hh"h#hKubh%)��}�(hhh]�(h*)��}�(h�$Using 'setup.py' command line script�h]�hJ�(Using ‘setup.py’ command line script�����}�(h j=h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j:h!hh"h#hK3ubh	�note���)��}�(hX�
To export or import servers using ``setup.py`` script, you must use43the Python interpreter that is normally used to run pgAdmin to ensure44that the required Python packages are available. In most packages, this45can be found in the Python Virtual Environment that can be found in the46installation directory. When using platform-native packages, the system47installation of Python may be the one used by pgAdmin.�h]�hV)��}�(hX�
To export or import servers using ``setup.py`` script, you must use48the Python interpreter that is normally used to run pgAdmin to ensure49that the required Python packages are available. In most packages, this50can be found in the Python Virtual Environment that can be found in the51installation directory. When using platform-native packages, the system52installation of Python may be the one used by pgAdmin.�h]�(hJ�"To export or import servers using �����}�(h jQh!hh"NhNubh	�literal���)��}�(h�``setup.py``�h]�hJ�setup.py�����}�(h j[h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jQubhJXj
 script, you must use53the Python interpreter that is normally used to run pgAdmin to ensure54that the required Python packages are available. In most packages, this55can be found in the Python Virtual Environment that can be found in the56installation directory. When using platform-native packages, the system57installation of Python may be the one used by pgAdmin.�����}�(h jQh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h jMubah}�(h]�h]�h]�h]�h]�uhjKh"h#hK5h j:h!hubh%)��}�(hhh]�(h*)��}�(h�Exporting Servers�h]�hJ�Exporting Servers�����}�(h j|h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jyh!hh"h#hK=ubhV)��}�(hX�To export the servers defined in an installation, simply invoke ``setup.py`` with58the ``dump-servers`` command line option, followed by the name (and if required,59path) to the desired output file. By default, servers owned by the desktop mode60user will be dumped (pgadmin4@pgadmin.org by default - see the DESKTOP_USER61setting in ``config.py``). This can be overridden with the ``--user`` command62line option. There can be multiple configurations of pgAdmin on the same system.63To dump the servers from specific pgAdmin config DB file, ``--sqlite-path`` option64can be used. It is also recommended to use this option when running pgAdmin in65desktop mode. By default SQLITE_PATH setting in ``config.py`` is taken.66For example:�h]�(hJ�@To export the servers defined in an installation, simply invoke �����}�(h j�h!hh"NhNubjZ)��}�(h�``setup.py``�h]�hJ�setup.py�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j�ubhJ�67 with68the �����}�(h j�h!hh"NhNubjZ)��}�(h�``dump-servers``�h]�hJ�dump-servers�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j�ubhJ�� command line option, followed by the name (and if required,69path) to the desired output file. By default, servers owned by the desktop mode70user will be dumped (�����}�(h j�h!hh"NhNubh	�	reference���)��}�(h�pgadmin4@pgadmin.org�h]�hJ�pgadmin4@pgadmin.org�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]��refuri��mailto:pgadmin4@pgadmin.org�uhj�h j�ubhJ�. by default - see the DESKTOP_USER71setting in �����}�(h j�h!hh"NhNubjZ)��}�(h�
``config.py``�h]�hJ�	config.py�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j�ubhJ�#). This can be overridden with the �����}�(h j�h!hh"NhNubjZ)��}�(h�72``--user``�h]�hJ�--user�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j�ubhJ�� command73line option. There can be multiple configurations of pgAdmin on the same system.74To dump the servers from specific pgAdmin config DB file, �����}�(h j�h!hh"NhNubjZ)��}�(h�``--sqlite-path``�h]�hJ�
--sqlite-path�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j�ubhJ�� option75can be used. It is also recommended to use this option when running pgAdmin in76desktop mode. By default SQLITE_PATH setting in �����}�(h j�h!hh"NhNubjZ)��}�(h�
``config.py``�h]�hJ�	config.py�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j�ubhJ� is taken.77For example:�����}�(h j�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK?h jyh!hubh	�
literal_block���)��}�(hX�
/path/to/python /path/to/setup.py dump-servers output_file.json78 79# or, to specify a non-default user name and auth source (the default is Internal):80 81/path/to/python /path/to/setup.py dump-servers output_file.json --user user@example.com --auth_source ldap82 83# to specify a pgAdmin config DB file:84 85/path/to/python /path/to/setup.py dump-servers output_file.json --sqlite-path /path/to/pgadmin4.db�h]�hJX�
/path/to/python /path/to/setup.py dump-servers output_file.json86 87# or, to specify a non-default user name and auth source (the default is Internal):88 89/path/to/python /path/to/setup.py dump-servers output_file.json --user user@example.com --auth_source ldap90 91# to specify a pgAdmin config DB file:92 93/path/to/python /path/to/setup.py dump-servers output_file.json --sqlite-path /path/to/pgadmin4.db�����}�h jsbah}�(h]�h]�h]�h]�h]��	xml:space��preserve��force���language��bash��highlight_args�}�uhjh"h#hKJh jyh!hubhV)��}�(h�iTo export only certain servers, use the ``--server`` option and list one or94more server IDs. For example:�h]�(hJ�(To export only certain servers, use the �����}�(h j1h!hh"NhNubjZ)��}�(h�``--server``�h]�hJ�--server�����}�(h j9h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh j1ubhJ�5 option and list one or95more server IDs. For example:�����}�(h j1h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKVh jyh!hubj)��}�(h�`/path/to/python /path/to/setup.py dump-servers output_file.json --server 1 --server 2 --server 5�h]�hJ�`/path/to/python /path/to/setup.py dump-servers output_file.json --server 1 --server 2 --server 5�����}�h jQsbah}�(h]�h]�h]�h]�h]�j*j+j,�j-�bash�j/}�uhjh"h#hKYh jyh!hubeh}�(h]��exporting-servers�ah]�h]��exporting servers�ah]�h]�uhh$h j:h!hh"h#hK=ubh%)��}�(hhh]�(h*)��}�(h�Importing Servers�h]�hJ�Importing Servers�����}�(h jlh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h jih!hh"h#hK^ubhV)��}�(hX�To import the servers defined in a JSON file, simply invoke ``setup.py`` with96the ``load-servers`` command line option, followed by the name (and if required,97path) of the JSON file containing the server definitions. Servers will be owned98by the desktop mode user (pgadmin4@pgadmin.org by default - see the DESKTOP_USER99setting in ``config.py``). This can be overridden with the ``--user`` command100line option. There can be multiple configurations of pgAdmin on the same system.101The default behaviour is for the imported servers to be added to the existent list,102which might lead to duplicates. This can be overridden with the ``--replace`` command103line option, which will replace the list of servers with the newly imported one.104To load the servers into a specific pgAdmin config DB file, ``--sqlite-path`` option105can be used. It is also recommended to use this option when running pgAdmin in106desktop mode. By default SQLITE_PATH setting in ``config.py`` is taken. For example:�h]�(hJ�<To import the servers defined in a JSON file, simply invoke �����}�(h jzh!hh"NhNubjZ)��}�(h�``setup.py``�h]�hJ�setup.py�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ�107 with108the �����}�(h jzh!hh"NhNubjZ)��}�(h�``load-servers``�h]�hJ�load-servers�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ�� command line option, followed by the name (and if required,109path) of the JSON file containing the server definitions. Servers will be owned110by the desktop mode user (�����}�(h jzh!hh"NhNubj�)��}�(h�pgadmin4@pgadmin.org�h]�hJ�pgadmin4@pgadmin.org�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]��refuri��mailto:pgadmin4@pgadmin.org�uhj�h jzubhJ�. by default - see the DESKTOP_USER111setting in �����}�(h jzh!hh"NhNubjZ)��}�(h�
``config.py``�h]�hJ�	config.py�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ�#). This can be overridden with the �����}�(h jzh!hh"NhNubjZ)��}�(h�112``--user``�h]�hJ�--user�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ�� command113line option. There can be multiple configurations of pgAdmin on the same system.114The default behaviour is for the imported servers to be added to the existent list,115which might lead to duplicates. This can be overridden with the �����}�(h jzh!hh"NhNubjZ)��}�(h�
``--replace``�h]�hJ�	--replace�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ�� command116line option, which will replace the list of servers with the newly imported one.117To load the servers into a specific pgAdmin config DB file, �����}�(h jzh!hh"NhNubjZ)��}�(h�``--sqlite-path``�h]�hJ�
--sqlite-path�����}�(h j�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ�� option118can be used. It is also recommended to use this option when running pgAdmin in119desktop mode. By default SQLITE_PATH setting in �����}�(h jzh!hh"NhNubjZ)��}�(h�
``config.py``�h]�hJ�	config.py�����}�(h jh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhjYh jzubhJ� is taken. For example:�����}�(h jzh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK`h jih!hubj)��}�(hX/path/to/python /path/to/setup.py load-servers input_file.json120 121# or, to replace the list of servers with the newly imported one:122 123/path/to/python /path/to/setup.py load-servers input_file.json --replace124 125# or, to specify a non-default user name and auth source (the default is Internal) to own the new servers:126 127/path/to/python /path/to/setup.py load-servers input_file.json --user user@example.com128 129# to specify a pgAdmin config DB file:130 131/path/to/python /path/to/setup.py load-servers input_file.json --sqlite-path /path/to/pgadmin4.db�h]�hJX/path/to/python /path/to/setup.py load-servers input_file.json132 133# or, to replace the list of servers with the newly imported one:134 135/path/to/python /path/to/setup.py load-servers input_file.json --replace136 137# or, to specify a non-default user name and auth source (the default is Internal) to own the new servers:138 139/path/to/python /path/to/setup.py load-servers input_file.json --user user@example.com140 141# to specify a pgAdmin config DB file:142 143/path/to/python /path/to/setup.py load-servers input_file.json --sqlite-path /path/to/pgadmin4.db�����}�h jsbah}�(h]�h]�h]�h]�h]�j*j+j,�j-�bash�j/}�uhjh"h#hKmh jih!hubhV)��}�(h��If any Servers are defined with a Server Group that is not already present in144the configuration database, the required Group will be created.�h]�hJ��If any Servers are defined with a Server Group that is not already present in145the configuration database, the required Group will be created.�����}�(h j*h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK}h jih!hubeh}�(h]��importing-servers�ah]�h]��importing servers�ah]�h]�uhh$h j:h!hh"h#hK^ubh%)��}�(hhh]�(h*)��}�(h�JSON format�h]�hJ�JSON format�����}�(h jCh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j@h!hh"h#hK�ubhV)��}�(hXD
The JSON file format used when importing or exporting servers is quite146straightforward and simply contains a list of servers, with a number of147attributes. The following attributes are required to be present in every server148definition: Name, Group, Port, Username, SSLMode, MaintenanceDB and one of Host,149HostAddr or Service.�h]�hJXD
The JSON file format used when importing or exporting servers is quite150straightforward and simply contains a list of servers, with a number of151attributes. The following attributes are required to be present in every server152definition: Name, Group, Port, Username, SSLMode, MaintenanceDB and one of Host,153HostAddr or Service.�����}�(h jQh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j@h!hubhV)��}�(h�/Password fields cannot be imported or exported.�h]�hJ�/Password fields cannot be imported or exported.�����}�(h j_h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j@h!hubhV)��}�(h�PThe following example shows both a minimally defined and a fully defined server:�h]�hJ�PThe following example shows both a minimally defined and a fully defined server:�����}�(h jmh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j@h!hubj)��}�(hX{154    "Servers": {155        "1": {156            "Name": "Minimally Defined Server",157            "Group": "Server Group 1",158            "Port": 5432,159            "Username": "postgres",160            "Host": "localhost",161            "SSLMode": "prefer",162            "MaintenanceDB": "postgres"163        },164        "2": {165            "Name": "Fully Defined Server",166            "Group": "Server Group 2",167            "Host": "host.domain.com",168            "HostAddr": "192.168.1.2",169            "Port": 5432,170            "MaintenanceDB": "postgres",171            "Username": "postgres",172            "Role": "my_role_name",173            "SSLMode": "require",174            "Comment": "This server has every option configured in the JSON",175            "DBRestriction": "live_db test_db",176            "PassFile": "/path/to/pgpassfile",177            "SSLCert": "/path/to/sslcert.crt",178            "SSLKey": "/path/to/sslcert.key",179            "SSLRootCert": "/path/to/sslroot.crt",180            "SSLCrl": "/path/to/sslcrl.crl",181            "SSLCompression": 1,182            "Shared": false,183            "SharedUsername": "postgres",184            "BGColor": "#ff9900",185            "FGColor": "#000000",186            "Service": "postgresql-10",187            "Timeout": 60,188            "UseSSHTunnel": 1,189            "TunnelHost": "192.168.1.253",190            "TunnelPort": 22,191            "TunnelUsername": "username",192            "TunnelAuthentication": 0,193            "PasswordExecCommand": "echo 'test'",194            "PasswordExecExpiration": 100195        }196    }197}�h]�hJX{198    "Servers": {199        "1": {200            "Name": "Minimally Defined Server",201            "Group": "Server Group 1",202            "Port": 5432,203            "Username": "postgres",204            "Host": "localhost",205            "SSLMode": "prefer",206            "MaintenanceDB": "postgres"207        },208        "2": {209            "Name": "Fully Defined Server",210            "Group": "Server Group 2",211            "Host": "host.domain.com",212            "HostAddr": "192.168.1.2",213            "Port": 5432,214            "MaintenanceDB": "postgres",215            "Username": "postgres",216            "Role": "my_role_name",217            "SSLMode": "require",218            "Comment": "This server has every option configured in the JSON",219            "DBRestriction": "live_db test_db",220            "PassFile": "/path/to/pgpassfile",221            "SSLCert": "/path/to/sslcert.crt",222            "SSLKey": "/path/to/sslcert.key",223            "SSLRootCert": "/path/to/sslroot.crt",224            "SSLCrl": "/path/to/sslcrl.crl",225            "SSLCompression": 1,226            "Shared": false,227            "SharedUsername": "postgres",228            "BGColor": "#ff9900",229            "FGColor": "#000000",230            "Service": "postgresql-10",231            "Timeout": 60,232            "UseSSHTunnel": 1,233            "TunnelHost": "192.168.1.253",234            "TunnelPort": 22,235            "TunnelUsername": "username",236            "TunnelAuthentication": 0,237            "PasswordExecCommand": "echo 'test'",238            "PasswordExecExpiration": 100239        }240    }241}�����}�h j{sbah}�(h]�h]�h]�h]�h]�j*j+j,�j-�python�j/}�uhjh"h#hK�h j@h!hubeh}�(h]��json-format�ah]�h]��json format�ah]�h]�uhh$h j:h!hh"h#hK�ubeh}�(h]��"using-setup-py-command-line-script�ah]�h]��$using 'setup.py' command line script�ah]�h]�uhh$h h&h!hh"h#hK3ubeh}�(h]�(h�id1�eh]�h]�(�import/export servers��import_export_servers�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�j�hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K�242translated�Kuuhh
�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N�	generator�N�	datestamp�N�root_prefix��
/��source_link�N�243source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�244halt_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�j��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�}�(j�hj�j�j7j4j�j�jfjcj=j:j�j�u�	nametypes�}�(j��j��j7�j��jf�j=�j��uh}�(hh&j�h&j4hej�j:jcjyj:jij�j@u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]��	footnotes�]��	citations�]��autofootnote_start�K
�symbol_footnote_start�K�245id_counter��collections��Counter���}�j�K
s��R��parse_messages�]��transform_messages�]�(h	�system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�;Hyperlink target "import-export-servers" is not referenced.�����}�h j;sbah}�(h]�h]�h]�h]�h]�uhhUh j8ubah}�(h]�h]�h]�h]�h]��level�K
�type��INFO��source�h#�line�K
uhj6ubj7)��}�(hhh]�hV)��}�(hhh]�hJ�-Hyperlink target "index-0" is not referenced.�����}�h jVsbah}�(h]�h]�h]�h]�h]�uhhUh jSubah}�(h]�h]�h]�h]�h]��level�K
�type�jP�source�h#�line�Kuhj6ube�transformer�N�include_log�]��246decoration�Nh!hub.