1. su root 2. su postgres 3. psql 4. ALTER ROLE captain WITH SUPERUSER CREATEDB CREATEROLE REPLICATION; 5 \du https://www.digitalocean.com/community/tutorials/how-to-use-roles-and-manage-grant-permissions-in-postgresql-on-a-vps--2

http://www.rackspace.com/knowledge_center/article/postgresql-creating-and-dropping-roles

1. su - postgres 2. psql 3. ALTER ROLE dcms WITH SUPERUSER CREATEDB CREATEROLE REPLICATION; 3. check: \du should be like: Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- dcms | Superuser, Create role, Create DB, Replication | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} 07.01.15

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024