Sudipta K Paik on .NET

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:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search in Blog

Code Link

  • ►  2017 (3)
    • ►  July 2 (1)
    • ►  June 4 (1)
    • ►  January 29 (1)
  • ▼  2016 (3)
    • ▼  November 13 (1)
      • PostgreSQL Run on Docker with Create User and Data...
    • ►  June 12 (1)
    • ►  March 13 (1)
  • ►  2015 (2)
    • ►  December 27 (1)
    • ►  July 26 (1)
  • ►  2014 (9)
    • ►  November 16 (1)
    • ►  November 2 (1)
    • ►  September 21 (1)
    • ►  August 17 (1)
    • ►  July 13 (1)
    • ►  July 6 (2)
    • ►  May 11 (1)
    • ►  May 4 (1)
  • ►  2012 (12)
    • ►  April 15 (1)
    • ►  April 8 (2)
    • ►  April 1 (2)
    • ►  March 25 (4)
    • ►  March 18 (1)
    • ►  March 11 (1)
    • ►  January 15 (1)
  • ►  2010 (7)
    • ►  November 21 (2)
    • ►  October 3 (1)
    • ►  September 19 (1)
    • ►  September 5 (1)
    • ►  August 8 (1)
    • ►  April 25 (1)
  • ►  2008 (10)
    • ►  February 24 (10)
© Sudipta K Paik. Picture Window theme. Powered by Blogger.