Postgresql Installation in Linux
sudo apt install postgresql
sudo systemctl is-active postgresql
sudo systemctl is-enabled postgresql
sudo systemctl status postgresql
sudo pg_isready
sudo systemctl restart postgresql
sudo su - postgres
ALTER USER postgres WITH PASSWORD 'root';
psql
CREATE USER fwl_db_user WITH PASSWORD 'securep@wd';
CREATE DATABASE fwl_core_db;
GRANT ALL PRIVILEGES ON DATABASE fwl_core_db to fwl_db_user;
GRANT ALL PRIVILEGES ON DATABASE postgres to fwl_db_user;
CREATE USER postgres WITH PASSWORD 'root';
GRANT ALL PRIVILEGES ON DATABASE fwl_core_db to postgres;
Post Views: 322