Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏

第 51 章 PostgreSQL 安装

目录

51.1. netkiller-devops 部署 postgres
51.2. Rocky Linux / Almalinux
51.3. Ubuntu 12.04.1 LTS 安装
51.4. YUM 默认源安装
51.5. PostgreSQL 官方 YUM 源安装
51.5.1. 9.2
51.5.2. 9.3
51.5.3. 9.4
51.5.4. 9.6
51.5.5. PostgreSQL 10
51.6. PostgreSQL 配置
51.6.1. postgresql.conf
51.6.2. pg_hba.conf
51.7. 创建dba用户
51.8. pgbouncer - lightweight connection pooler for PostgreSQL
51.8.1. 安装 pgbouncer
51.8.2. 配置 pgbouncer

51.1. netkiller-devops 部署 postgres

		
volumes = Volumes("postgres")
development.volumes(volumes)

postgres=Services("postgres")
postgres.image("postgres:18.3")
postgres.container_name("postgres")
postgres.environment({"TZ": "Asia/Shanghai",
    "POSTGRES_USER": "postgres",
    "POSTGRES_PASSWORD":"0BDC2BE5FA72",
    "POSTGRES_DB":"postgres",
    "POSTGRES_INITDB_ARGS":"--encoding=UTF-8 --locale=C"
})

# PGDATA: /var/lib/postgresql/data/pgdata
# MAX_CONNECTIONS: "100"
# SHARED_BUFFERS: "512MB"
# EFFECTIVE_CACHE_SIZE: "1536MB"
postgres.ports(["5432:5432"])
postgres.volumes(['postgres:/var/lib/postgresql'])
postgres.healthcheck({
      'test': ["CMD-SHELL", "pg_isready -U postgres"],
      'interval': '5s',
      'timeout': '5s',
      'retries': 5
})
development.services(postgres)		
		
		

创建数据库

		
[root@development ~]# docker exec -it postgres createdb -h 127.0.0.1 -U postgres leenana3		
		
		

修改书库所有者

		
postgres=# ALTER DATABASE leenana1 OWNER TO leenana;
ALTER DATABASE
postgres=# ALTER DATABASE leenana2 OWNER TO leenana;
ALTER DATABASE