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;