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.
# 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.
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.