Re: Regarding initdb & pg_ctl

On Sat, Sep 12, 2009 at 05:23, Vikram Patil <vpatil(at)actuate(dot)com> wrote:
> Hello Folks,
>
>
>
>        So I have following problem as I logged in Windows 2003 with
> domain\user. I am basically trying to create installer for postgres. So I
> need to keep in mind that  person who is going to install can be the one who
> is currently logged in.
>
>
>
> So I tried to change permissions on data directory so that initdb will run
> fine. I changed creator owner privileges to be read and execute using XACLS
> then ran initdb. It populated directory correctly  But when I used pg_ctl to
> start up service it failed saying
>
> “FATAL:  XX000: C:/Program Files/PostgreSQL/8.4/bin/postgres.exe: could not
> locate matching postgres executable
>
> , .\src\backend\postmaster\postmaster.c:1070 …”
>
>
>
> Please provide some inputs how to tackle with this permission issues. Thanks
> in advance

When you run pg_ctl, it will drop any privileges that is acquired
through administrator groups. Did you grant the permissions directly
to the postgres user account, and not through something that chains up
to Administrators or Domain Admins? Also, make sure this holds true
for the whole path up there.

If you did, then the next step is to run Process Monitor
(http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx) during
the startup and see exactly which operation it is that fails. It is
probably trying to load a DLL somewhere it doesn't have permissions.

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