Create database, user & allow access - PostgreSQL
Connect to PostgreSQL server instance
sudo -u postgres psql
Create Database
CREATE DATABASE database_name;
Connect to Database
\c database_name;
Create User
CREATE USER user_name WITH PASSWORD 'user_password';
Grant privileges
GRANT ALL PRIVILEGES ON DATABASE "database_name" to user_name;
Delete database
DROP DATABASE IF EXISTS database_name;
Recent Posts
- Automating Release Generation with GitHub Actions
- WP CLI Commands to Bulk Delete Entries in WordPress Database
- Split a Single CSV File into Multiple Files Using the Split Command - Bash
- Migrating code repo from BitBucket to GitHub
- Streamlining Development - Our Journey with Git, Bitbucket, and Jira
Your Questions / Comments
If you found this article interesting, found errors, or just want to discuss about it, please get in touch.