Re: pg_dump problem with postgres user - Mailing list pgsql-general

Hello,

My service provider spam filter just blocked your message and so I send a
separate one.

Your suspicion seems like correct. Postgres user is no more a superuser.
Seems like they added postgresql_user and made it superuser.

I thought I only allow access with certificate to the database.
OS access is limited to single IP. Probably this is the weak point.
I should read more about security in general.

postgres=> \du+
                                        List of roles
    Role name    |                   Attributes                    | Member
of | Description
-----------------+-------------------------------------------------+--------
---+-------------
postgres        | Create role, Create DB, Replication, Bypass RLS | {}
|
 postgresql_user | Superuser                                       | {}
|

postgres=>

Is it possible to put everything back to normal?
Can I use single user mode to change passwords and permissions?

Thanks & Regards,
Ertan