On 2014-08-25 17:55:40, Simon Fondrie-Teitler wrote: >> - "sudo -u postgres createuser mediagoblin" does not ask any of the >> questions: >> > Shall the new role be a superuser? (y/n) n >> > Shall the new role be allowed to create databases? (y/n) n >> > Shall the new role be allowed to create more new roles? (y/n) n >> >> but seems to create user ok. So something to that effect probably should >> be in docs: >> "if you're asked the following questions, the correct answers >> are..." > > The README.debian has the following: > Then answer NO to all the questions: > > Shall the new role be a superuser? (y/n) n > > Shall the new role be allowed to create databases? (y/n) n > > Shall the new role be allowed to create more new roles? (y/n) n
Note that you can hardcode those answers on the commandline I believe, with (say) createuser -D -R -S but i believe that with postgres 9.1 and above, that prompt simply disappeared, according to this: http://www.postgresql.org/docs/current/static/app-createuser.html a. -- Si l'image donne l'illusion de savoir C'est que l'adage pretend que pour croire, L'important ne serait que de voir - Lofofora
pgp3bPItb5d7H.pgp
Description: PGP signature