PostgreSQL error: Fatal: role "username" does not exist
PostgresqlAuthenticationPostgresql Problem Overview
I'm setting up my PostgreSQL 9.1. I can't do anything with PostgreSQL: can't createdb
, can't createuser
; all operations return the error message
Fatal: role h9uest does not exist
h9uest
is my account name, and I sudo apt-get install
PostgreSQL 9.1 under this account.
Similar error persists for the root
account.
Postgresql Solutions
Solution 1 - Postgresql
Use the operating system user postgres
to create your database - as long as you haven't set up a database role with the necessary privileges that corresponds to your operating system user of the same name (h9uest
in your case):
sudo -u postgres -i
Then try again. Type exit
when done with operating as system user postgres
.
Or execute the single command createuser
as postgres
with sudo
, like demonstrated by drees in another answer.
The point is to use the operating system user matching the database role of the same name to be granted access via ident
authentication. postgres
is the default operating system user to have initialized the database cluster. The manual:
> In order to bootstrap the database system, a freshly initialized
> system always contains one predefined role. This role is always a
> “superuser”, and by default (unless altered when running initdb
) it
> will have the same name as the operating system user that initialized
> the database cluster. Customarily, this role will be named postgres
.
> In order to create more roles you first have to connect as this
> initial role.
I have heard of odd setups with non-standard user names or where the operating system user does not exist. You'd need to adapt your strategy there.
Read about database roles and client authentication in the manual.
Solution 2 - Postgresql
After trying many other people's solutions, and without success, this answer finally helped me.
https://stackoverflow.com/a/16974197/2433309
In short, running
sudo -u postgres createuser owning_user
creates a role with name owning_user (in this case, h9uest). After that you can run rake db:create
from the terminal under whatever account name you set up without having to enter into the Postgres environment.
Solution 3 - Postgresql
sudo su - postgres
psql template1
creating role on pgsql with privilege as "superuser"
CREATE ROLE username superuser;
eg. CREATE ROLE demo superuser;
Then create user
CREATE USER username;
eg. CREATE USER demo;
Assign privilege to user
GRANT ROOT TO username;
And then enable login that user, so you can run e.g.: psql template1
, from normal $
terminal:
ALTER ROLE username WITH LOGIN;
Solution 4 - Postgresql
This works for me:
psql -h localhost -U postgres
Solution 5 - Postgresql
Installing postgres using apt-get
does not create a user role or a database.
To create a superuser role and a database for your personal user account:
sudo -u postgres createuser -s $(whoami); createdb $(whoami)
Solution 6 - Postgresql
psql postgres
postgres=# CREATE ROLE username superuser;
postgres=# ALTER ROLE username WITH LOGIN;
Solution 7 - Postgresql
For version Postgres 9.5 use following comand:
psql -h localhost -U postgres
Hope this will help.
Solution 8 - Postgresql
Working method,
-
vi /etc/postgresql/9.3/main/pg_hba.conf
-
local all postgres peer
here change peer to trust -
restart,
sudo service postgresql restart
-
now try,
psql -U postgres
Solution 9 - Postgresql
For Windows users : psql -U postgres
You should see then the command-line interface to PostgreSQL: postgres=#
Solution 10 - Postgresql
In local user prompt, not root user prompt, type
sudo -u postgres createuser <local username>
Then enter password for local user.
Then enter the previous command that generated "role 'username' does not exist."
Above steps solved the problem for me. If not, please send terminal messages for above steps.
Solution 11 - Postgresql
I installed it on macOS and had to:
cd /Applications/Postgres.app/Contents/Versions/9.5/bin
createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME
Here's the source: https://github.com/PostgresApp/PostgresApp/issues/313#issuecomment-192461641
Solution 12 - Postgresql
I did a healthcheck with docker-compose.
healthcheck:
test: ['CMD-SHELL', 'pg_isready']
interval: 5s
timeout: 5s
retries: 5
If you also have that change the user:
healthcheck:
test: ['CMD-SHELL', 'pg_isready -U postgres'] # <<<---
interval: 5s
timeout: 5s
retries: 5
Solution 13 - Postgresql
Manually creating a DB cluster solved it in my case.
For some reason, when I installed postgres, the "initial DB" wasn't created. Executing initdb
did the trick for me.
This solution is provided in the PostgreSQL Wiki - First steps:
> initdb > > Typically installing postgres to your OS creates an "initial DB" and starts the postgres server daemon running. If not then you'll need to run initdb
Solution 14 - Postgresql
dump and restore with --no-owner --no-privileges
flags
e.g.
dump - pg_dump --no-owner --no-privileges --format=c --dbname=postgres://userpass:username@postgres:5432/schemaname > /tmp/full.dump
restore - pg_restore --no-owner --no-privileges --format=c --dbname=postgres://userpass:username@postgres:5432/schemaname /tmp/full.dump
Solution 15 - Postgresql
for those who using docker and correctly followed the instructions from official doc, if you still met this problem, RESTART windows and try again.
Solution 16 - Postgresql
Follow These Steps and it Will Work For You :
- run
msfconsole
- type db_console
- some information will be shown to you chose the information who tell you to make:
db_connect user:pass@host:port.../database
sorry I don't remember it but it's like this one then replace the user and the password and the host and the database with the information included in thedatabase.yml
in the emplacement:/usr/share/metasploit-framework/config
- you will see. rebuilding the model cache in the background.
- Type apt-get update && apt-get upgrade after the update restart the terminal and lunch msfconsole and it works you can check that by typing in
msfconsole: msf>db_status
you will see that it's connected.
Solution 17 - Postgresql
Follow these steps to get postgres working.
- In your terminal, locate the Application Support folder with the following command. /Users/[name of the user]/library/application support
- Delete the application, Postgres.
- Reinstall the app and it should work just fine.
Solution 18 - Postgresql
Something as simple as changing port from 5432 to 5433 worked for me.