osx - Postgres : Change current user to root -

-

complete database newbie here. installed postgres on laptop run local apps , stuff. fact postgres setup using myname instead of root quite hinderance. way cant replace root?

i open psql this:

psql -h localhost

myname=# \l                                          list of databases      name     |    owner     | encoding |   collate   |    ctype    |       access privileges --------------+--------------+----------+-------------+-------------+-------------------------------  myname       | myname | utf8     | en_us.utf-8 | en_us.utf-8 |  pixelmanager | myname | utf8     | en_us.utf-8 | en_us.utf-8 |  postgres     | myname | utf8     | en_us.utf-8 | en_us.utf-8 |  template0    | myname | utf8     | en_us.utf-8 | en_us.utf-8 | =c/myname              +               |        |          |             |             | myname=ctc/myname  template1    | myname | utf8     | en_us.utf-8 | en_us.utf-8 | =c/myname              +               |        |          |             |             | myname=ctc/myname (5 rows)

thanks help

simply set 2 default databases (template1 / template0) user want, , future / new databases created new user.

for e.g. 

alter database template0 owner newname1; alter database template1 owner newname1;

Comments

Post a Comment

Popular posts from this blog

shader - OpenGL Shadow Map -

-
i trying basic shadow map reason doesn't render properly. video of problem i render house using flat shader: int shadowmapwidth = window_size_x * (int)shadow_map_ratio; int shadowmapheight = window_size_y * (int)shadow_map_ratio; // rendering shadow texture. glactivetexture(gl_texture0); call_gl(glbindtexture(gl_texture_2d, shadowtexture)); // bind framebuffer. call_gl(glbindframebuffer(gl_framebuffer, shadowfbo)); //clear call_gl(glclear(gl_depth_buffer_bit)); call_gl(glviewport(0, 0, shadowmapwidth, shadowmapheight)); call_gl(glcolormask(gl_false, gl_false, gl_false, gl_false)); //render stuff flatshader.use(); flatshader["basecolor"] = glm::vec4(1.0f,1.0f,1.0f,1.0f); flatshader["pvm"] = projectionmatrix*pointlight.viewmatrix*cursor.modelmatrix; cursor.draw(); //binds vao , draws // revert scene. call_gl(glbindframebuffer(gl_framebuffer, 0)); call_gl(glcolormask(gl_true, gl_true, gl_true, gl_true)); call_gl(glviewport(0, 0, window_size_x, window_s
Read more

stringtemplate - StringTemplate4 if conditional with length -

-
i need generate following kinds of code stringtemplate4: methodfoo0(connection conn); methodfoo1(connection conn, int arg1); methodfoo2(connection conn, int arg1, int arg2); etc. the "connection conn" part present passing method name , rest of arguments st template. template looks follows: <methodname>(connection conn, <args; separator=", ">); this works produces comma when there no arguments @ (except conn): methodfoo0(connection conn,); to eliminate comma tried using if conditional , length st4 function couldn't work although tried various combos following: <methodname>(connection conn <if (length(fieldsinfind) \> 0)>,<else><endif><fieldsinfind; separator=", ">) ... , others failed parsing-related error ( mismatched input ). in end, gave , resorted passing comma parameter template either "," or empty string "" based on pre-rendering logic. you check p
Read more