So this is a definitely a RAVE.
I've been having trouble with postgresql and as I'm a total noob with that (I'm taking a Django course online which uses it).
What I messed up:
I updated my manjaro system as I always do, and in the process I updated postgresql.
BOOM. the database and software versions are out of sync, and I'm getting a whole bunch of cryptic error messages.
So, I just RTFabulousManual and guess what? it's now fixed and working. I've added postgresql to my IgnorePkg list in /etc/pacman.conf and voilà! problem solved.
Anyway, despite days of headaches, the solution was right there the whole time.
Anyway, a huge thank you and kudos to the Arch community at large!