8000 Clear #27 Supabase Postgres 0.13.0 Checklist items · suryatmodulus/postgres@4e792e3 · GitHub
[go: up one dir, main page]
Skip to content

Commit 4e792e3

Browse files
dragarciadragarcia
committed
Clear supabase#27 Supabase Postgres 0.13.0 Checklist items
- supabase#23 Remove readonly role - supabase#24 Add pgjwt extension - supabase#25 Add pgsql-http extension - supabase#26 Add plpgsql_check extension - Add pljava - Add WAL-G - Add daemontools - Set row_security to ON
1 parent f052866 commit 4e792e3

File tree

4 files changed

+193
-35
lines changed

4 files changed

+193
-35
lines changed

‎ansible/playbook.yml

Lines changed: 4 additions & 17 deletions
Original file line numberDiff line numberDiff line change
@@ -11,25 +11,12 @@
1111
- role: anxs.postgresql
1212

1313
tasks:
14-
- import_tasks: tasks/setup-extensions.yml
14+
- name: Install non-Postgres extensions
15+
import_tasks: tasks/setup-misc.yml
1516

16-
- name: Dump SQL script
17-
copy:
18-
dest: /tmp/00-schema.sql
19-
src: ../docker/mnt/00-schema.sql
17+
- name: Install Postgres extensions
18+
import_tasks: tasks/setup-extensions.yml
2019

21-
- name: Set up readonly user for the public schema
22-
become: yes
23-
become_user: postgres
24-
postgresql_query:
25-
db: postgres
26-
path_to_script: /tmp/00-schema.sql
27-
28-
- name: Delete SQL script
29-
file:
30-
path: /tmp/00-schema.sql
31-
state: absent
32-
3320
- name: Adjust APT update intervals
3421
copy:
3522
src: files/apt_periodic

‎ansible/tasks/setup-extensions.yml

Lines changed: 150 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,4 @@
1+
# postgis
12
- name: Install postgis for postgreSQL versions < 10
23
apt:
34
pkg:
@@ -18,6 +19,7 @@
1819
cache_valid_time: 3600
1920
when: postgresql_version >= 10
2021

22+
# pgTAP
2123
- name: pgTAP - download latest release
2224
get_url:
2325
url: "https://github.com/theory/pgtap/archive/v{{ pgtap_release }}.tar.gz"
@@ -37,12 +39,14 @@
3739
target: install
3840
become: yes
3941

42+
# plpython
4043
- name: Install plpython
4144
apt:
4245
pkg: postgresql-plpython3-12
4346
update_cache: yes
4447
cache_valid_time: 3600
4548

49+
# pgAudit
4650
- name: pgAudit - download & install dependencies
4751
apt:
4852
pkg:
@@ -81,6 +85,152 @@
8185
USE_PGXS: 1
8286
become: yes
8387

88+
# pgjwt
89+
- name: pgjwt - download from master branch
90+
git:
91+
repo: https://github.com/michelp/pgjwt.git
92+
dest: /tmp/pgjwt
93+
version: master
94+
95+
- name: pgjwt - install
96+
make:
97+
chdir: /tmp/pgjwt
98+
target: install
99+
become: yes
100+
101+
- name: Remove libcurl4 package
102+
apt:
103+
pkg:
104+
- libcurl4
105+
state: absent
106+
107+
# pgsql-http
108+
- name: pgsql-http - download & install dependencies
109+
apt:
110+
pkg:
111+
- libcurl4-gnutls-dev
112+
update_cache: yes
113+
install_recommends: yes
114+
115+
- name: pgsql-http - download latest release
116+
get_url:
117+
url: "https://github.com/pramsey/pgsql-http/archive/v{{ pgsql_http_release }}.tar.gz"
118+
dest: /tmp
119+
checksum: "{{ pgsql_http_release_checksum }}"
120+
121+
- name: pgsql-http - unpack archive
122+
unarchive:
123+
remote_src: yes
124+
src: /tmp/pgsql-http-{{ pgsql_http_release }}.tar.gz
125+
dest: /tmp
126+
become: yes
127+
128+
- name: pgsql-http - build
129+
make:
130+
chdir: /tmp/pgsql-http-{{ pgsql_http_release }}
131+
become: yes
132+
133+
- name: pgsql-http - install
134+
make:
135+
chdir: /tmp/pgsql-http-{{ pgsql_http_release }}
136+
target: install
137+
become: yes
138+
139+
# plpgsql_check
140+
- name: plpgsql_check - download & install dependencies
141+
apt:
142+
pkg:
143+
- libicu-dev
144+
update_cache: yes
145+
install_recommends: no
146+
147+
- name: plpgsql_check - download latest release
148+
get_url:
149+
url: https://github.com/okbob/plpgsql_check/archive/v{{ plpgsql_check_release }}.tar.gz
150+
dest: /tmp
151+
checksum: "{{ plpgsql_check_release_checksum }}"
152+
153+
- name: plpgsql_check - unpack archive
154+
unarchive:
155+
remote_src: yes
156+
src: /tmp/plpgsql_check-{{ plpgsql_check_release }}.tar.gz
157+
dest: /tmp
158+
become: yes
159+
160+
- name: plpgsql_check - clean
161+
make:
162+
chdir: /tmp/plpgsql_check-{{ plpgsql_check_release }}
163+
target: clean
164+
become: yes
165+
166+
- name: plpgsql_check - install
167+
make:
168+
chdir: /tmp/plpgsql_check-{{ plpgsql_check_release }}
169+
target: install
170+
become: yes
171+
172+
# pljava
173+
- name: pljava - download & install dependencies
174+
apt:
175+
pkg:
176+
- maven
177+
- default-jre
178+
- default-jdk
179+
update_cache: yes
180+
install_recommends: yes
181+
182+
- name: pljava - download latest release
183+
get_url:
184+
url: https://github.com/tada/pljava/archive/V{{ pljava_release }}.tar.gz
185+
dest: /tmp
186+
checksum: "{{ pljava_release_checksum }}"
187+
188+
- name: pljava - unpack archive
189+
unarchive:
190+
remote_src: yes
191+
src: /tmp/pljava-{{ pljava_release }}.tar.gz
192+
dest: /tmp
193+
become: yes
194+
195+
- name: pljava - build
196+
become: yes
197+
shell:
198+
cmd: mvn clean install
199+
chdir: /tmp/pljava-{{ pljava_release }}
200+
201+
- name: pljava - install
202+
become: yes
203+
shell:
204+
cmd: java -jar pljava-packaging/target/pljava-pg12.3-amd64-Linux-gpp.jar
205+
chdir: /tmp/pljava-{{ pljava_release }}
206+
207+
- name: pljava - remove build dependencies
208+
apt:
209+
pkg:
210+
- maven
211+
- default-jre
212+
- default-jdk
213+
state: absent
214+
215+
- name: pljava - install headless jdk
216+
apt:
217+
pkg:
218+
- default-jdk-headless
219+
update_cache: yes
220+
install_recommends: no
221+
222+
- name: pljava - set pljava.libjvm_location
223+
become: yes
224+
shell:
225+
cmd: echo "pljava.libjvm_location = '/usr/lib/jvm/java-11-openjdk-amd64/lib/server/libjvm.so'" >> /etc/postgresql/12/main/postgresql.conf
226+
227+
- name: pljava - remove ~/.m2 directory
228+
become: yes
229+
file:
230+
path: ~/.m2
231+
state: absent
232+
233+
# plv8
84234
- name: plv8 - download & install dependencies
85235
apt:
86236
pkg:
@@ -119,19 +269,3 @@
119269
chdir: /tmp/plv8
120270
target: install
121271
become: yes
122-
123-
- name: plv8 - remove build dependencies
124-
apt:
125-
pkg:
126-
- ca-certificates
127-
- curl
128-
- git-core
129-
- python
130-
- gpp
131-
- cpp
132-
- pkg-config
133-
- apt-transport-https
134-
- cmake
135-
- libc++-dev
136-
- libc++abi-dev
137-
- postgresql-server-dev-12

