PostgreSQL Run on Docker with Create User and Database

1.
docker pull postgres
2

docker run --name postgresdb -v /home/sudipto/Development/PostgresDb:/var/lib/postgresql/data -p 5432:5432 -e POSTGRES_PASSWORD=root -d postgres
3.

 docker inspect postgresdb

4.
docker exec -it postgresdb bash

5.
psql -U postgres -W

6.

CREATE USER user11 SUPERUSER PASSWORD '69use420';
7.
CREATE DATABASE pguser11db1;
8.
GRANT ALL PRIVILEGES ON DATABASE pguser11db1 TO user11; 
 


 


 
 

No comments:

Post a Comment