I am a newbie to the postgres,when I use the psql to connect to the postgres,a error message printed:
These command list like this:
psql -U postgres
Password for user postgres:postgres
postgreSQL: password authentication failed for user "postgres"
How to solve this problem?
Thanks in advance!
The password you type should not be showing up as you type it, which is what you appear to be showing above. Also, 'postgres' is a horrible password, you might as well configure 'trust' authentication if you are going to use that as a password.
Look in the db server's log file for a (possibly) more detailed error message.
