docker安装postgres

2020-08-06 19:10:00 by wst

database

---

记录下整个过程，具体步骤如下：

 

# 拉取镜像
docker pull postgres

# 创建数据库实例
docker run --name airflow-postgres -e POSTGRES_PASSWORD=donews -d postgres

# 查看数据库
docker exec -it  airflow-postgres psql -U postgres

#　创建用户和数据库
CREATE USER airflow WITH PASSWORD 'airflow123';
CREATE DATABASE airflow OWNER airflow;
GRANT ALL PRIVILEGES ON DATABASE airflow to airflow;

# 再次进入创建表并插入数据
docker exec -it airflow-postgres psql -U airflow -d airflow
CREATE TABLE user_tbl(name VARCHAR(20), signup_date DATE);
INSERT INTO user_tbl(name, signup_date) VALUES('张三', '2013-12-22');
SELECT * FROM user_tbl;

 

如有疑问，欢迎留言！

---