public inbox for [email protected]  

help / color / mirror / Atom feed

 =?Windows-1252?Q?=93FATAL:_role_=93username=94_does_not_exist=94.__Thanks?= =?Windows-1252?Q?.?=
2+ messages / 2 participants
[nested] [flat]

*  =?Windows-1252?Q?=93FATAL:_role_=93username=94_does_not_exist=94.__Thanks?= =?Windows-1252?Q?.?=
@ 2021-07-23 16:06  Matt Russo (mrusso) <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Matt Russo (mrusso) @ 2021-07-23 16:06 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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: [email protected]<mailto:[email protected]> erwin by Quest



[cid:[email protected]]




Attachments:

  [image/jpeg] image001.jpg (168.4K, 3-image001.jpg)
  download | view image

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: “FATAL: role “username” does not exist”. Thanks.
@ 2021-07-24 12:53  Clemens Ladisch <[email protected]>
  parent: Matt Russo (mrusso) <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Clemens Ladisch @ 2021-07-24 12:53 UTC (permalink / raw)
  To: [email protected]

On 23.07.2021 18:06, Matt Russo (mrusso) wrote:
 >     I installed the Postgresql ODBC drivers and when I try to test my
 > connection I get “FATAL: role “postgres” does not exist”.

What does the database's log file show at this time?


Regards,
Clemens






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2021-07-24 12:53 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-07-23 16:06  =?Windows-1252?Q?=93FATAL:_role_=93username=94_does_not_exist=94.__Thanks?= =?Windows-1252?Q?.?= Matt Russo (mrusso) <[email protected]>
2021-07-24 12:53 ` Re: “FATAL: role “username” does not exist”. Thanks. Clemens Ladisch <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox