10000 Implement configurations for WAL-G by dragarcia · Pull Request #145 · supabase/postgres · GitHub
[go: up one dir, main page]
Skip to content

Implement configurations for WAL-G #145

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 40 commits into from
Apr 4, 2022
Merged

Implement configurations for WAL-G #145

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
40 commits
Select commit Hold shift + click to select a range
2f2862e
chore: create wal-g Linux user
dragarcia Feb 17, 2022
a9497e0
Revert WAL-G backport
dragarcia Feb 17, 2022
116cb57
chore: give read access to PG data directory to groups
dragarcia Feb 17, 2022
c37826b
update configs in postgresql.conf
dragarcia Feb 17, 2022
249c69f
WAL-G specific scripts to be triggered via the admin API
dragarcia Feb 17, 2022
b8ced22
Create config directory for wal-g
dragarcia Feb 17, 2022
4073448
chore: add logging for wal-g processes
dragarcia Feb 23, 2022
aaf657a
ensure bindir when installing pgsodium works for EC2 builds
dragarcia Mar 23, 2022
0b7eb6d
triggere dockerbuild
dragarcia Mar 23, 2022
a7db18e
Run backup in background
dragarcia Mar 23, 2022
a1f6444
Inject WALG_SENTINEL_USER_DATA during backups
dragarcia Mar 23, 2022
e2de144
Add scripts for enabling and disabling walg
dragarcia Mar 23, 2022
0d284a5
removed unused scripts
dragarcia Mar 23, 2022
759ff9d
Merge branch 'develop' of github.com:supabase/postgres into chore/wal…
dragarcia Mar 23, 2022
c6394aa
bump versioning
dragarcia Mar 23, 2022
a8b7e24
cleanup
dragarcia Mar 23, 2022
8a76794
Move logrotate to its own dir
dragarcia Mar 23, 2022
2858abc
cleanup: loop through creation of log files
dragarcia Mar 23, 2022
e6b80eb
set up logrotate for all WAL-G log files
dragarcia Mar 23, 2022
9a0becb
Ensure backup is pointing to the correct log file
dragarcia Mar 23, 2022
ef4bec3
Merge branch 'fix/dockerbuild_bin_dir' of github.com:supabase/postgre…
dragarcia Mar 23, 2022
d12cea6
create postgres linux group
dragarcia Mar 24, 2022
cb94a41
ensure that it's config.json, not .env
dragarcia Mar 24, 2022
a3608fe
allow admin API to edit /etc/wal-g/config.json
dragarcia Mar 24, 2022
aa3e4d4
Merge branch 'develop' of github.com:supabase/postgres into chore/wal…
dragarcia Mar 28, 2022
8e8fa4c
add whitespace
dragarcia Mar 28, 2022
cc1d0e8
script to complete wal-g restoration
dragarcia Mar 28, 2022
2aa9ddd
Merge branch 'develop' of github.com:supabase/postgres into chore/wal…
dragarcia Mar 29, 2022
16e2f4a
update adminapi
dragarcia Mar 29, 2022
460ca54
remove bindir in setup-system
dragarcia Mar 29, 2022
55d4263
create wal-g group and move up setting up of wal-g
dragarcia Mar 29, 2022
efc0149
create wal-g log files towards the end
dragarcia Mar 30, 2022
35d7980
Ensure /var/lib/postgresql/data is owned by postgres:postgres
dragarcia Mar 30, 2022
8f57dc0
fix transfer of file found in subdirectories
dragarcia Mar 30, 2022
8c2184e
set primary groups for postgres and wal-g linux users
dragarcia Mar 30, 2022
e7d1c87
Merge branch 'develop' of github.com:supabase/postgres into chore/wal…
dragarcia Mar 30, 2022
7ace90c
newline
dragarcia Mar 31, 2022
96c7b34
modify wal-g related parameters in separate file
dragarcia Mar 31, 2022
992dcb3
bump to 14.1.0.21
dragarcia Apr 4, 2022
a7a9679
more newlines
dragarcia Apr 4, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
allow admin API to edit /etc/wal-g/config.json
  • Loading branch information
@dragarcia
dragarcia committed Mar 24, 2022
commit a3608fec7fed3aea10a8c8e3796b601b007a032a
2 changes: 1 addition & 1 deletion ansible/tasks/internal/admin-api.yml
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -1,7 +1,7 @@
- name: adminapi - system user
user:
name: adminapi
groups: root,admin,postgres
groups: root,admin,postgres,wal-g
append: yes

- name: Find all files in files/admin_api_scripts
Expand Down
6 changes: 4 additions & 2 deletions ansible/tasks/setup-wal-g.yml
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -80,14 +80,16 @@
path: /etc/wal-g
state: directory
owner: wal-g
mode: '0700'
group: wal-g
mode: '0760'

- name: Create /etc/wal-g/config.json
file:
path: /etc/wal-g/config.json
state: touch
owner: wal-g
mode: '0700'
group: wal-g
mode: '0760'

- name: Create logs dir
become: yes
Expand Down
0