Thread: pg_ctl start fails on Windows
The error message is "could not open PID file". I can manually create the file "postmaster.pid", so the problem Does not look like a permission problem. Thanks Danny
Could still be a permission problem. Whatever NT account you are using
as the service account (usally called postgres) for the PostgreSQL
server is the one that needs to be able to create the postmaster.pid.
Make sure that account has full rights to the data folder.
Hope that helps,
Regina
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Abraham, Danny
Sent: Monday, December 24, 2007 9:38 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pg_ctl start fails on Windows
The error message is "could not open PID file".
I can manually create the file "postmaster.pid", so the problem
Does not look like a permission problem.
Thanks
Danny
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
are you using the same username that you use to start postgres???
M--
----- Original Message -----
From: "Abraham, Danny" <danny_abraham@bmc.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, December 24, 2007 9:37 AM
Subject: [GENERAL] pg_ctl start fails on Windows
The error message is "could not open PID file".
I can manually create the file "postmaster.pid", so the problem
Does not look like a permission problem.
Thanks
Danny
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
--- On Mon, 12/24/07, Abraham, Danny <danny_abraham@bmc.com> wrote: > I can manually create the file "postmaster.pid", > so the problem > Does not look like a permission problem. I had a similar problem once. For some reason, after I installed a windows service pack update, my Postgresql directorywas altered to be READ-ONLY. Once this happened, postgresql wan't able to start. After spending a quited a bit of time to dicover the cause of the problem, I simply had to reset the directoy to be write-able. I hope this helps. Regards, Richard Broersma Jr.
--- On Mon, 12/24/07, Abraham, Danny <danny_abraham@bmc.com> wrote:
> I can manually create the file "postmaster.pid",
> so the problem
> Does not look like a permission problem.
I had a similar problem once. For some reason, after I installed a windows service pack update, my Postgresql
directorywas altered to be READ-ONLY. Once this happened, postgresql wan't able to start.
After spending a quited a bit of time to dicover the cause of the problem, I simply had to reset the directoy to be
write-able.
I hope this helps.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
are you using the same username that you use to start postgres???
M--
----- Original Message -----
From: "Abraham, Danny" <danny_abraham@bmc.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, December 24, 2007 9:37 AM
Subject: [TLM] [GENERAL] pg_ctl start fails on Windows
The error message is "could not open PID file".
I can manually create the file "postmaster.pid", so the problem
Does not look like a permission problem.
Thanks
Danny
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Could still be a permission problem. Whatever NT account you are using
as the service account (usally called postgres) for the PostgreSQL
server is the one that needs to be able to create the postmaster.pid.
Make sure that account has full rights to the data folder.
Hope that helps,
Regina
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Abraham, Danny
Sent: Monday, December 24, 2007 9:38 AM
To: pgsql-general@postgresql.org
Subject: [TLM] [GENERAL] pg_ctl start fails on Windows
The error message is "could not open PID file".
I can manually create the file "postmaster.pid", so the problem
Does not look like a permission problem.
Thanks
Danny
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings