postgres new user

Question

How can i create new Superuser in postgres in par with postgres default user?I want this new user to have its own psw that i can use to access the database created

KFSys · Answer

Heya, To create a new superuser, use the CREATE USER command along with SUPERUSER and LOGIN options, and set the password for the new user. Replace new_username with the desired username and your_password with the password you want for this new user: CREATE USER new_username WITH SUPERUSER LOGIN PASSWORD 'your_password'; Grant privileges to the new user : This step isn’t always necessary because the SUPERUSER role already provides full privileges, but you can explicitly grant all privileges to the new user on a specific database if needed: GRANT ALL PRIVILEGES ON DATABASE your_database TO new_username; Exit PostgreSQL : Once the user has been created, exit the PostgreSQL prompt. Now you can try logging in with the new superuser account by running the following command: psql -U new_username -d your_database -W You’ll be prompted to enter the password for new_username to access the database. This will create a new superuser with the specified password, allowing you to access the database using this new user.

alexdo · Answer

Heya, @charmeem You can create the superuser using CREATE ROLE CREATE ROLE new_username WITH SUPERUSER CREATEDB CREATEROLE LOGIN PASSWORD 'your_password'; You can manage privileges efficiently by creating a group role: Create a group role: CREATE ROLE admin_group WITH SUPERUSER CREATEDB CREATEROLE NOLOGIN; Assign your new user to the group: GRANT admin_group TO new_username; This setup makes it easier to manage superuser-like privileges for multiple users. Also assign superuser privileges only if absolutely necessary. For less sensitive tasks, consider roles with specific privileges instead. Hope that this helps!

Bobby · Answer

Hi there, In addition to what has already been mentioned, if you are using a managed Postgres cluster, you can follow the steps on how to do that here: https://docs.digitalocean.com/products/databases/postgresql/how-to/manage-users-and-databases/ - Bobby

Become a contributor for community

DigitalOcean Documentation

Resources for startups and AI-native businesses

The developer cloud

Start building today

Report this

postgres new user

Related questions

Should I use a Managed Database or run PostgreSQL on a Droplet?

Should I use Managed PostgreSQL or just run Postgres on my Droplet?

App Platform - update DB pool without detach

Upgrading to postgres 18 with postgis installed

Postgres 18 availability?

How to create a schema in a Dev Database?

When can we expect Postgres 15.14 Managed Database support to be available?

Postgres - Database extension pg_stat_statement is activ but table doesn't exists

How do I automatically back up a DigitalOcean Managed PostgreSQL database to Spaces?

Trying to connect to postgresql on droplet programmatically via python and pg8000/psycopg2

Further PostgreSQL Extension Support Roadmap

installing pgadminj4 web version ubuntu nginx

Report this

postgres new user

Related questions

Should I use a Managed Database or run PostgreSQL on a Droplet?

Should I use Managed PostgreSQL or just run Postgres on my Droplet?

App Platform - update DB pool without detach

Upgrading to postgres 18 with postgis installed

Postgres 18 availability?

How to create a schema in a Dev Database?

When can we expect Postgres 15.14 Managed Database support to be available?

Postgres - Database extension pg_stat_statement is activ but table doesn't exists

How do I automatically back up a DigitalOcean Managed PostgreSQL database to Spaces?

Trying to connect to postgresql on droplet programmatically via python and pg8000/psycopg2

Further PostgreSQL Extension Support Roadmap

installing pgadminj4 web version ubuntu nginx