I have postgres installed on my macbook using homebrew with the following command:

brew install postgresql@16

after installing it I forgot the password for my user so I decided to uninstall it and install it back again but everytime I do that it still asks me for the password for the same user from the old installation.

I tried:

brew uninstall postgresql@16