codekingpro/portable-devtools
114k
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>Connecting To A Server — 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="Server Group Dialog" href="server_group_dialog.html" />
23 <link rel="prev" title="External database for pgAdmin user settings" href="external_database.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="server_group_dialog.html" title="Server Group Dialog"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="external_database.html" title="External database for pgAdmin user settings"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-this"><a href="">Connecting To A Server</a></li>
39 </ul>
40 </div>
41
42 <div class="document">
43 <div class="documentwrapper">
44 <div class="bodywrapper">
45 <div class="body" role="main">
46
47 <section id="connecting-to-a-server">
48<span id="connecting"></span><h1><span class="target" id="index-0"></span>Connecting To A Server<a class="headerlink" href="#connecting-to-a-server" title="Link to this heading">¶</a></h1>
49<p>Before you can use the pgAdmin client to manage the objects that reside on your
50Postgres server, you must define a connection to the server. You can
51(optionally) use the <em>Server Group</em> dialog to create server groups to organize
52the server connections within the tree control for easier management. To open
53the <em>Server Group</em> dialog, right-click on the <em>Servers</em> node of the tree
54control, and select <em>Server Group</em> from the <em>Create</em> menu.</p>
55<div class="toctree-wrapper compound">
56<ul>
57<li class="toctree-l1"><a class="reference internal" href="server_group_dialog.html">Server Group Dialog</a></li>
58</ul>
59</div>
60<p>Use the fields on the <em>Server</em> dialog to define the connection properties for
61each new server that you wish to manage with pgAdmin. To open the <em>Server</em>
62dialog, right-click on the <em>Servers</em> node of the tree control, and select
63<em>Server</em> from the <em>Register</em> menu.</p>
64<div class="toctree-wrapper compound">
65<ul>
66<li class="toctree-l1"><a class="reference internal" href="server_dialog.html">Server Dialog</a><ul>
67<li class="toctree-l2"><a class="reference internal" href="clear_saved_passwords.html">Clear Saved Passwords</a></li>
68</ul>
69</li>
70</ul>
71</div>
72<p>Alternatively you can use the <em>Cloud Deployment</em> wizard to deploy a new
73PostgreSQL instance in the cloud, and connect to it.</p>
74<div class="toctree-wrapper compound">
75<ul>
76<li class="toctree-l1"><a class="reference internal" href="cloud_deployment.html">PostgreSQL Cloud Deployment</a><ul>
77<li class="toctree-l2"><a class="reference internal" href="cloud_aws_rds.html">Amazon RDS Cloud Deployment</a></li>
78<li class="toctree-l2"><a class="reference internal" href="cloud_edb_biganimal.html">EDB BigAnimal Cloud Deployment</a></li>
79<li class="toctree-l2"><a class="reference internal" href="cloud_azure_database.html">Azure Database Cloud Deployment</a></li>
80<li class="toctree-l2"><a class="reference internal" href="cloud_google_cloud_sql.html">Google Cloud SQL Deployment</a></li>
81</ul>
82</li>
83</ul>
84</div>
85<p>A master password is required to secure and later unlock saved server passwords.
86It is set by the user and can be disabled using config.</p>
87<div class="toctree-wrapper compound">
88<ul>
89<li class="toctree-l1"><a class="reference internal" href="master_password.html">Master Password</a></li>
90</ul>
91</div>
92<p>After defining a server connection, right-click on the server name, and select
93<em>Connect to server</em> to authenticate with the server, and start using pgAdmin to
94manage objects that reside on the server.</p>
95<div class="toctree-wrapper compound">
96<ul>
97<li class="toctree-l1"><a class="reference internal" href="connect_to_server.html">Connect to Server</a></li>
98<li class="toctree-l1"><a class="reference internal" href="connect_error.html">Connection Error</a></li>
99</ul>
100</div>
101<p>Server definitions (and their groups) can be exported to a JSON file and
102re-imported to the same or a different system to enable easy pre-configuration
103of pgAdmin.</p>
104<div class="toctree-wrapper compound">
105<ul>
106<li class="toctree-l1"><a class="reference internal" href="import_export_servers.html">Import/Export Servers</a><ul>
107<li class="toctree-l2"><a class="reference internal" href="import_export_servers.html#using-pgadmin-4-gui">Using pgAdmin 4 GUI</a></li>
108<li class="toctree-l2"><a class="reference internal" href="import_export_servers.html#using-setup-py-command-line-script">Using ‘setup.py’ command line script</a><ul>
109<li class="toctree-l3"><a class="reference internal" href="import_export_servers.html#exporting-servers">Exporting Servers</a></li>
110<li class="toctree-l3"><a class="reference internal" href="import_export_servers.html#importing-servers">Importing Servers</a></li>
111<li class="toctree-l3"><a class="reference internal" href="import_export_servers.html#json-format">JSON format</a></li>
112</ul>
113</li>
114</ul>
115</li>
116</ul>
117</div>
118</section>
119
120
121 <div class="clearer"></div>
122 </div>
123 </div>
124 </div>
125 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
126 <div class="sphinxsidebarwrapper">
127<h3><a href="index.html">Table of Contents</a></h3>
128<ul class="current">
129<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
130<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
131<li class="toctree-l1 current"><a class="current reference internal" href="#">Connecting To A Server</a><ul>
132<li class="toctree-l2"><a class="reference internal" href="server_group_dialog.html">Server Group Dialog</a></li>
133<li class="toctree-l2"><a class="reference internal" href="server_dialog.html">Server Dialog</a></li>
134<li class="toctree-l2"><a class="reference internal" href="cloud_deployment.html">PostgreSQL Cloud Deployment</a></li>
135<li class="toctree-l2"><a class="reference internal" href="master_password.html">Master Password</a></li>
136<li class="toctree-l2"><a class="reference internal" href="connect_to_server.html">Connect to Server</a></li>
137<li class="toctree-l2"><a class="reference internal" href="connect_error.html">Connection Error</a></li>
138<li class="toctree-l2"><a class="reference internal" href="import_export_servers.html">Import/Export Servers</a></li>
139</ul>
140</li>
141<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
142<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
143<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
144<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
145<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
146<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
147<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
148<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
149<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
150<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
151<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
152</ul>
153
154<search id="searchbox" style="display: none" role="search">
155 <h3 id="searchlabel">Quick search</h3>
156 <div class="searchformwrapper">
157 <form class="search" action="search.html" method="get">
158 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
159 <input type="submit" value="Go" />
160 </form>
161 </div>
162</search>
163<script>document.getElementById('searchbox').style.display = "block"</script>
164 </div>
165<div id="sidebarbutton" title="Collapse sidebar">
166<span>«</span>
167</div>
168
169 </div>
170 <div class="clearer"></div>
171 </div>
172 <div class="related" role="navigation" aria-label="related navigation">
173 <h3>Navigation</h3>
174 <ul>
175 <li class="right" style="margin-right: 10px">
176 <a href="genindex.html" title="General Index"
177 >index</a></li>
178 <li class="right" >
179 <a href="server_group_dialog.html" title="Server Group Dialog"
180 >next</a> |</li>
181 <li class="right" >
182 <a href="external_database.html" title="External database for pgAdmin user settings"
183 >previous</a> |</li>
184 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
185 <li class="nav-item nav-item-this"><a href="">Connecting To A Server</a></li>
186 </ul>
187 </div>
188 <div class="footer" role="contentinfo">
189 <div class="related" role="navigation" aria-label="related navigation">
190 <ul>
191 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
192 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
193 <li class="right" ><a href="server_group_dialog.html" title="Server Group Dialog" accesskey="N">next</a> |</li>
194 <li class="right" ><a href="external_database.html" title="External database for pgAdmin user settings" accesskey="P">previous</a> |</li>
195 </ul>
196 </div>
197 </div>
198 </body>
199</html>