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 <[email protected]> > Dae-man Yang <[email protected]> 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 > -- ---------------------------------------------------------
