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>Connection Error — 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="Import/Export Servers" href="import_export_servers.html" />
23 <link rel="prev" title="Connect to Server" href="connect_to_server.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="import_export_servers.html" title="Import/Export Servers"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="connect_to_server.html" title="Connect to Server"
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-1"><a href="connecting.html" accesskey="U">Connecting To A Server</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">Connection Error</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="connection-error">
49<span id="connect-error"></span><h1><span class="target" id="index-0"></span>Connection Error<a class="headerlink" href="#connection-error" title="Link to this heading">¶</a></h1>
50<p>When connecting to a PostgreSQL server, you may get an error message. If you
51encounter an error message, please review the message carefully; each error
52message attempts to incorporate the information you’ll need to resolve the
53problem. For more details about specific errors, please locate the error
54message in the list below:</p>
55<p><strong>Connection to the server has been lost</strong></p>
56<img alt="Connection to the server has been lost" class="align-center" src="_images/ce_timeout.png" />
57<p>This error message indicates that the connection attempt has taken longer than
58the specified threshold; there may be a problem with the connection properties
59provided on the <em>Server</em> dialog, network connectivity issues, or the server may
60not be running.</p>
61<p><strong>could not connect to Server: Connection refused</strong></p>
62<img alt="Could not connect to server" class="align-center" src="_images/ce_not_running.png" />
63<dl class="simple">
64<dt>If pgAdmin displays this message, there are two possible reasons for this:</dt><dd><ul class="simple">
65<li><p>the database server isn’t running - simply start it.</p></li>
66<li><p>the server isn’t configured to accept TCP/IP requests on the address shown.</p></li>
67</ul>
68</dd>
69</dl>
70<p>For security reasons, a PostgreSQL server “out of the box” doesn’t listen on
71TCP/IP ports. Instead, it must be enabled to listen for TCP/IP requests. This
72can be done by adding <strong>listen_addresses=’*’</strong>; this will make the server accept
73connections on any IP interface.</p>
74<p>For further information, please refer to the PostgreSQL documentation about
75<a class="reference external" href="https://www.postgresql.org/docs/current/runtime-config.html">runtime configuration</a>.</p>
76<p><strong>FATAL: no pg_hba.conf entry</strong></p>
77<img alt="No pg_hba.conf entry" class="align-center" src="_images/ce_error_hba.png" />
78<p>If pgAdmin displays this message when connecting, your server can be contacted
79correctly over the network, but is not configured to accept your connection.
80Your client has not been detected as a legal user for the database.</p>
81<p>To connect to a server, the pg_hba.conf file on the database server must be
82configured to accept connections from the host of the pgAdmin client. Modify
83the pg_hba.conf file on the database server host, and add an entry in the form:</p>
84<blockquote>
85<div><ul class="simple">
86<li><p><strong>host template1 postgres 192.168.0.0/24 md5</strong> for an IPV4 network</p></li>
87<li><p><strong>host template1 postgres ::ffff:192.168.0.0/120 md5</strong> for an IPV6 network</p></li>
88</ul>
89</div></blockquote>
90<p>For more information, please refer to the PostgreSQL documentation about
91<a class="reference external" href="https://www.postgresql.org/docs/current/client-authentication.html">client authentication</a>.</p>
92<p><strong>FATAL: password authentication failed</strong></p>
93<img alt="Password authentication failed" class="align-center" src="_images/ce_password_failed.png" />
94<p>The <em>password authentication failed for user</em> error message indicates there
95may be a problem with the password you entered. Retry the password to confirm
96you entered it correctly. If the error message returns, make sure that you have
97the correct password, that you are authorized to access the server, and that
98the access has been correctly configured in the server’s postgresql.conf
99configuration file.</p>
100</section>
101
102
103 <div class="clearer"></div>
104 </div>
105 </div>
106 </div>
107 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
108 <div class="sphinxsidebarwrapper">
109<h3><a href="index.html">Table of Contents</a></h3>
110<ul class="current">
111<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
112<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
113<li class="toctree-l1 current"><a class="reference internal" href="connecting.html">Connecting To A Server</a><ul class="current">
114<li class="toctree-l2"><a class="reference internal" href="server_group_dialog.html">Server Group Dialog</a></li>
115<li class="toctree-l2"><a class="reference internal" href="server_dialog.html">Server Dialog</a></li>
116<li class="toctree-l2"><a class="reference internal" href="cloud_deployment.html">PostgreSQL Cloud Deployment</a></li>
117<li class="toctree-l2"><a class="reference internal" href="master_password.html">Master Password</a></li>
118<li class="toctree-l2"><a class="reference internal" href="connect_to_server.html">Connect to Server</a></li>
119<li class="toctree-l2 current"><a class="current reference internal" href="#">Connection Error</a></li>
120<li class="toctree-l2"><a class="reference internal" href="import_export_servers.html">Import/Export Servers</a></li>
121</ul>
122</li>
123<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
124<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
125<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
126<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
127<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
128<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
129<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
130<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
131<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
132<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
133<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
134</ul>
135
136<search id="searchbox" style="display: none" role="search">
137 <h3 id="searchlabel">Quick search</h3>
138 <div class="searchformwrapper">
139 <form class="search" action="search.html" method="get">
140 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
141 <input type="submit" value="Go" />
142 </form>
143 </div>
144</search>
145<script>document.getElementById('searchbox').style.display = "block"</script>
146 </div>
147<div id="sidebarbutton" title="Collapse sidebar">
148<span>«</span>
149</div>
150
151 </div>
152 <div class="clearer"></div>
153 </div>
154 <div class="related" role="navigation" aria-label="related navigation">
155 <h3>Navigation</h3>
156 <ul>
157 <li class="right" style="margin-right: 10px">
158 <a href="genindex.html" title="General Index"
159 >index</a></li>
160 <li class="right" >
161 <a href="import_export_servers.html" title="Import/Export Servers"
162 >next</a> |</li>
163 <li class="right" >
164 <a href="connect_to_server.html" title="Connect to Server"
165 >previous</a> |</li>
166 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
167 <li class="nav-item nav-item-1"><a href="connecting.html" >Connecting To A Server</a> »</li>
168 <li class="nav-item nav-item-this"><a href="">Connection Error</a></li>
169 </ul>
170 </div>
171 <div class="footer" role="contentinfo">
172 <div class="related" role="navigation" aria-label="related navigation">
173 <ul>
174 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
175 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
176 <li class="right" ><a href="import_export_servers.html" title="Import/Export Servers" accesskey="N">next</a> |</li>
177 <li class="right" ><a href="connect_to_server.html" title="Connect to Server" accesskey="P">previous</a> |</li>
178 </ul>
179 </div>
180 </div>
181 </body>
182</html>