From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres service won't start, doesn't log any errors
Date: Mon, 29 Nov 2010 23:14:33 +0100
Message-ID: <id18k7$v4$1@dough.gmane.org> (raw)
In-Reply-To: <AANLkTimHMe659jO4Dnxgp+Qt52WO-5-qfU6gXVoOx+KT@mail.gmail.com>
References: <AANLkTi=dhxQof8aVpVPNfJD2Nzn+=0GMp2Yr0J8XUUCC@mail.gmail.com>
<i9idt2$nch$1@dough.gmane.org>
<AANLkTimHMe659jO4Dnxgp+Qt52WO-5-qfU6gXVoOx+KT@mail.gmail.com>
Joe Carr wrote on 19.10.2010 00:55:
> 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
>
> So, if I replace "runservice" with "start", the server starts without issue :
>
> 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!
Are you sure the service is started under the postgres account?
Is the password given there correct?
Regards
Thomas
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: spam_eater@gmx.net
Subject: Re: Postgres service won't start, doesn't log any errors
In-Reply-To: <id18k7$v4$1@dough.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox