Re: BUG #15108: Initialization problem postgresql-10-setup initdb

From: alertas <alertas(dot)dba(at)click-it(dot)es>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org, Devrim Gündüz <devrim(at)gunduz(dot)org>, alertas(dot)dba(at)click-it(dot)es
Subject: Re: BUG #15108: Initialization problem postgresql-10-setup initdb
Date: 2018-03-16 07:29:45
Message-ID: b1af0497-7164-0c35-c839-041840836640@click-it.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I don't understand, in the official documentation appear "initdb must be
run as the user that will own the server process, because the server
needs to have access to the files and directories that initdb creates.
*Since the server cannot be run as root, you must not run initdb as root
either*. (It will in fact refuse to do so.)"

Regards,

El 14/03/18 a las 16:59, Devrim Gündüz escribió:
> Hi,
>
> On Tue, 2018-03-13 at 12:12 +0000, PG Bug reporting form wrote:
>> The problem is reported when executing database initialization command,
>> postgresql-10-setup initdb.
>> In the official documentation
>> (https://www.postgresql.org/docs/10/static/app-initdb.html) indicates that
>> it must be executed with the user postgres, but the command only works if I
>> execute it as root.
>>
>> This command does not
> postgresql-10-setup is a wrapper around initdb (which solves many problems),
> *not* the initdb binary, and needs to be run as root. You can always run initdb
> directly with:
>
> /usr/pgsql-10/bin/initdb
>
> Regards,
>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Yavuz TANRIVERDİ 2018-03-16 08:17:46 Re: contrib/start-scripts/freebsd script fails with Ambiguous output redirect.
Previous Message Amit Langote 2018-03-16 05:32:44 Re: Postgres 10.3 delete on partition table cannot execute, out of memory.