How to create PostgreSQL database and user
Answered
2
I need to set up a new PostgreSQL database for my Django project.
A
Asked by
ahmed_tech
Platinum
•
151 rep
1 Answer
25
# Login to PostgreSQL
sudo -u postgres psql
# Create database
CREATE DATABASE myproject_db;
# Create user
CREATE USER myproject_user WITH PASSWORD 'secure_password';
# Grant privileges
GRANT ALL PRIVILEGES ON DATABASE myproject_db TO myproject_user;
# For Django
ALTER ROLE myproject_user SET client_encoding TO 'utf8';
ALTER ROLE myproject_user SET default_transaction_isolation TO 'read committed';
ALTER ROLE myproject_user SET timezone TO 'UTC';
\q
P
Platinum
•
447 rep
Your Answer
You need to be logged in to answer questions.
Log In to Answer