From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: Pankaj Mandal (pmandal) <pmandal@cisco.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: initdb failure
Date: Thu, 22 Apr 2010 21:44:54 +0200
Message-ID: <4BD0A736.5030801@gmx.de> (raw)
In-Reply-To: <2873D0DE40695D48B76CDF7C6620A1540A2D58E5@xmb-sjc-226.amer.cisco.com>
References: <2873D0DE40695D48B76CDF7C6620A1540A2D5334@xmb-sjc-226.amer.cisco.com>
<4BBEF2CF020000250003064F@gw.wicourts.gov>
<2873D0DE40695D48B76CDF7C6620A1540A2D5799@xmb-sjc-226.amer.cisco.com>
<4BC24A7D.3020602@gmx.de>
<2873D0DE40695D48B76CDF7C6620A1540A2D58E5@xmb-sjc-226.amer.cisco.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Jan-Peter.Seifert@gmx.de, pmandal@cisco.com
Subject: Re: initdb failure
In-Reply-To: <4BD0A736.5030801@gmx.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox