Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

LikeSaveClone

rootpgsqlpgAdmin 4docsen_UShtmlbackup_globals_dialog.html

backup_globals_dialog.html157 linesCopy pathDownload Raw Back to html

1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6  <head>
7    <meta charset="utf-8" />
8    <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10    <title>Backup Globals Dialog &#8212; pgAdmin 4 8.6 documentation</title>
11    <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12    <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13    
14    <script src="_static/documentation_options.js?v=d4c83366"></script>
15    <script src="_static/doctools.js?v=9a2dae69"></script>
16    <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17    
18    <script src="_static/sidebar.js"></script>
19    
20    <link rel="index" title="Index" href="genindex.html" />
21    <link rel="search" title="Search" href="search.html" />
22    <link rel="next" title="Backup Server Dialog" href="backup_server_dialog.html" />
23    <link rel="prev" title="Backup Dialog" href="backup_dialog.html" /> 
24  </head><body>
25    <div class="related" role="navigation" aria-label="related navigation">
26      <h3>Navigation</h3>
27      <ul>
28        <li class="right" style="margin-right: 10px">
29          <a href="genindex.html" title="General Index"
30             accesskey="I">index</a></li>
31        <li class="right" >
32          <a href="backup_server_dialog.html" title="Backup Server Dialog"
33             accesskey="N">next</a> |</li>
34        <li class="right" >
35          <a href="backup_dialog.html" title="Backup Dialog"
36             accesskey="P">previous</a> |</li>
37        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
38          <li class="nav-item nav-item-1"><a href="backup_and_restore.html" accesskey="U">Backup and Restore</a> &#187;</li>
39        <li class="nav-item nav-item-this"><a href="">Backup Globals Dialog</a></li> 
40      </ul>
41    </div>  
42
43    <div class="document">
44      <div class="documentwrapper">
45        <div class="bodywrapper">
46          <div class="body" role="main">
47            
48  <section id="backup-globals-dialog">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Backup Globals Dialog<a class="headerlink" href="#backup-globals-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the <em>Backup Globals</em> dialog to create a plain-text script that recreates all
51of the database objects within a cluster, and the global objects that are shared
52by those databases. Global objects include tablespaces, roles, and object
53properties. You can use the pgAdmin <em>Query Tool</em> to play back a plain-text
54script, and recreate the objects in the backup.</p>
55<img alt="Backup globals dialog" class="align-center" src="_images/backup_globals_general.png" />
56<p>Use the fields in the <em>General</em> tab to specify the following:</p>
57<ul class="simple">
58<li><p>Enter the name of the backup file in the <em>Filename</em> field.  Optionally, select
59the <em>Browser</em> icon (ellipsis) to the right to navigate into a directory and
60select a file that will contain the archive.</p></li>
61<li><p>Use the drop-down listbox next to <em>Role name</em> to specify a role with
62connection privileges on the selected server.  The role will be used for
63authentication during the backup.</p></li>
64</ul>
65<p>Move switches in the <strong>Miscellaneous</strong> field box to specify the type of
66statements that should be included in the backup.</p>
67<ul class="simple">
68<li><p>Move the <em>Verbose messages</em> switch to the <em>No</em> position to exclude status
69messages from the backup. The default is <em>Yes</em>.</p></li>
70<li><p>Move the <em>Force double quote on identifiers</em> switch to the <em>Yes</em> position to
71name identifiers without changing case. The default is <em>No</em>.</p></li>
72</ul>
73<p>Click the <em>Backup</em> button to build and execute a command based on your
74selections; click the <em>Cancel</em> button to exit without saving work.</p>
75<p>pgAdmin will run the backup process in background. You can view all the background
76process with there running status and logs on the <a class="reference internal" href="processes.html#processes"><span class="std std-ref">Processes</span></a>
77tab</p>
78</section>
79
80
81            <div class="clearer"></div>
82          </div>
83        </div>
84      </div>
85      <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
86        <div class="sphinxsidebarwrapper">
87<h3><a href="index.html">Table of Contents</a></h3>
88<ul class="current">
89<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
90<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
91<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
92<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
93<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
94<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
95<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
96<li class="toctree-l1 current"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a><ul class="current">
97<li class="toctree-l2"><a class="reference internal" href="backup_dialog.html">Backup Dialog</a></li>
98<li class="toctree-l2 current"><a class="current reference internal" href="#">Backup Globals Dialog</a></li>
99<li class="toctree-l2"><a class="reference internal" href="backup_server_dialog.html">Backup Server Dialog</a></li>
100<li class="toctree-l2"><a class="reference internal" href="restore_dialog.html">Restore Dialog</a></li>
101</ul>
102</li>
103<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
104<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
105<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
106<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
107<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
108<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
109</ul>
110
111<search id="searchbox" style="display: none" role="search">
112  <h3 id="searchlabel">Quick search</h3>
113    <div class="searchformwrapper">
114    <form class="search" action="search.html" method="get">
115      <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
116      <input type="submit" value="Go" />
117    </form>
118    </div>
119</search>
120<script>document.getElementById('searchbox').style.display = "block"</script>
121        </div>
122<div id="sidebarbutton" title="Collapse sidebar">
123<span>«</span>
124</div>
125
126      </div>
127      <div class="clearer"></div>
128    </div>
129    <div class="related" role="navigation" aria-label="related navigation">
130      <h3>Navigation</h3>
131      <ul>
132        <li class="right" style="margin-right: 10px">
133          <a href="genindex.html" title="General Index"
134             >index</a></li>
135        <li class="right" >
136          <a href="backup_server_dialog.html" title="Backup Server Dialog"
137             >next</a> |</li>
138        <li class="right" >
139          <a href="backup_dialog.html" title="Backup Dialog"
140             >previous</a> |</li>
141        <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> &#187;</li>
142          <li class="nav-item nav-item-1"><a href="backup_and_restore.html" >Backup and Restore</a> &#187;</li>
143        <li class="nav-item nav-item-this"><a href="">Backup Globals Dialog</a></li> 
144      </ul>
145    </div>
146    <div class="footer" role="contentinfo">
147        <div class="related" role="navigation" aria-label="related navigation">
148          <ul>
149              <li class="left" style="margin-left: 10px">&#169; Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
150            <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
151            <li class="right" ><a href="backup_server_dialog.html" title="Backup Server Dialog" accesskey="N">next</a> |</li>
152            <li class="right" ><a href="backup_dialog.html" title="Backup Dialog" accesskey="P">previous</a> |</li>
153          </ul>
154        </div>
155    </div>
156  </body>
157</html>