Re: BUG #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

The following bug has been logged on the website:

Bug reference: 7592
Logged by: Deven
Email address: devenmthaker(at)gmail(dot)com
PostgreSQL version: 9.0.3
Operating system: Windows 2008 R2 WITH SP1 (64 BITS)
Description:

We are installing our application which internally call
postgresql-9.0.3-2-windows_x64.exe to install postgresql under c:\program
files folder. But initialization of datbase failed with log that
user(administrator) does not have enough permission on data folder.
Can anyone help me out to address this issue?

On 10/10/2012 01:07 PM, devenmthaker(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7592
> Logged by: Deven
> Email address: devenmthaker(at)gmail(dot)com
> PostgreSQL version: 9.0.3
> Operating system: Windows 2008 R2 WITH SP1 (64 BITS)
> Description:
>
> We are installing our application which internally call
> postgresql-9.0.3-2-windows_x64.exe to install postgresql under c:\program
> files folder. But initialization of datbase failed with log that
> user(administrator) does not have enough permission on data folder.
> Can anyone help me out to address this issue?

That's odd. Is it only on one computer? Or have you tried it on several
different computers with the same results?

Does the error persist if you run the installer with the same command
line directly, not via your installer?

Can you show the installer log file?

What happens if you use a current installer - at least 9.0.10,
preferably 9.2.1.

--
Craig Ringer

On 10/09/12 10:07 PM, devenmthaker(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7592
> Logged by: Deven
> Email address: devenmthaker(at)gmail(dot)com
> PostgreSQL version: 9.0.3
> Operating system: Windows 2008 R2 WITH SP1 (64 BITS)
> Description:
>
> We are installing our application which internally call
> postgresql-9.0.3-2-windows_x64.exe to install postgresql under c:\program
> files folder. But initialization of datbase failed with log that
> user(administrator) does not have enough permission on data folder.
> Can anyone help me out to address this issue?
>

Is your application installer invoking admin privs via the UAC elevation
thing prior to running the postgres installer? it probably
should. Even if you're logged on as 'Administrator', you're normally
running in a less privileged mode, and you have to get past that
privilege elevation prompt before you can write to Program Files,
install services, and other such similar activities.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

Thanks craig,
Since we got response from other community guys that i have to upgrade to
9.0.10 to resolve this issue. Since many permission related issues have
been fixed till this release. So planning to upgrade to 9.0.10.

Regards
Deven

On Sun, Oct 14, 2012 at 11:19 AM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>wrote:

> On 10/10/2012 01:07 PM, devenmthaker(at)gmail(dot)com wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 7592
>> Logged by: Deven
>> Email address: devenmthaker(at)gmail(dot)com
>> PostgreSQL version: 9.0.3
>> Operating system: Windows 2008 R2 WITH SP1 (64 BITS)
>> Description:
>>
>> We are installing our application which internally call
>> postgresql-9.0.3-2-windows_**x64.exe to install postgresql under
>> c:\program
>> files folder. But initialization of datbase failed with log that
>> user(administrator) does not have enough permission on data folder.
>> Can anyone help me out to address this issue?
>>
>
> That's odd. Is it only on one computer? Or have you tried it on several
> different computers with the same results?
>
> Does the error persist if you run the installer with the same command line
> directly, not via your installer?
>
> Can you show the installer log file?
>
> What happens if you use a current installer - at least 9.0.10, preferably
> 9.2.1.
>
> --
> Craig Ringer
>