Re: Regarding initdb & pg_ctl - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Regarding initdb & pg_ctl
Date
Msg-id 9837222c0909150119x317fe90elb5feab97da829b6d@mail.gmail.com
Whole thread Raw
In response to Re: Regarding initdb & pg_ctl  ("Vikram Patil" <vpatil@actuate.com>)
Responses Re: Regarding initdb & pg_ctl  (Inigo Barandiaran <ibarandiaran@vicomtech.org>)
Re: Regarding initdb & pg_ctl  ("Vikram Patil" <vpatil@actuate.com>)
List pgsql-general
On Tue, Sep 15, 2009 at 03:55, Vikram Patil <vpatil@actuate.com> wrote:
> Thanks Magnus for help.
>
> Is there any way to start pg_ctl without creating postgres user? I am trying to use same logged in user to run initdb
andstart service. As per documentation it seems to be allowed after 8.3. We tried to use it the way I describe on
WindowsXP and it worked without any problem. 

Certainly, that works fine.


> Our installer first copies compiled binaries and then try to run initdb as current user. If it worked then we
registerservice with same user and password. Users are defined in Active directory on active directory server
,basicallywe are using domain\user format to log in and run installation. 
> Once registration is finished, we need to start service.

That's a pretty standard thing, it pretty much works.


> I tried to run initdb with data directory path outside Program Files .It works fine But when data directory path is
locatedinside program files, initdb fails. 

That should work. Another possibility is that it breaks because you
have spaces in the path name, and are not quoting it properly. The
quoting rules on Windows can be very strange :-)



> As per your advice I tried process monitor, it shows that there are no failures. So we can assume it is a issue with
permissions.

Can you see it opening postgres.exe? Or do you get a not foud error somewhere?


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: syntax troubles using "deferrable initially deferred"
Next
From: el dorado
Date:
Subject: Problems with pg_dump for PG8.4 for WinXP (MinGW build)