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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
