Re: initdb using option "username" startup log

Thank you for your reply.

I was anything to do as postgres role. but at startup Server that log occur.

I installed postgresql(v 9.2.1) by source file.
And I don't want to use "postgres" role as superlogin user.- For security.

I worry about something is not work.

Is there no problem?

2012/10/31 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> 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
>

--

---------------------------------------------------------