[TLM] Re: [GENERAL] pg_ctl start fails on Windows

2007-12-27 Thread Martin Gainty
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

2007-12-27 Thread Richard Broersma Jr
--- 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

2007-12-24 Thread Richard Broersma Jr
--- 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

2007-12-24 Thread Martin Gainty
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

2007-12-24 Thread Obe, Regina
 
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

2007-12-24 Thread Abraham, Danny

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