forked from vitabaks/postgresql_cluster
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Debian.yml
202 lines (183 loc) · 10.2 KB
/
Debian.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
---
# PostgreSQL variables
postgresql_cluster_name: "main"
# You can specify custom data dir path. Example: "/pgdata/{{ postgresql_version }}/main"
postgresql_data_dir: "/var/lib/postgresql/{{ postgresql_version }}/{{ postgresql_cluster_name }}"
# You can specify custom WAL dir path. Example: "/pgwal/{{ postgresql_version }}/pg_wal"
postgresql_wal_dir: "" # if defined, symlink will be created [optional]
postgresql_conf_dir: "/etc/postgresql/{{ postgresql_version }}/{{ postgresql_cluster_name }}"
postgresql_bin_dir: "/usr/lib/postgresql/{{ postgresql_version }}/bin"
postgresql_log_dir: "/var/log/postgresql"
postgresql_unix_socket_dir: "/var/run/postgresql"
postgresql_home_dir: "/var/lib/postgresql"
# stats_temp_directory (mount the statistics directory in tmpfs)
# if postgresql_version < 15
postgresql_stats_temp_directory_path: "/var/lib/pgsql_stats_tmp" # or 'none'
postgresql_stats_temp_directory_size: "1024m"
# Repository
apt_repository_keys:
- key: "https://www.postgresql.org/media/keys/ACCC4CF8.asc" # postgresql repository apt key
apt_repository:
- repo: "deb https://apt.postgresql.org/pub/repos/apt/ {{ ansible_distribution_release }}-pgdg main" # postgresql apt repository
# - repo: "deb https://deb.debian.org/debian/ {{ ansible_distribution_release }} main" # debian repo (optional)
# - repo: "deb https://deb.debian.org/debian/ {{ ansible_distribution_release }}-updates main" # debian repo (optional)
# - repo: "deb https://security.debian.org/debian-security/ {{ ansible_distribution_release }}/updates main" # debian repo (optional)
# Packages (for apt repo)
os_specific_packages:
Debian-10: [python, python-dev, python-psycopg2, python-setuptools]
Debian-11: [python3] # python 2 is not required
Debian-12: [python3] # python 2 is not required
Ubuntu-20: [python3] # python 2 is not required
Ubuntu-22: [python3] # python 2 is not required
system_packages:
- "{{ os_specific_packages[ansible_distribution ~ '-' ~ ansible_distribution_major_version] }}"
- python3
- python3-dev
- python3-psycopg2
- python3-setuptools
- python3-pip
- curl
- less
- sudo
- vim
- gcc
- jq
- iptables
- acl
- dnsutils
postgresql_packages:
- postgresql-{{ postgresql_version }}
- postgresql-client-{{ postgresql_version }}
- postgresql-contrib-{{ postgresql_version }}
- postgresql-server-dev-{{ postgresql_version }}
# - postgresql-{{ postgresql_version }}-dbgsym
# - postgresql-{{ postgresql_version }}-repack
# - postgresql-{{ postgresql_version }}-cron
# - postgresql-{{ postgresql_version }}-pg-stat-kcache
# - postgresql-{{ postgresql_version }}-pg-wait-sampling
# - postgresql-{{ postgresql_version }}-postgis-3
# - postgresql-{{ postgresql_version }}-pgrouting
# - postgresql-{{ postgresql_version }}-pgvector
# - postgresql-{{ postgresql_version }}-pgaudit
# Extra packages
etcd_package_repo: "https://github.com/etcd-io/etcd/releases/download/v{{ etcd_version }}/etcd-v{{ etcd_version }}-linux-amd64.tar.gz"
vip_manager_package_repo:
"https://github.com/cybertec-postgresql/vip-manager/releases/download/v{{ vip_manager_version }}/vip-manager_{{ vip_manager_version }}_Linux_x86_64.deb"
# (if with_haproxy_load_balancing: true)
haproxy_installation_method: "deb" # (default)"deb" or "src"
haproxy_install_repo: true # or 'false'
# for Debian 10 the haproxy version 1.8 (LTS) will be installed from the haproxy.debian.net repository.
# you can preload the haproxy deb packages to your APT repository (in this case specify "haproxy_install_repo: false").
confd_package_repo: "https://github.com/kelseyhightower/confd/releases/download/v0.16.0/confd-0.16.0-linux-amd64"
# (optional) if haproxy_installation_method: 'src'
haproxy_major: "1.8"
haproxy_version: "1.8.25" # version to build from source
lua_src_repo: "https://www.lua.org/ftp/lua-5.3.5.tar.gz" # required for build haproxy
haproxy_src_repo: "https://www.haproxy.org/download/{{ haproxy_major }}/src/haproxy-{{ haproxy_version }}.tar.gz"
haproxy_compile_requirements:
- unzip
- gzip
- make
- gcc
- build-essential
- libc6-dev
- libpcre3-dev
- liblua5.3-dev
- libreadline-dev
- zlib1g-dev
- libsystemd-dev
- ca-certificates
- libssl-dev
# You can also use your own repository for extra packages. You need to preload all the packages and change this URLs.
installation_method: "repo" # (default)"repo" or "file"
# Patroni package will be installed from the pip (by default).
# You also have the option of choosing an patroni installation method using the deb package.
patroni_installation_method: "pip" # (default)"pip" or "deb"
# if patroni_installation_method: "deb"
patroni_packages:
- patroni
# (if patroni_installation_type: "pip")
# Packages from your repository will be used to install instead of the pip repository.
pip_package_repo: "https://bootstrap.pypa.io/get-pip.py" # latest version pip3 for python3 (or use "pip-<version>.tar.gz").
patroni_pip_requirements_repo: []
# - "http://my-repo.url/setuptools-41.2.0.zip"
# - "http://my-repo.url/setuptools_scm-3.3.3.tar.gz"
# - "http://my-repo.url/urllib3-1.24.3.tar.gz"
# - "http://my-repo.url/boto-2.49.0.tar.gz" # (interfaces to Amazon Web Services)
# - "http://my-repo.url/PyYAML-5.1.2.tar.gz"
# - "http://my-repo.url/chardet-3.0.4.tar.gz"
# - "http://my-repo.url/idna-2.8.tar.gz"
# - "http://my-repo.url/certifi-2019.9.11.tar.gz"
# - "http://my-repo.url/requests-2.22.0.tar.gz"
# - "http://my-repo.url/six-1.12.0.tar.gz"
# - "http://my-repo.url/kazoo-2.6.1.tar.gz"
# - "http://my-repo.url/dnspython-1.16.0.zip"
# - "http://my-repo.url/python-etcd-0.4.5.tar.gz"
# - "http://my-repo.url/Click-7.0.tar.gz"
# - "http://my-repo.url/prettytable-0.7.2.tar.gz"
# - "http://my-repo.url/pytz-2019.2.tar.gz"
# - "http://my-repo.url/tzlocal-2.0.0.tar.gz"
# - "http://my-repo.url/wheel-0.33.6.tar.gz"
# - "http://my-repo.url/python-dateutil-2.8.0.tar.gz"
# - "http://my-repo.url/psutil-5.6.3.tar.gz"
# - "http://my-repo.url/cdiff-1.0.tar.gz"
patroni_pip_package_repo: []
# - "http://my-repo.url/patroni-1.6.0.tar.gz"
# ( if patroni_installation_type: "deb" )
# You can preload the patroni deb package to your APT repository, or explicitly specify the path to the package in this variable:
patroni_deb_package_repo: []
# - "https://apt.postgresql.org/pub/repos/apt/pool/main/p/patroni/patroni_2.1.4-2.pgdg22.04%2B1_all.deb" # (package for Ubuntu 22.04)
# ================================================================================================= #
# (optional) if installation_method: "file"
# You can also download the necessary packages into postgresql_cluster/files/ directory.
# Packages from this directory will be used for installation.
pip_package_file: "pip-19.2.3.tar.gz" # https://pypi.org/project/pip/#files
patroni_pip_requirements_file:
- "setuptools-41.2.0.zip" # https://pypi.org/project/setuptools/#files
- "setuptools_scm-3.3.3.tar.gz" # https://pypi.org/project/setuptools-scm/#files
- "urllib3-1.24.3.tar.gz" # https://pypi.org/project/urllib3/1.24.3/#files
- "boto-2.49.0.tar.gz" # https://pypi.org/project/boto/#files # (interfaces to Amazon Web Services)
- "PyYAML-5.1.2.tar.gz" # https://pypi.org/project/PyYAML/#files
- "chardet-3.0.4.tar.gz" # https://pypi.org/project/chardet/#files # (required for "requests")
- "idna-2.8.tar.gz" # https://pypi.org/project/idna/#files # (required for "requests")
- "certifi-2019.9.11.tar.gz" # https://pypi.org/project/certifi/#files # (required for "requests")
- "requests-2.22.0.tar.gz" # https://pypi.org/project/requests/#files
- "six-1.12.0.tar.gz" # https://pypi.org/project/six/#files
- "kazoo-2.6.1.tar.gz" # https://pypi.org/project/kazoo/#files
- "dnspython-1.16.0.zip" # https://pypi.org/project/dnspython/#files # (required for "python-etcd")
- "python-etcd-0.4.5.tar.gz" # https://pypi.org/project/python-etcd/#files
- "Click-7.0.tar.gz" # https://pypi.org/project/click/#files
- "prettytable-0.7.2.tar.gz" # https://pypi.org/project/PrettyTable/#files
- "pytz-2019.2.tar.gz" # https://pypi.org/project/pytz/#files # (required for "tzlocal")
- "tzlocal-2.0.0.tar.gz" # https://pypi.org/project/tzlocal/#files
- "wheel-0.33.6.tar.gz" # https://pypi.org/project/wheel/#files
- "python-dateutil-2.8.0.tar.gz" # https://pypi.org/project/python-dateutil/#files
- "psutil-5.6.3.tar.gz" # https://pypi.org/project/psutil/#files
- "cdiff-1.0.tar.gz" # https://pypi.org/project/cdiff/#files
patroni_pip_package_file:
- "patroni-1.6.0.tar.gz" # https://pypi.org/project/patroni/#files
# ( if installation_method: "file" and patroni_installation_type: "deb")
patroni_deb_package_file: "patroni_2.1.4-2.pgdg22.04+1_all.deb" # (package for Ubuntu 22.04) https://apt.postgresql.org/pub/repos/apt/pool/main/p/patroni/
# additional packages
etcd_package_file: "etcd-v3.3.27-linux-amd64.tar.gz" # https://github.com/etcd-io/etcd/releases
wal_g_package_file: "wal-g.linux-amd64.tar.gz" # https://github.com/wal-g/wal-g/releases
vip_manager_package_file: "vip-manager_1.0.2-1_amd64.deb" # https://github.com/cybertec-postgresql/vip-manager/releases
# (if with_haproxy_load_balancing: true)
haproxy_package_file: []
# - "haproxy_1.8.21-1~bpo9+1_amd64.deb"
confd_package_file: "confd-0.16.0-linux-amd64" # https://github.com/kelseyhightower/confd/releases
# (optional) if haproxy_installation_method: 'src'
lua_src_file: "lua-5.3.5.tar.gz" # https://www.lua.org/ftp/lua-5.3.5.tar.gz (required for build haproxy)
haproxy_src_file: "haproxy-1.8.20.tar.gz" # http://www.haproxy.org/download/1.8/src/
# ------------------------------------------------------------------------------------------------- #
# (optional) Specify additional deb packages if required (for any installation_method)
# this packages will be installed before all other packages.
packages_from_file: []
# - "my-package-name_1_amd64.deb"
# - "my-package-name_2_amd64.deb"
# - ""
# ----------------------------------------------------------------------------------------------------------------------------------
# Attention! If you want to use the installation method "file".
# You need to independently determine all the necessary the dependencies of deb packages for your version of the Linux distribution.
# ----------------------------------------------------------------------------------------------------------------------------------
...