Ashis Anand escribió: > Problem Statement: PGUSER has to be set for PSQL to authenticate. If left > unset the connection to database fails with the error mentioned below. > > STEPS: > 1. Install PostgreSQL. > 2. Start psql from start menu > 3. create a role for the user 'foo' through the following statement > CREATE ROLE foo LOGIN CREATEDB CREATEROLE PASSWORD 'bar' > 4. Create a database mydb > CREATE DATABASE mydb WITH OWNER = foo > 5. Open your normal console where pguser is not set > 6. Run: "psql mydb" > 7. Enter the password as 'bar' > > Actual output: > psql: FATAL: password authentication failed for user "foo"
Hmm. Do you have a pgpass.conf file with a conflicting password for user foo? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs