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_ea...@gmx.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
