The forgetations mount, of late. 'course, forgoing a password manager, based on the (il)logic that it would simply strengthen forgetations, is partly how we got here in the first place. So I opened pgAdmin locally after a long (loooong) while. It prompted me for the main password. Found it. Yay! I'm in! Then I clicked the pg instance of interest. Instead of patching me through, pgAdmin prompted me for THAT db's password.
So this is what I ended up having to do to get back in:
pg_hba.conf). In windows-world, that's at C:\Program Files\PostgreSQL<version>\data\pg_hba.conf unless you monkeyed with install paths and on linux... well, it could be anywhere really.
Replace the entries with the following:
# IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
In short, pg is now primed to trust everyone, from anywhere all the time.
Now that you can access the db with no questions asked, change the poxy password:
ALTER USER postgres with password 'never_forget'; -- or whatever ur shiny new password is gonna be
Go dance a jig, you are a forgetotron that has survived one more day.