Re: initdb using option "username" startup log

Dae-man Yang <yangsclub(at)gmail(dot)com> writes:
> I initdb like below
> "initdb --pgdata=/pg_data --encoding='utf8' --locale='C' --lc-collate='C'
> --lc-ctype='C' --username=sys --pwprompt"

OK. The --username switch specifies the name of the initial database
superuser. Instead of "postgres", it's going to be "sys".

> When startup database server.
> Server wirte log like this
> -----------------------------
> LOG: database system was shut down at 2012-10-31 12:00:14 KST
> LOG: database system is ready to accept connections
> LOG: autovacuum launcher started
> FATAL: role "postgres" does not exist
> -----------------------------

> *What is it ? : FATAL: role "postgres" does not exist*

That would be the trace of something trying to connect as user
"postgres", which doesn't exist because you told initdb to create "sys"
instead. The database is up and running, but you'll only be able to
connect to it by specifying the username "sys" (at least until you make
some more database roles).

regards, tom lane