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?
source share