Im having some problems with my postgresql server. In particular, some databases cannot be dropped.
On further inspection, I see that the postgres user is not a SuperUser.
There are two other users that are super users:
However I do have the password for these.
How can I make postgres a SuperUser again?
The operating system is CentOs.
I have tried the following:
sudo -u postgres postgres --single /var/lib/pgsql/9.6/data
Which results in
sudo: postgres: command not found