Psql: FATAL: password authentication for user "postgres" WINDOWS

I just installed postgresql 9.0 on my computer.
When it asks for a password during installation, I entered the password.

after installation, I went to the command line to import the SQL file.
I use the psql -f filename.sql . This tells me the password to which I entered the password.

He then complains that the authentication failed for Morne Nel. I am not a user yet.

Then I tried psql -h localhost -U postgres , to which I entered the password. Only to receive this message:
FATAL: Password authentication failed for user "postgres"

What can I do to solve this madness?

# Could it be that the Jasper Reports server can do something about this, also establishes that prostgres doesn't matter?

+5
source share
1 answer

So it seems that Jasper Reports Server was the culprit. Jasper worked on port 5432 and Postgres 9.3 worked on port 5433

I knew that it was installed on port 5433, but I just assumed that if you try to run command line commands so that it uses the correct port.

So, after removing Jasper Reports Server and changing the port number for Posgres 9.3 in the configuration file to 5432, I restarted my computer and it worked.

+2
source

Source: https://habr.com/ru/post/1202745/


All Articles