Solutions if we've forgot our nfldb password...?

[kennysushi]

I had nfldb all set up and running smoothly last season. Over the offseason I believe I had to reinstall python/spyder so I had to reset my config file and thus erased my password to access nfldb or postgres. I cannot remember what it was.

I tried to create a new user with a new password via:

C:\Program Files\PostgreSQL\9.5\bin>createuser.exe -U postgres -E -P nfldb

but it still returned:

Enter password for new role:
Enter it again:
Password:
createuser: could not connect to database postgres: FATAL: password authentication failed for user "postgres"

anyone have an idea on if there's an easy solution for this (ie creating a new user) or do I have to do a full reinstall of the database?

Thank you!