Re: [GENERAL] 10beta1 role

On 06/22/2017 01:41 PM, Ray Stell wrote:
>
>
> On 6/22/17 4:36 PM, Adrian Klaver wrote:
>> On 06/22/2017 01:16 PM, Ray Stell wrote:
>>> On 6/22/17 4:07 PM, Adrian Klaver wrote:
>>>
>>>> On 06/22/2017 12:06 PM, Ray Stell wrote:
>>>>> I used "initdb -U" to specify an alternate superuser.  On startup it
>>>>
>>>> Can you show your complete initdb command?
>>>>
>>>>> 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
>>>
>>>   initdb -D /apps/pgsql/workspace/database/test  -U newsuperuser
>>
>> So per Jeff's comments, how are you starting the Postgres instance?
>>
> pg_ctl start -D ...
>
> I added -W to the initdb, but the startup has same msg. same.  As I
> said, the postmaster starts.  I just thought the msgs might not be desired.

Went into the logfile and with:

/usr/local/pgsql10/bin/pg_ctl -D pg100/ -l logfile start

I got:

2017-06-22 13:29:27.706 PDT [12924] LOG:  database system is ready to
accept connections
2017-06-22 13:29:28.476 PDT [12932] FATAL:  role "postgres" does not exist

With:

/usr/local/pgsql10/bin/pg_ctl -W -D pg100/ -l logfile start

I did not get the error.


>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com