Postgresapp: After install I get psql: FATAL: role "me" does not exist

[es6Test]

I just done a clean install of postgressApp and the app says connected and started on port 5432. However the terminal gives me something like this:

Last login: Mon Feb 29 22:45:28 on ttys006
'/Applications/Postgres.app/Contents/Versions/9.5/bin'/psql -p5432
➜  ~  '/Applications/Postgres.app/Contents/Versions/9.5/bin'/psql -p5432
psql: FATAL:  role "me" does not exist
➜  ~   

Before installing I removed postgress brew and enterprise psql

[jakob]

By default, psql tries to connect to the PostgreSQL server using the same user name as your system user. So in order to make connecting easier, Postgres.app creates a user with the same name as your system user when it starts the first time.

If you change your system user name, those user names won't match anymore. Then you have to connect using psql --username=OLDUSERNAME, or with psql --username=postgres to connect as the postgres user.

psql also uses your environment variables for configuration. So for troubleshooting, type export in Terminal to make sure there are no settings for PGUSER etc. that override the defaults.

[es6Test]

Hi, and thx, when I do export I get

USER=me

[es6Test]

I'm not sure what to do about the role error.

[jakob]

So I assume your local username is "me". Did you ever change that?

Try the following:
1) quit Postgres.app
2) delete the data directory (~/Library/Application Support/Postgres -- check the docs for details)
3) then start Postgres.app again

Then it should create a new data dir and create a postgres user (role) with the name "me", and it after tht you should be able to connect

[cdonadeo]

Just had the same issue after installing Postgres 9.5.1.0. What I did:

• Stopped my 9.4 installation
• Ensured no Postgres processes were running (ps aux | grep postgres)
• Moved the old 9.4 app to /Applications/Postgres-9.4 (mv /Applications/Postgres /Applications/Postgres-9.4)
• Moved the new 9.5 app to /Applications/Postgres (mv ~/Downloads/Postgres /Applications/Postgres)
• Started the app by double clicking the icon, started with no obvious issues

Result:

➜  ~ /Applications/Postgres.app/Contents/Versions/9.5/bin/psql
psql: FATAL:  role "chrisdonadeo" does not exist
➜  ~ /Applications/Postgres.app/Contents/Versions/9.5/bin/psql -U postgres
psql (9.5.1)
Type "help" for help.

postgres=# SELECT rolname FROM pg_roles;
 rolname
----------
 postgres
(1 row)

It appears that no role with my username was created when the database was initialized. I think I recall that this did happen with 9.4 versions, and the documentation states that you should use your username and a blank password.

[jakob]

Well, first of all you can of course create a new user and corresponding database using the folowing two commands:

createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME

This is what Postgres.app should have done right after initialising the data directory.

So it would be interesting why creating the user failed in the first place -- Postgres.app should show an error if it fails to create the user.

For troubleshooting purposes, could you try the procedure I suggested above (quit Postgres, delete or move data dir, start Postgres again) to see if initialisation works properly? Also, check the log file inside the data dir to see if there's anything that could explain this...

[es6Test]

@jakob, thx but after deleting ~/Library/Application Support/Postgres and restarting I get the same error. And now I did not change "me".

[jakob]

@es6Test
did you get any errors? are you able to connect using psql -U postgres?

Can you try the following command and see what happens?

psql -U postgres -c 'SHOW data_directory;'

Also, is there anything in the log? You can view it using

cat ~/Library/Application\ Support/Postgres/var-9.5/postgres-server.log

(Assuming you are running 9.5 and using the default data dir)

[es6Test]

I had to add this to the path:

export PATH="/Applications/Postgres.app/Contents/Versions/9.5/bin:$PATH"
`➜ ~ psql -U postgres -c 'SHOW data_directory;'

data_directory

/Users/me/Library/Application Support/Postgres/var-9.5
(1 row)`

LOG:  using stale statistics instead of current ones because stats collector is not responding
LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down
LOG:  database system was shut down at 2016-03-05 09:13:16 GMT
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
FATAL:  role "me" does not exist

thx 4 helping!!

[es6Test]

I noticed I have a user call postgres, how can I tell psql to use that instead of 'me'?

[es6Test]

the postgres user is part of group daemon

[es6Test]

I ran psql manually in the terminal by supplying -U postgres

[leehinde]

I was having the same issue and quitting the new install (9.5), deleting the ~/Library/Application Support/Postgres/var-9.5 directory and relaunching fixed it.

[mrsalmanahmad]

These are steps how i solved this issue on Windows

How to setup POSTGRES DB

If you have password error then do this

1. Go to -> C:Program FilesPostgreSQL12data
2. Change files permissions
3. Open file pg_hba.conf and replace mothods with Trust

TYPE DATABASE USER ADDRESS METHOD

IPv4 local connections:

host all all 127.0.0.1/32 trust

IPv6 local connections:

host all all ::1/128 trust

Allow replication connections from localhost, by a user with the

replication privilege.

host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust

---

First of all add path of POSTGRES

Add to Enviroment Path

1. C:Program FilesPostgreSQL12bin
2. C:Program FilesPostgreSQL12lib

Now you can run POSTGRES QURIES through CMD on windows

Open CMD and type

1. psql -U postgres postgres
2. create role salman login; // have all the permission without the passowrd
3. du TO Check existing roles