‎ansible/tasks/setup-misc.yml

Lines changed: 24 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,24 @@
1+
# WAL-G
2+
- name: Install daemontools
3+
become: yes
4+
apt:
5+
pkg:
6+
- daemontools
7+
8+
- name: WAL-G - download latest release
9+
get_url:
10+
url: https://github.com/wal-g/wal-g/releases/download/v{{ wal_g_release }}/wal-g.linux-amd64.tar.gz
11+
dest: /tmp
12+
checksum: "{{ wal_g_release_checksum }}"
13+
14+
- name: WAL-G - unpack archive
15+
unarchive:
16+
remote_src: yes
17+
src: /tmp/wal-g.linux-amd64.tar.gz
18+
dest: /tmp
19+
become: yes
20+
21+
- name: WAL-G - install
22+
become: yes
23+
shell:
24+
cmd: mv /tmp/wal-g /usr/local/bin/

‎ansible/vars.yml

Copy file name to clipboard
Lines changed: 15 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,6 +2,7 @@ postgresql_version: 12
22
postgresql_wal_level: "logical"
33
postgresql_max_wal_senders: 10
44
postgresql_max_replication_slots: 5
5+
postgresql_row_security: on
56
postgresql_listen_addresses:
67
- "*"
78

@@ -11,7 +12,7 @@ postgresql_ext_install_dev_headers: yes
1112
# Warning: Make sure the postgresql & postgis versions are compatible with one another
1213
postgresql_ext_postgis_version: 3
1314

14-
postgresql_shared_preload_libraries: [pg_stat_statements, pgaudit]
15+
postgresql_shared_preload_libraries: [pg_stat_statements, pgaudit, plpgsql, plpgsql_check ]
1516

1617
postgresql_pg_hba_custom:
1718
- {type: "host", database: "all", user: "all", address: "0.0.0.0/0", method: "md5" }
@@ -22,8 +23,20 @@ pgtap_release_checksum: sha1:cca57708e723de18735a723b774577dc52f6f31e
2223
pgaudit_release: "1.4.0"
2324
pgaudit_release_checksum: sha1:ea085fbf227b5c461331ab33b99579f37db299a6
2425

26+
pgsql_http_release: "1.3.1"
27+
pgsql_http_release_checksum: sha1:816a3fff53e05301b176cf0696799fc5a00f54e8
28+
29+
plpgsql_check_release: "1.11.0"
30+
plpgsql_check_release_checksum: sha1:395313b6ef9c10c4fc182817d6f0040b171147b8
31+
32+
pljava_release: "1_5_5"
33+
pljava_release_checksum: sha1:5277433030fdeed8528c7c0154163b54aedbd842
34+
2535
postgresql_log_destination: "csvlog"
2636
postgresql_logging_collector: on
2737
postgresql_log_filename: "postgresql.log"
2838
postgresql_log_rotation_age: 0
29-
postgresql_log_rotation_size: 0
39+
postgresql_log_rotation_size: 0
40+
41+
wal_g_release: "0.2.15"
42+
wal_g_release_checksum: sha1:e82d405121e0ccc322a323b9824e60c102b14004

0 commit comments

Comments
 (0)
0