Re: initdb failure - Mailing list pgsql-admin

From Jan-Peter Seifert
Subject Re: initdb failure
Date
Msg-id 4BD0A736.5030801@gmx.de
Whole thread Raw
In response to Re: initdb failure  ("Pankaj Mandal (pmandal)" <pmandal@cisco.com>)
Responses Re: initdb failure  ("Pankaj Mandal (pmandal)" <pmandal@cisco.com>)
List pgsql-admin
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@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jan-Peter Seifert
> Sent: Sunday, April 11, 2010 3:18 PM
> To: pgsql-admin@postgresql.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
>

pgsql-admin by date:

Previous
From: "Josi Perez (3T Systems)"
Date:
Subject: Re: register a service in Windows
Next
From: "Pankaj Mandal (pmandal)"
Date:
Subject: Re: initdb failure