Date: Mon, 29 Nov 2010 12:23:03 -0800 (PST)
From: 100-eti <100-eti@csc-scc.gc.ca>
To: pgsql-admin@postgresql.org
Message-ID: <1291062183111-3285074.post@n5.nabble.com>
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>
Subject: Re: Postgres service won't start, doesn't log any errors
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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

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