Re: initdb failure

Hi Peter,

The link you mention below does not say that Operating System user
postgres, should not have Administrator privileges,
It says user postgres may not have sufficient privileges and could fail
to create the Data directory, in that case, create Data directory by
root user and change ownership to postgres. This is not the case here,
the Data directory does get created and the owner is postgres. It fails
subsequently during initdb though.

Also I have successfully tested the installation on more than half dozen
machines and they are all NTFS file systems.

Thanks
Pankaj

-----Original Message-----
From: Jan-Peter Seifert [mailto:Jan-Peter(dot)Seifert(at)gmx(dot)de]
Sent: Thursday, April 22, 2010 12:45 PM
To: Pankaj Mandal (pmandal)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] initdb failure

Hello Pankaj,

well - obviously initdb wasn't run by (the operating system's user)
postgres. The owner of the server process (normally named postgres)
mustn't have any administrator privileges:

http://www.postgresql.org/docs/8.4/interactive/app-initdb.html

Good luck.

Maybe there wasn't any problem so far because the other PostgreSQL
servers have been installed on non-NTFS file systems?

Good luck,

Peter

Am 12.04.2010 07:25, schrieb Pankaj Mandal (pmandal):

> The scripts are executed by user Administrator on this specific
machine
> which has all the privileges that postgres user has (note postgres
user
> account is also created)
> I also checked that the data directory and it contents are owned by
user
> postgres and user postgres's permissions are inheritable.
>
> Thanks
> Pankaj
>
> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Jan-Peter
Seifert
> Sent: Sunday, April 11, 2010 3:18 PM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] initdb failure
>
> Hello,
>
>> The files belonging to this database system will be owned by
>> user "Administrator".
>> This user must also own the server process.
>
> the user here should be postgres.
> Are you 'locally'/'directly' installing on the server machine?
>
> Good luck.
>
> Peter
>