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
pgAdmin III : No servers showing up
提问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 localhost
for both name and host I get this error:
然后,当我尝试使用localhost
name 和 host注册新服务器时,我收到此错误:
server doesn't listen
Searched for days trying to find a solution for this, any ideas?
搜索了几天试图找到解决方案,有什么想法吗?
采纳答案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服务器