Git Repository

• github
• gitee

Docker Compose

• deploy.yml

  docker-compose --project-name pgsql --file deploy.yml up --detach --remove-orphans
  

Create Extension

CREATE EXTENSION "uuid-ossp";

Conf pg_hba.conf 允许任意地址访问

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    all             all             0.0.0.0/0               md5

User

Create User and set role

CREATE USER <username> WITH PASSWORD '<password>';
alter role <username> superuser;
drop role <username>;