PostgreSQL Create Database
To create a database, run
CREATE DATABASE "DB_NAME_HERE";
Creating user, grant permissions
CREATE USER USER_NAME_HERE WITH PASSWORD 'BAPT788HZutBdV'; 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; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA DB_NAME_HERE TO USER_NAME_HERE; GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA DB_NAME_HERE TO USER_NAME_HERE; GRANT ALL PRIVILEGES ON DATABASE DB_NAME_HERE TO USER_NAME_HERE; psql DB_NAME_HERE -c "GRANT ALL ON ALL TABLES IN SCHEMA public to USER_NAME_HERE;" psql DB_NAME_HERE -c "GRANT ALL ON ALL SEQUENCES IN SCHEMA public to USER_NAME_HERE;" psql DB_NAME_HERE -c "GRANT ALL ON ALL FUNCTIONS IN SCHEMA public to USER_NAME_HERE;"
Creating a User and Database using psql
su - postgres createuser USERNAME_HERE createdb --encoding=UTF8 --owner=USERNAME_HERE DB_NAME_HERE