postgres user is not superuser 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:


pgsql 
s6cefdco


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
Try running this,

sudo -u postgres dropdb myDatabase