postgreSQL fatal error windows

Question

recently i have installed postgresql 9.4 on my windows 8 machine while installing PostgreSQL though GUI interface it prompt me for password i entered password and then installed process completed afterward. when i go cmd prompt (through administrative right)and type "psql" it prompts me for password ,when i enter the same password i used while installing PostgreSQL i get following error.

C:\Users\saphal>psql
Password:
psql: FATAL:  password authentication failed for user "saphal"

please suggest me.

harald · Accepted Answer · 2015-06-08 07:37:29Z

1

Try:

psql postgres <user_name>

Where postgres is the name of the main database and <user_name> is the user that owns the postgres installation. Usually this will be postgres or psql too, but it they don't work, try your own user name. (I'm not sure this is set up on a Windows system.)

answered Jun 8, 2015 at 7:37

harald

6,1561 gold badge26 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user_0 Over a year ago

Default user is postgres on windows, like in Linux.

Saphal Adhikari Over a year ago

Still i am getting this error message C:\Users\saphal>psql postgres saphal Password for user saphal: psql: FATAL: password authentication failed for user "saphal"

harald Over a year ago

What happens if you try psql postgres postgres?

JGOakley · Accepted Answer · 2016-05-03 14:12:42Z

1

Most likely the installation created a default role called "postgres". Try running the psql command with the username option:

psql -U postgres

Then when asked for the password use the one you specified during the installation.

answered May 3, 2016 at 14:12

JGOakley

851 silver badge6 bronze badges

Collectives™ on Stack Overflow

postgreSQL fatal error windows

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related