After some time I’ve logged in in my postgres database and I discovered some strange databases and users I have never create. I try to delete them but i seem not to be superuser, while I’m sure to have assigned the attribute to myself. If I list all roles there is not one superuser.
Have I been hacked? I don’t know, but the serious question is how do I crate an account with superuser privileges in order to solve the problem?
I really really hope that I don’t have to reinstall postgres.
Thanks in advance for any help
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.