尝试使用图形Windows安装程序x64安装PostgreSQL时,无法将其作为Windows服务安装

>Windows Specific Configuraton
>[14:07:54] Windows Actions (services)
>Starting service "PostgreSQL 9.6 Server"
>Executing sc start "PostgreSQL 9.6 Server"
>Script exit code: 1060
>
>Script output:
> [SC] StartService: OpenService FAILED 1060:
>
>The specified service does not exist as an installed service.
>
>
>Script stderr:
> Program ended with an error exit code
>
>Error running sc start "PostgreSQL 9.6 Server": Program ended with an error >exit code
>Problem running post-install step. Installation may not complete correctly
> Error running sc start "PostgreSQL 9.6 Server": Program ended with an error >exit code

我该如何纠正,为什么会发生这种情况?

最佳答案

您可以尝试手动安装服务,使用

pg_ctl register [-N servicename] [-U username] [-P password] [-D datadir] [-S a[uto] | d[emand] ] [-w] [-t seconds] [-s] [-o options]

根据PostgreSQL documentation on pg_ctl
register模式允许您在Microsoft Windows上注册系统服务。-S选项允许选择服务启动类型,可以是“auto”(系统启动时自动启动服务)或“demand”(按需启动服务)。
如果pg_ctl无法注册服务,它很可能会给出一条正确的错误消息,指向正确的方向(datadir不正确,username访问和写入datadir的权限不足等)。
图形安装程序(至少与EnterpriseDB一起)使用的“标准”服务名是:PostgreSQL 64位版本9.6.*的postgresql-x64-9.6

09-16 05:40