Create user in PostgreSQL

Method 1

To create user, become user “postgres” with

su - postgres

now run

createuser USER_NAME

Method 2

You can run following commands in psql prompt

CREATE USER USER_NAME_HERE WITH PASSWORD 'PASSWORD_HERE';
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO USER_NAME_HERE;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO USER_NAME_HERE;
GRANT USAGE ON SCHEMA public TO USER_NAME_HERE;

https://www.postgresql.org/docs/8.0/static/sql-createuser.html

PostgreSQL

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *