From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ray Stell <stellr(at)vt(dot)edu>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 10beta1 role |
Date: | 2017-06-22 20:45:03 |
Message-ID: | e6b0c060-b067-a7dd-a096-da6517a327e7@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-06-22 20:51:44 | Re: 10beta1 role |
Previous Message | Jeff Janes | 2017-06-22 20:43:22 | Re: 10beta1 role |