Re: 10beta1 role

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Ray Stell <stellr(at)vt(dot)edu>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 10beta1 role
Date: 2017-06-22 20:13:03
Message-ID: CAMkU=1yhpXhAM=uxNEOAnK08BtHhV07KfJjYE93tNq4VRPC2aA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell <stellr(at)vt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray Stell 2017-06-22 20:16:04 Re: 10beta1 role
Previous Message Melvin Davidson 2017-06-22 20:10:49 Re: 10beta1 role