su - postgres
psql
CREATE ROLE project_username WITH LOGIN PASSWORD 'YourSecretPassword' VALID UNTIL 'infinity';
CREATE DATABASE project_database WITH ENCODING='UTF8' OWNER=project_username CONNECTION LIMIT=-1;
\q
Create PostgreSQL user and database
- April 10, 2019
- 10:38 pm