CODEWITHSUNDEEP
postgresql
ericj
ericj

Reputation: 2291

Can a not-Linux postgresql user create a database?

postgres has created a postgresql user foo,

$ sudo -u postgres createuser -d -P foo
Enter password for new role: foo
Enter it again: foo

Can foo create a database, let us say foo?

Upvotes: 0

Views: 54

Answers (1)

splash
splash

Reputation: 13327

http://www.postgresql.org/docs/current/static/app-createuser.html

-d --createdb The new user will be allowed to create databases.

So as you have used the -d parameter the user foo should have the permission to create databases like this:

createdb -h localhost -U foo foos_db

Upvotes: 2

Related Questions