Lists: | pgsql-novice |
---|
From: | Roman Isitua <romanisitua(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Postgres service refuses to start on windows |
Date: | 2011-06-20 06:39:28 |
Message-ID: | 190532.61882.qm@web125903.mail.ne1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
hello !
I
having an issue with my postgres database installed on a windows xp. For some
reason, I can no longer start the postgres service through pgadmin or the
services window. I get the following error:
Error 1053: The service did not
respond to the start or control request in a timely fashion.
Any ideas
?
Roman.
From: | Michael Swierczek <mike(dot)swierczek(at)gmail(dot)com> |
---|---|
To: | Roman Isitua <romanisitua(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Postgres service refuses to start on windows |
Date: | 2011-06-20 13:08:25 |
Message-ID: | BANLkTi=2DVn98fZW7WkVQ-2Sro1JZ31spg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
On Mon, Jun 20, 2011 at 2:39 AM, Roman Isitua <romanisitua(at)yahoo(dot)com> wrote:
> hello !
>
> I having an issue with my postgres database installed on a windows xp. For
> some reason, I can no longer start the postgres service through pgadmin or
> the services window. I get the following error:
> Error 1053: The service did not respond to the start or control request in
> a timely fashion.
>
> Any ideas ?
>
> Roman.
>
Sometimes the PostgreSQL logs for the current day have useful error
messages. If you did a regular install, they're probably in "C:\Program
Files\PostgreSQL\(your version - probably 8.3, 8.4, or 9.0)\data\pg_log".
You may be able to figure out what is broken from that. If you can't
decipher the message and can't find anything on a web search, post it here
and I'm sure someone will know what is going on. Good luck.
-Mike
From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
---|---|
To: | Roman Isitua <romanisitua(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Postgres service refuses to start on windows |
Date: | 2011-06-20 19:09:16 |
Message-ID: | BANLkTim8DYgPUnWEQzgDJ8++AjvGBxChHQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
On Sun, Jun 19, 2011 at 11:39 PM, Roman Isitua <romanisitua(at)yahoo(dot)com>wrote:
> I having an issue with my postgres database installed on a windows xp. For
> some reason, I can no longer start the postgres service through pgadmin or
> the services window. I get the following error:
> Error 1053: The service did not respond to the start or control request in
> a timely fashion.
>
> Any ideas ?
>
When you attempt to restart, notice any error logs in the pg-log directory.
Any information there will give a clue.
On a related note, I had this experience once with Pg 8.2 and Windows 2K.
For some reason, the Postgres working directory was set to be read-only. I
have no idea how this happened - perhaps it was the anti-virus software or a
rogue admin. But once I reset the directory it worked.
--
Regards,
Richard Broersma Jr.