Joe, I'm seeing the exact same thing when I do a fresh installation of Postgres 9.0 on either a 2008 installation or a 2003 installation. In both cases I ensure the entire directory structure is owned by postgres and I've even made postgres a member of the local Administrators group with the same result. Have you had any more luck resolving this issue? Thanks in advance, Roger Joe Carr wrote: > > 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@xxxxxxx> > 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@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> > > -- View this message in context: http://postgresql.1045698.n5.nabble.com/Postgres-service-won-t-start-doesn-t-log-any-errors-tp3218164p3285074.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
