Re: [GENERAL] 10beta1 role - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] 10beta1 role
Date
Msg-id CAMkU=1yyTLp2tuX6VW8CePsD+WBi9NRvGSKaViaejBy7V6drcw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] 10beta1 role  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] 10beta1 role
List pgsql-general
On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 06/22/2017 01:13 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell <stellr@vt.edu <mailto:stellr@vt.edu>> wrote:

    I used "initdb -U" to specify an alternate superuser.  On startup it
    throws these msgs:

    2017-06-22 14:36:34 EDT,0,startup FATAL:  28000: role "postgresql"
    does not exist

    2017-06-22 14:36:34 EDT,0,startup LOCATION: InitializeSessionUserId,
    miscinit.c:503


Earlier versions do the same thing if you start them with the wait option (-w).

The difference is that wait is now the default, and you use -W to turn it off.

The would seem to work for the pg_ctl init[db] mode, however the OP is using the plain initdb where -W is:

-W
--pwprompt

But he is seeing the message when he starts the database, not when he does initdb of it.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] 10beta1 role
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] 10beta1 role