Fernando Perez <[email protected]> writes: > > > So I created the postgres account blog and gave that account the > > ability to create databases and users. > > I guess this assumption is wrong. > > How did you create the "blog" user in postgresql? You probably forgot an > option when creating it.
I was thinking this. I executed: CREATE USER blog WITH PASSWORD 'xxxxyyy'; though I could not figure out any "ALTER USER" commands to give user "blog" create database privileges and so I just executed: update pg_authid set rolcreatedb = 't' where rolname = 'blog'; Can someone suggest the proper commands I should use to create the use "blog"? I am using Postgres 8.1.11. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
