postgresql_selinux

Section: postgresql SELinux Policy documentation (8)
Updated: postgresql
Index Return to Main Contents

NAME

postgresql_selinux - Security Enhanced Linux Policy for the postgresql processes

DESCRIPTION

SELinux Linux secures postgresql (PostgreSQL relational database) processes via flexible mandatory access control.

BOOLEANS

SELinux policy is customizable based on least access required. postgresql policy is extremely flexible and has several booleans that allow you to manipulate the policy and run postgresql with the tightest access possible.

If you want to allow users to connect to PostgreSQ, you must turn on the allow_user_postgresql_connect boolean.

setsebool -P allow_user_postgresql_connect 1

FILE CONTEXTS

SELinux requires files to have an extended attribute to define the file type.

You can see the context of a file using the -Z option to lsP Policy governs the access confined processes have to these files. SELinux postgresql policy is very flexible allowing users to setup their postgresql processes in as secure a method as possible.

The following file types are defined for postgresql:

postgresql_db_t

- Set files with the postgresql_db_t type, if you want to treat the files as postgresql database content.

Paths:: /var/lib/pgsql/data(/.*)?, /var/lib/sepgsql(/.*)?, /usr/lib(64)?/pgsql/test/regress(/.*)?, /usr/share/jonas/pgsql(/.*)?, /var/lib/postgres(ql)?(/.*)?

postgresql_etc_t

- Set files with the postgresql_etc_t type, if you want to store postgresql files in the /etc directories.

Paths:: /etc/sysconfig/pgsql(/.*)?, /etc/postgresql(/.*)?

postgresql_exec_t

- Set files with the postgresql_exec_t type, if you want to transition an executable to the postgresql_t domain.

Paths:: /usr/bin/(se)?postgres, /usr/lib(64)?/pgsql/test/regress/pg_regress, /usr/lib(64)?/postgresql/bin/.*, /usr/bin/initdb(.sepgsql)?

postgresql_initrc_exec_t

- Set files with the postgresql_initrc_exec_t type, if you want to transition an executable to the postgresql_initrc_t domain.

postgresql_lock_t

- Set files with the postgresql_lock_t type, if you want to treat the files as postgresql lock data, stored under the /var/lock directory

postgresql_log_t

- Set files with the postgresql_log_t type, if you want to treat the data as postgresql log data, usually stored under the /var/log directory.

Paths:: /var/lib/sepgsql/pgstartup.log, /var/lib/pgsql/pgstartup.log, /var/log/postgresql(/.*)?, /var/log/postgres.log.*, /var/log/rhdb/rhdb(/.*)?, /var/lib/pgsql/logfile(/.*)?, /var/log/sepostgresql.log.*

postgresql_tmp_t

- Set files with the postgresql_tmp_t type, if you want to store postgresql temporary files in the /tmp directories.

postgresql_var_run_t

- Set files with the postgresql_var_run_t type, if you want to store the postgresql files under the /run directory.

Paths:: /var/run/postmaster.*, /var/run/postgresql(/.*)?

Note: File context can be temporarily modified with the chcon command. If you want to permanently change the file context you need to use the semanage fcontext command. This will modify the SELinux labeling database. You will need to use restorecon to apply the labels.

PORT TYPES

SELinux defines port types to represent TCP and UDP ports.

You can see the types associated with a port by using the following command:

semanage port -l

Policy governs the access confined processes have to these ports. SELinux postgresql policy is very flexible allowing users to setup their postgresql processes in as secure a method as possible.

The following port types are defined for postgresql:

postgresql_port_t

Default Defined Ports: tcp 8021

PROCESS TYPES

SELinux defines process types (domains) for each process running on the system

You can see the context of a process using the -Z option to psP Policy governs the access confined processes have to files. SELinux postgresql policy is very flexible allowing users to setup their postgresql processes in as secure a method as possible.

The following process types are defined for postgresql:

postgresql_t

Note: semanage permissive -a PROCESS_TYPE can be used to make a process type permissive. Permissive process types are not denied access by SELinux. AVC messages will still be generated.

COMMANDS

semanage fcontext can also be used to manipulate default file context mappings.

semanage permissive can also be used to manipulate whether or not a process type is permissive.

semanage module can also be used to enable/disable/install/remove policy modules.

semanage port can also be used to manipulate the port definitions

semanage boolean can also be used to manipulate the booleans

system-config-selinux is a GUI tool available to customize SELinux policy settings.

AUTHOR

This manual page was autogenerated by genman.py.

This document was created by man2html, using the manual pages.
Time: 05:34:28 GMT, December 24, 2015