Re: Postgres service won't start, doesn't log any errors

Hi Thomas,
Thanks for your reply. pg_ctrl has given me some more information, but I'm
not quite there yet.

I have verified that the postgres user has "full control" access to the data
directory.

When I take the commandline from the service definition and execute it, I
get the following:

C:\Program Files\PostgreSQL\9.0\bin>"C:/Program
Files/PostgreSQL/9.0/bin/pg_ctl.exe" runservice -N "postgresql-9.0" -D
"C:/Program Files/PostgreSQL/9.0/data" -w

pg_ctl: could not start service "postgresql-9.0": error code 1063

from the forum post (
http://archives.postgresql.org/pgsql-general/2007-05/msg00281.php), the
runservice command alledgedly can only be executed from the service control
manager. So, if I replace "runservice" with "start", the server starts
without issue :

C:\Program Files\PostgreSQL\9.0\bin>"C:/Program
Files/PostgreSQL/9.0/bin/pg_ctl.exe" start -N "postgresql-9.0" -D
"C:/Program Files/PostgreSQL/9.0/data" -w
waiting for server to start.... done
server started

and this will work whether I'm logged in as "postgres" or under my user
account. Additionally, the \data\pg_log directory is being filled with
logging information, indicating (I believe), that permissions are set
correctly.

But, the service will not start from the service control manager, or
pgAdmin3 (which I imagine attempts to start the service in the same manner).

So, I think it's very close at this point. Thanks again beforehand!

On Mon, Oct 18, 2010 at 5:23 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> Joe Carr wrote on 18.10.2010 23:11:
>
> Hello all, I have a windows postgres 9.0.1 installation which doesn't
>> start, and also doesn't log any information. The only evidence that
>> an attempt was made is in the event log with the following pair of
>> messages :
>>
>> 1. Waiting for server startup... 2. Timed out waiting for server
>> startup
>>
>> I've tried to run postgres.exe from the command line to glean more
>> information, but it starts and stops without any output as well.
>>
>
> Did you try using pg_ctl instead (e.g. copy the commandline from the
> service definition)?
>
> In most of the cases it's a permission issue with the data directory. Did
> you verify the postgres user (the one under which the service is started)
> has full access to the data directory?
>
> Regards
> Thomas
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>