Re: pg_dump problem with postgres user

Поиск
Список
Период
Сортировка
От
Тема Re: pg_dump problem with postgres user
Дата
Msg-id 001601d93f26$75663540$60329fc0$@1nar.com.tr
обсуждение исходный текст
Ответ на pg_dump problem with postgres user  (<ertan.kucukoglu@1nar.com.tr>)
Ответы Re: pg_dump problem with postgres user  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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




В списке pgsql-general по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: psql "\d" no longer working
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_dump problem with postgres user