[TLM] Re: [GENERAL] pg_ctl start fails on Windows
are you using the same username that you use to start postgres??? M-- - Original Message - From: "Abraham, Danny" <[EMAIL PROTECTED]> To: 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 [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[TLM] Re: [GENERAL] pg_ctl start fails on Windows
--- On Mon, 12/24/07, Abraham, Danny <[EMAIL PROTECTED]> 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 directory was 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/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] pg_ctl start fails on Windows
--- On Mon, 12/24/07, Abraham, Danny <[EMAIL PROTECTED]> 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 directory was 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/
Re: [GENERAL] pg_ctl start fails on Windows
are you using the same username that you use to start postgres??? M-- - Original Message - From: "Abraham, Danny" <[EMAIL PROTECTED]> To: 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 [EMAIL PROTECTED] 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
Re: [GENERAL] pg_ctl start fails on Windows
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
[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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly