Linked Questions
26 questions linked to/from psql: FATAL: role "postgres" does not exist
9
votes
3
answers
18k
views
Postgresql: FATAL: role does not exist [duplicate]
I'm setting up Postgresql for use with a Rails app, but I do not seem to be able to connect to, or properly configure, the database (the errors I get after starting the Rails server are: ActiveRecord::...
14
votes
1
answer
4k
views
Unable to mix ecto.create, role 'postgres' does not exist [duplicate]
I tried creating a user called postgres. I reinstalled postgres through brew. I'm able to run it with
postgres -D /usr/local/var/postgres
when I run mix ecto.create, I still get the error:
~/code/...
1461
votes
23
answers
1.3m
views
Which version of PostgreSQL am I running?
I'm in a corporate environment (running Debian Linux) and didn't install it myself. I access the databases using Navicat or phpPgAdmin (if that helps). I also don't have shell access to the server ...
1040
votes
25
answers
700k
views
psql: FATAL: database "<user>" does not exist
I'm using Postgres.app for Mac. I've used it in the past on other machines but it's giving me some trouble when installing on my MacBook. I've installed the application and I ran:
psql -h localhost
...
1111
votes
19
answers
1.5m
views
PostgreSQL error: Fatal: role "username" does not exist
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 ...
96
votes
12
answers
99k
views
Homebrew postgres broken
I installed Postgresql 9.4.0 installed on my Mac (10.10.1/Yosemite) using homebrew. It does not work.
I have created the softlink to /usr/local/opt/postgresql/homebrew.mxcl.postgresql.plist in ~/...
9
votes
2
answers
31k
views
starting postgres server on Mac
I am having this issue third or forth time where after restarting my Mac (Yosemite and same thing with previous OSX version) postgres server doesn't start. I had installed my postgres following this ...
12
votes
2
answers
5k
views
Error when trying to create database - Ecto - Phoenix
I'm getting an error when trying to create a database. I have postgres installed and I've already made a few test projects successfully. And, I've not seen this error. Any help would be great:
ERROR:
...
3
votes
1
answer
5k
views
Trying to load Postgres sample database dvdrental
I'm a newbie and new to Postgresql. I'm following a tutorial online and after downloading and extracting the dvdrental.zip into dvdrental.tar . I changed directory to my postgres bin location. And ...
1
vote
2
answers
6k
views
Postgres: psql: FATAL: role "postgres" does not exist
I have been using PostgreSQL for a couple of days and it has been working fine. I have been using it through both the default postgres database user as well as another user with permissions.
In the ...
2
votes
2
answers
3k
views
role "postgres" does not exist; cannot createuser
I am on Linux Mint Cinnamon 2.2.16.
During the process of getting Rails up and running, I am having problems with Postgres.
postgres@BL ~ $ psql --version
psql (Postgres-XC) 1.1
(based on ...
2
votes
2
answers
2k
views
Connecting to postgres as ubuntu standard user
I want to connect to my postgresql when running my python program. The issue i face is that my username is dave, but i can only access my database with the user postgres on linux. This constellation ...
3
votes
1
answer
2k
views
PostgreSQL + IntelliJ : FATAL : role xxx doesn't exist
I am able to connect with psql and do what I want, not in IntelliJ.
PostgreSQL version : postgres (PostgreSQL) 9.6.1
IntelliJ version : 2016.3.1
IntelliJ configuration :
URL : jdbc:postgresql://...
0
votes
1
answer
808
views
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 ...
1
vote
1
answer
2k
views
What is the postgres user that is setup by the PostgreSQL@15 homebrew formula?
Background
I am new to Postgres and currently going through the documentation as I'm learning to use it. I am having trouble understanding the Postgres user.
I noticed that I can run psql postgres ...