CODEWITHSUNDEEP
postgresql
van
van

Reputation: 9449

Postgres user create database

I am unable to create databases using my postgres client with the user I log in as.

I am having trouble figuring out how increase the privileges of my user. I have access to the linux server running postgres and am able to use psql to log on as my user and as the postgres user.

Can someone tell me what commands I should run to allow my user to create databases on my server through the postgres GUI running on a remote host?

Many thanks,

Upvotes: 36

Views: 26141

Answers (1)

bos
bos

Reputation: 6535

I don´t know of a postgres GUI, but here's how to do it in the psql-console (logged in as the superuser):

=> ALTER USER your_username CREATEDB;

See http://www.postgresql.org/docs/current/interactive/sql-alteruser.html for more info.

Upvotes: 72

Related Questions