blocks|key|1267956|text|您需要检查您的日志文件和windows事件日志，以了解问题所在。如果那里什么都没有，您需要中断进程监视器之类的东西，并获得挂起位置的堆栈跟踪。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1267957|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You need to check your logfiles and the windows eventlog for some hint of what the problem is. If there is nothing at all there, you need to break out something like Process Monitor and get a stacktrace of where it's hung.

blocks|key|1268010|text|我以前遇到过这个问题，那就是安装程序没有为运行服务的用户正确设置权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1268011|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I have had this issue in the past, and it was that the installer did not set up the permissions correctly for the user that the service was to run as.

blocks|key|1268090|text|这发生在我身上，因为我将我的数据目录设置为postgres+windows用户帐户无法访问的位置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1268091|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

this happened to me because i set my data directory to be somewhere the postgres windows user account didn't have access to.

blocks|key|1268162|text|命令runservice只能由服务管理器执行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1268163|为了修复我的localhost+windows7以将postgres作为服务启动，我使用以下命令启动数据|1268164|+pg_ctl+-D+"C:\Program+Files\PostgreSQL\9.1\data"+start+|code-block|syntax|javascript|1268165|然后检查错误的状态|1268166|+pg_ctl+-D+"C:\Program+Files\PostgreSQL\9.1\data"+status+|1268167|如果您得到错误1063，这是非常可能的权限，我执行了以下命令|1268168|+cacls+"C:\Program+Files\PostgreSQL\9.1\data"+/E+/T+/C+/G+postgres:F|1268169|然后重新运行启动/状态，显示一切正常，但服务管理器仍然不会启动服务|1268170|因此，在Services->postgresql->options->logon中，我将登录设置为本地系统帐户，而不是postgres用户|1268171|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

The command runservice can only be executed by the service manager

in order to fix my localhost windows 7 to start postgres as a service
i used the following command to start the data

<pre><code> pg_ctl -D "C:\Program Files\PostgreSQL\9.1\data" start 
</code></pre>

Then checked the status for errors

<pre><code> pg_ctl -D "C:\Program Files\PostgreSQL\9.1\data" status 
</code></pre>

if you get error 1063 , its more than likely permissions, i executed the following command

<pre><code> cacls "C:\Program Files\PostgreSQL\9.1\data" /E /T /C /G postgres:F
</code></pre>

then reran the start/status, it showed everything fine, but still service manager would not start the service

So, in Services->postgresql->options->logon i set the log on as the Local system account instead of the postgres user, and voila it worked

blocks|key|1482790|text|在系统崩溃后，我在Windows中遇到了这个问题。运行第一个命令时，C:\Program+Files\PostgreSQL\9.1\data\postmaster.pid中显示无效数据。删除该文件起到了作用。Reference.|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1482791|entityMap|0|LINK|mutability|MUTABLE|url|http://scratching.psybermonkey.net/2009/05/postgresql-pgctl-invalid-data-in-pid.html^0|Y|1F|2W|A|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

I had this problem in Windows after a system crash. Running the first command showed invalid data in <code>C:\Program Files\PostgreSQL\9.1\data\postmaster.pid</code>. Deleting that file did the trick. <a href="http://scratching.psybermonkey.net/2009/05/postgresql-pgctl-invalid-data-in-pid.html" rel="noreferrer">Reference.</a>

blocks|key|1482868|text|打开pgAdmin+III，然后在右窗格中找到服务器，然后右键单击并连接，输入密码。连接后，转到浏览器并刷新ODOO。问题解决了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1482869|请参阅图像以更好地了解|1482870|​|1482871|📷|atomic|offset|length|1482872|1482873|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/45567b0c0b0e4ee56b1f001f4f762ebe.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

open pgAdmin III and then in right pane find server then just right click and connect, enter the password. after connected go to the browser and refresh ODOO. Problem solved.

See image to get better understanding

<a href="https://i.stack.imgur.com/9WNTI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9WNTI.png" alt="enter image description here"></a>

blocks|key|1268328|text|sc+create+"postgresql-9.2"+binPath=+"\"C:/Program+Files+(x86)/PostgreSQL/9.2/bin/pg_ctl.exe\"+runservice+-N+\"postgresql-9.2\"+-D+\"C:/Program+Files+(x86)/PostgreSQL/9.2/data\"+-w"+DisplayName=+"postgresql-9.2"+start=+auto|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1268329|在CMD上尝试以管理员身份运行(添加参数取决于您的版本)|unstyled|1268330|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>sc create "postgresql-9.2" binPath= "\"C:/Program Files (x86)/PostgreSQL/9.2/bin/pg_ctl.exe\" runservice -N \"postgresql-9.2\" -D \"C:/Program Files (x86)/PostgreSQL/9.2/data\" -w" DisplayName= "postgresql-9.2" start= auto
</code></pre>

Try this on CMD run as Administrator
(Add your parameters depend on your version)

blocks|key|1482933|text|确保C:\中没有像C:\Program那样有buggy的空文件Program|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1482934|在这种情况下，只要您登录到Windows，资源管理器就会发出警告。|1482935|File+Name+Warning
-----------------
There+is+a+file+or+folder+on+your+computer+called+"C:\Program"+which
could+cause+certain+applications+to+not+function+correctly.+Renaming+it
to+"C:\Program1"+would+solve+this+problem.+Would+you+like+to+rename
it+now?|code-block|syntax|javascript|1482936|entityMap^0|2|3|9|A|V|7|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

Make sure there is no buggy empty file <code>Program</code> at <code>C:\</code> like <code>C:\Program</code>
In this case, explorer will warn whenever you log on into Windows.
<pre><code>File Name Warning
-----------------
There is a file or folder on your computer called &quot;C:\Program&quot; which
could cause certain applications to not function correctly. Renaming it
to &quot;C:\Program1&quot; would solve this problem. Would you like to rename
it now?
</code></pre>

I had this in my Windows services:

<pre><code>C:/Program Files/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "postgresql-8.4" -D "D:/PostgreSQL/8.4/data" -w
</code></pre>

It never finishes executing. But if I did this on the dos shell:

<pre><code>C:/Program Files/PostgreSQL/8.4/bin/pg_ctl.exe start -N "postgresql-8.4" -D "D:/PostgreSQL/8.4/data" -w
</code></pre>

Notice that I only changed the "runservice" to "start" and it works just fine.

Any idea?

Unable to run PostgreSQL as Windows service

日志文件

PostgreSQL

服务器

Windows

我在我的Windows服务中有这样的设置：C:/Program Files/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "postgresql-8.4" -D "D:/PostgreSQL/8.4/data" -w它永远不会完成执行。但是如果我在dos shell上这样做：C...

问无法将PostgreSQL作为Windows服务运行
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法将PostgreSQL作为Windows服务运行EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法将PostgreSQL作为Windows服务运行
EN