Ben Sandeen
Ben Sandeen

Reputation: 1553

Not allowed do anything in PostgreSQL

I've seen plenty of answers across the internet saying that to combat the

psql:FATAL: role <username> does not exist

one must use the createuser command, but about a dozen different attempts with that command have only yielded a similar error message.

I've installed PostgreSQL using Ubuntu 15.04's sudo apt-get install postgresql, but PostgreSQL permits to do absolutely nothing.

Do I need to install some dependencies or something?

Upvotes: 0

Views: 788

Answers (1)

Sam
Sam

Reputation: 20486

Try doing these actions as the postgres user:

$ sudo -u postgres -i

The PostgreSQL installation makes a postgres user which runs the PostgreSQL service. It is essentially the superuser of your database. In most cases, you don't know the password for this user but any superuser of a system can log in to other accounts.

Upvotes: 4

Related Questions