postgresql pgAdmin III:没有服务器出现

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/29494384/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-21 01:50:55  来源:igfitidea点击:

pgAdmin III : No servers showing up

postgresqlpgadmin

提问by user3003976

I've followed many online tutorials on how to install pgAdmin correctly, I've installed and uninstalled it multiple times but whenever install it. It shows Server Groups without any servers in it.

我已经学习了许多关于如何正确安装 pgAdmin 的在线教程,我已经多次安装和卸载它,但每次都安装它。它显示其中没有任何服务器的服务器组。

Then when I try and register a new server using localhostfor both name and host I get this error:

然后,当我尝试使用localhostname 和 host注册新服务器时,我收到此错误:

server doesn't listen

Searched for days trying to find a solution for this, any ideas?enter image description here

搜索了几天试图找到解决方案,有什么想法吗?在此处输入图片说明

采纳答案by user3003976

Reinstalled program and saved it to directory C:\ instead of C:\program_Files

重新安装程序并将其保存到目录 C:\ 而不是 C:\program_Files

回答by user3003976

happened with me as well, when I started pgadmin3 for the first time, i was expecting it to ask for the password which I provided during but it didnt ask and then didnt display any servers.
anyways, you can create a server yourself,
if your server is on the same machine,
provide a name: test
provide server: localhost
port: 5432 (default port)
user: postgres (default user) you can change later in login roles
password: provide something

我也发生过这种情况,当我第一次启动 pgadmin3 时,我期待它询问我在此期间提供的密码,但它没有询问,然后没有显示任何服务器。
无论如何,您可以自己创建一个服务器,
如果您的服务器在同一台机器上,请
提供一个名称:测试
提供服务器:本地主机
端口:5432(默认端口)
用户:postgres(默认用户)您可以稍后在登录角色中
更改密码:提供一些东西

restart if required and it will then show you
database with postgres (default db),
tablespace,
login roles
under your server and you should be good to go

如果需要,重新启动,然后它会向您显示
带有 postgres(默认数据库)、
表空间、 服务器下的
登录角色的数据库,
您应该很高兴

回答by Inamur Rahman

First Create a Server with the following credential-

首先使用以下凭据创建服务器 -

Host Name/address : localhost
Port : 5432
Maintenance database : postgres

Username : postgres
Password : *Your_Password*

Note: Before Creating the Server first start the postgresql server

注意在创建服务器之前先启动postgresql服务器