On 06/22/2017 01:13 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell <stellr@xxxxxx
<mailto:stellr@xxxxxx>> 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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
