Dae-man Yang <yangsc...@gmail.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs