11 Security

PDF page 50

3.9.1 Default Role

Pg_signal_backend role is created in default. This role allow the transmission of the signal to the backend processes.

3.9.2 Namespace

Role (user) names that begin with pg_ are no longer able to use because those are reserved.

postgres=# CREATE ROLE pg_test1 ;
ERROR:  role name "pg_test1" is reserved
DETAIL:  Role names starting with "pg_" are reserved.
$ initdb --username=pg_admin data
initdb: superuser name "pg_admin" is disallowed; role names cannot begin
with "pg_"
$