How to I grant a user account permission to create databases in postgresql?

Question

Title says it all. I cannot figure out how to give a user account the ability to create and drop databases. Is there a way to do this with GRANT ?

Answer 1

It's done with ALTER USER username CREATEDB;

See ALTER USER in the doc.

To drop a database, either you're superuser (which can be granted with ALTER USER too) or you must own the database.

Answer 2

First you have to login as postgres user:

$ sudo -u postgres psql postgres

# \password postgres

Enter new password:

After entering new pasword for postgres user (special kin dof user on PostgreSQL) you ar now logged as postgres and you can grant perrmision to other users. Let's say you have user named user1. To grant him ability to create and drop databases you have to write (as postgre user):

ALTER USER user1 CREATEDB;

Hope this helps...