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... stackoverflow.com/questions/21796446/… — mlinth
– mlinth, Commented Nov 2, 2016 at 10:50
is there a way to make postgres take username instead of Username as default? — Saravanabalagi Ramachandran
– Saravanabalagi Ramachandran, Commented Nov 2, 2016 at 11:01

Saravanabalagi Ramachandran · Accepted Answer · 2016-11-02 12:21:14Z

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

PGUSER Environment Variable or create role "Zeke" ... Also look at the User Name Maps

Collectives™ on Stack Overflow

Role "username" not found: PostgreSQL Windows

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related