Postgres安装文档

1

docker volume create --driver local postgres-data

1
2
3
4
5
6
7
8

docker run -d --name postgres \
-p 5432:5432 \
-e POSTGRES_USER=test \
-e POSTGRES_PASSWORD=password \
-e POSTGRES_DB=test \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-v postgres-data:/var/lib/postgresql/data \
postgres:16.2

1

docker exec -it postgres psql -h 127.0.0.1 -p 5432 -U test -W password -d test

1
2
3
4
5

CREATE USER docker;
CREATE DATABASE docker;
GRANT ALL PRIVILEGES ON DATABASE docker TO docker;
grant dba to pdbadmin;
exit;

1

docker exec -it postgres psql -h 127.0.0.1 -p 5432 -U docker -d docker