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

From Jeff Janes
Subject Re: [GENERAL] 10beta1 role
Date
Msg-id CAMkU=1yhpXhAM=uxNEOAnK08BtHhV07KfJjYE93tNq4VRPC2aA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] 10beta1 role  (Ray Stell <stellr@vt.edu>)
Responses Re: [GENERAL] 10beta1 role  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell <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.

With the wait option in use, when starting up the server pg_ctl keeps trying to connect to the server so once it is running, it can report success. But it doesn't know who to connect as, so it just uses the default.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] 10beta1 role
Next
From: Ray Stell
Date:
Subject: Re: [GENERAL] 10beta1 role