postgres new user

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.