0

I have created a database with a database user and password using the psql shell. Now, I want to create another additional database using the shell. However, when I enter psql in Windows Command Prompt, I am prompted to enter my password, which I have forgotten. 

$ psql
$ psql: FATAL:  password authentication failed for user "username"

I want to keep my other databases I created 100% in tact and functioning but would like to create another database in addition. What should I do to accomplish this without messing up the other database?

CodeRocks
  • 655
  • 5
  • 10
  • 25
  • Did you know the pass for postgres user? If you know just use that and after that you `alter` the password for user you forgot the pass.. – dwir182 Jan 30 '19 at 03:48
  • Which password you forgot? Password you have provided during installation or the password of the particular user you have created as database owner. – Bidhan Majhi Jan 30 '19 at 05:27
  • I know the password for my database but do not the password for my postgres user – CodeRocks Jan 30 '19 at 14:31

1 Answers1

1

So you want to reset your forgotten password? Check below questions.

Kyle
  • 105
  • 3