From: | "Matt Russo (mrusso)" <Matt(dot)Russo(at)quest(dot)com> |
---|---|
To: | "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org> |
Subject: | “FATAL: role “username” does not exist”. Thanks. |
Date: | 2021-07-23 16:06:31 |
Message-ID: | BLAPR19MB45482B354B8943FA8357D19C99E59@BLAPR19MB4548.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I installed the Postgresql ODBC drivers and when I try to test my connection I get “FATAL: role “postgres” does not exist”.
I am able to connect to PostgreSQL and use it in pgAdmin.
I tried adding a role for the user but PG returns it already exists.
I also added a role of a different user PGADMIN but that gave the same error.
I fully uninstalled PostgreSQL. Deleted the directory postgresql in program files.
Fully uninstalled the ODBC drivers.
I installed PostgreSQL 13.
I installed the 13 ODBC drivers.
I am still getting the same error.
No bugs listed like this on https://www.postgresql.org/list/pgsql-bugs/
Dr. Google suggests a role or username is lacking. So I try adding a role but it says user postgres already exists.
I tried adding a second user. No good trying the second user.
Please let me know your advice.
Best Regards,
Matt
Matt Russo | Enterprise Technical Support Senior Advanced
P: 813-600-3438 E: Matt(dot)Russo(at)Quest(dot)com<mailto:Matt(dot)Russo(at)Quest(dot)com> erwin by Quest
[cid:image001(dot)jpg(at)01D77FBB(dot)2D11C470]
From | Date | Subject | |
---|---|---|---|
Next Message | Clemens Ladisch | 2021-07-24 12:53:01 | Re: “FATAL: role “username” does not exist”. Thanks. |
Previous Message | Lawrence, Mike(SDST) | 2021-07-22 14:43:52 | psqlODBC Unicode(x64) driver treats a boolean field as text |