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
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@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.
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