Role "username" not found: PostgreSQL Windows

Question

I found the problem here among many other solutions for *nix systems, but I couldn't seem to access psql

Simply throws a fatal error telling that role Username doesn't exist while I have just created the role and can explicitly see that role there in the list

Things were going super smooth with sqlite and now I need to migrate all data from sqlite3 to PostgreSQL and I'm stuck here for hours...! What do I do?

Could it be case sensitivity? The role name "zeke" in postgresql is not the same as "Zeke" - because you gave the command without quoting the name it's all lower case... http://stackoverflow.com/questions/21796446/postgres-case-sensitivity#21798517 — mlinth, Nov 02 '16 at 10:50
is there a way to make `postgres` take _username_ instead of _Username_ as default? — Saravanabalagi Ramachandran, Nov 02 '16 at 11:01

Saravanabalagi Ramachandran · Accepted Answer · 2016-11-02T12:21:14.040

4

Solution 1: Use doublequotes to preserve case: psql -U postgres -c "CREATE ROLE \"Zeke\""

In Windows usernames are usually given as Username but psql command refuses to preserve case! and this is causing the error...

Solution 2: psql -U zeke

~~I still wonder if there exists any solution for taking usernames in windows as lowercase characters!~~ Adding an ENV variable PGUSER helps get rid of -U zeke after every psql cmd

edited Nov 02 '16 at 12:21

answered Nov 02 '16 at 11:03

Saravanabalagi Ramachandran

8,551
11
53
102

1

`PGUSER` [Environment Variable](https://www.postgresql.org/docs/current/static/libpq-envars.html) or `create role "Zeke" ...` Also look at the [User Name Maps](https://www.postgresql.org/docs/current/static/auth-username-maps.html) – Abelisto Nov 02 '16 at 11:56
You missed doublequotes around the role name in my comment. – Abelisto Nov 02 '16 at 12:05
1

yep! it works: `psql -U postgres -c "CREATE ROLE \"Zeke\""` – Saravanabalagi Ramachandran Nov 02 '16 at 12:13

Role "username" not found: PostgreSQL Windows

1 Answers1