Posgresql has no role with superuser how to create a

Question

Posgresql has no role with superuser how to create a

Asked 6 years, 10 months ago

Viewed 1,204 times

0

When I went to check in postgresql has no superuser as I do to change or create a superuser

https://stackoverflow.com/questions/10757431/postgres-upgrade-a-user-to-be-a-superuser

– alxwca

2018/01/12 at 15:50

1 answer

Browser other questions tagged postgresql pgadmin

You are not signed in. Login or sign up in order to post.

by alxwca • **843** points · Answer 1 · 2018-01-12T15:57:46+00:00

3

Create user:

CREATE USER myuser;
CREATE USER myuser WITH PASSWORD ‘mypassword‘;

reference: https://www.postgresql.org/docs/10/static/app-createuser.html

To Change:

  ALTER USER myuser WITH SUPERUSER;

reference: https://stackoverflow.com/a/10757486/7920143

Via Pgadmin Youtube link below:

video: https://youtu.be/niAYrTLGFvk

Also add there how it really assigns privileges to the user: grant all privileges on database dbname to dbuser;

– Guilherme IA

2018/01/12 at 16:26
When I try to change the following message appears. ERROR: must be super-user to create super-users **********Error *********** ERROR: must be super-user to create super-users SQL state: 42501

– Daniel Alencar Souza

2018/01/12 at 18:30
As you are trying to use the command; Exists in the bank a Wizard calling postgres, you have to log in with it; In both psql and Pgadminiii or 4; if the postgres user has no password you will have to open psql and type ALTER USER postgres WITH PASSWORD 'postgres'; you log in with it and change your user’s password without problems! On Youtube video there’s teaching.

– alxwca

2018/01/12 at 18:53
CREATE ROLE pgsql with password '@123' superuser createdb createrole Replication;

– Daniel Alencar Souza

2018/01/12 at 18:56
Not even the user postgres as superuser

– Daniel Alencar Souza

2018/01/12 at 18:57
It can’t be by default it’s super: postgres | Super-user, Create role, Create BD, Replication, Ignore RLS | {}

– alxwca

2018/01/12 at 18:59
Access psql and type du and ask the question

– alxwca

2018/01/12 at 19:00
List of roles Role name | Attributes | Member of -----------------+____+---------- autosystem | | {} distro | | {} postgres | Create role, Create BD, Replicaþòo | {} pqsql | Super-user, You cannot login | {}

– Daniel Alencar Souza

2018/01/12 at 19:07
The user exists you ta using that OS?

– alxwca

2018/01/12 at 19:08
The command you have to type is just this ALTER USER postgres WITH PASSWORD 'postgres' And make your connection with postgres user and create as many users as you want. There in pgadmin3 Voce can connect after creating a password.

– alxwca

2018/01/12 at 19:14
this with windows 7, there can log in to pgadmin as the user but can not create any user with superuser permissions

– Daniel Alencar Souza

2018/01/12 at 19:16
@Danielalencarsouza open Pgadmin3 create a connection with the user postgres as you showed he has permission; then go Login Roles Right click(menu button) Create New Login Role, navigate the tabs, scroll the name of the user, password, under "Role Previlege" Mark superuser the rule you want;

– alxwca

2018/01/12 at 19:23
The user Postgres is without the permission of superuser found a superuser pqsql but is not allowed to log in. I checked with postgres and I checked the script "alter user pqsql login"; but it says that it does not have superuser permission to change

– Daniel Alencar Souza

2018/01/12 at 20:07
One thing is the user postgres in the OS, another in the comic. If you are logged in with the postgres user in windows open cmd as admin, psql -d postgres -U postgres psql ALTER USER postgres with PASSWORD 'my_password'; q

– alxwca

2018/01/15 at 11:38

Show 9 more comments