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
Makes initdb prompt for a password to give the database superuser.
If you don't plan on using password authentication, this is not
important. Otherwise you won't be able to use password authentication
until you have a password set up.
Would that still work?
>
> 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
--
Adrian Klaver
adrian.klaver@aklaver.com