postgreSQL数据库服务 [英] postgreSQL database service

问题描述

我从他们的网站下载了PostgreSQL - http://www.postgresql.org/download/windows

但是，我无法从 pgAdmin 创建数据库，并收到一条消息：

无法连接到服务器：
连接被拒绝（0x0000274D / 10061）
服务器在主机
localhost上运行并接受TCP / IP
端口5432上的连接？不能
连接到服务器：拒绝连接
（0x0000274D / 10061）服务器
在主机localhost上运行，
在端口
上接受TCP / IP连接5432？

我必须创建一个Windows服务吗？如何调用它？

让我自己解释一下。我试图运行serivce。我尝试从命令行的postgres程序，但仍然不运行。

可以运行数据库？

已修改

问题出在我的安装文件。

解决方案

使用服务（开始 - >运行 - > services.msc）对于postgresql- [version]服务。

• 如果不是，您可能刚刚安装了pgAdmin并且没有安装PostgreSQL本身。 li>
  
• 如果它没有运行尝试启动它，如果它不会开始打开事件查看器（开始 - >运行 - > eventvwr），并查找与PostgreSQL服务相关的错误消息。


• 如果它开始检查启动类型，如果你想要它开始与Windows应该是自动;

---

添加到第一个，因为在不同的注释中，你说服务不在那里。可以下载一个独立的pgAdmin，这样您可以连接到一个外部的PostgreSQL数据库。看来你已经做了这样的事情，或明确选择不添加服务。只需尝试一键安装程序，即使其名称仍然允许正确配置安装目录。

I downloaded PostgreSQL from their site - http://www.postgresql.org/download/windows

However, I can't create a database from pgAdmin and get a message:

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?

Do I have to create a windows service? How is it called? Do I have to install it separately?

EDITED

Let me explain myself. I am trying to run the serivce. I tried the postgres program from command line but still it does not run.

What could run the database?

EDITED

The problem was with my installation file. I downloaded it again - and it worked well!

解决方案

Use services (start -> run -> services.msc) and look for the postgresql-[version] service.

• If it is not there you might have just installed pgAdmin and not installed PostgreSQL itself.
• If it is not running try to start it, if it won't start open the event-viewer (start -> run -> eventvwr) and look for error messages relating to the PostgreSQL service.
• If it does start check the startup type, if you want it to start with windows it should be "Automatic"; or perhaps "Automatic, delayed start" if you don't want it to slow down startup too much.

---

Adding to the first, because in a different comment you've said the service isn't there. It is possible to download a standalone pgAdmin so you can connect to an external PostgreSQL database. It would seem you have done such a thing, or explicitly chosen to not add the service. Just try the One Click Installer, which still allows proper configuration of installation directory despite its name.

这篇关于postgreSQL数据库服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！