postgres
postgres copied to clipboard
feat: draft to block copy ... program
Removed execute permissions that enabled COPY...PROGRAM:
- /usr/bin/cat rix
- /usr/bin/dash rix
- /usr/bin/mknod rix
Added explicit deny rules:
Explicitly deny shell execution to block COPY ... PROGRAM
deny /bin/sh x, deny /bin/bash x, deny /bin/dash x, deny /usr/bin/sh x, deny /usr/bin/bash x, deny /usr/bin/dash x, deny /usr/bin/cat x, deny /usr/bin/mknod x,
Improved documentation for preserved operations (admin-mgr, wal-g)
File 2: Permission Tests (ansible/files/permission_check.py)
+93 lines
Added check_copy_program_blocked() function that:
- Tests COPY TO PROGRAM (write via cat)
- Tests COPY FROM PROGRAM (read via echo)
- Verifies both fail with permission errors
- Confirms no files created
- Integrated into main test suite
Result
OS-level blocking of COPY ... PROGRAM using AppArmor while preserving WAL-G and admin-mgr functionality, with automated testing in the AMI build process.