## <summary>PostgreSQL relational database</summary>

########################################

## <summary>

##	Allow the specified domain to search postgresql's database directory.

## </summary>

## <param name="domain">

##	<summary>

##	Domain allowed access.

##	</summary>

## </param>

#

interface(`postgresql_search_db',`

	gen_require(`

		type postgresql_db_t;

	')

	allow $1 postgresql_db_t:dir search;

')

########################################

## <summary>

##	Allow the specified domain to manage postgresql's database.

## </summary>

## <param name="domain">

##	<summary>

##	Domain allowed access.

##	</summary>

## </param>

interface(`postgresql_manage_db',`

	gen_require(`

		type postgresql_db_t;

	')

	allow $1 postgresql_db_t:dir rw_dir_perms;

	allow $1 postgresql_db_t:file rw_file_perms;

	allow $1 postgresql_db_t:lnk_file { getattr read };

')

########################################

## <summary>

##	Execute postgresql in the postgresql domain.

## </summary>

## <param name="domain">

##	<summary>

##	The type of the process performing this action.

##	</summary>

## </param>

#

interface(`postgresql_domtrans',`

	gen_require(`

		type postgresql_t, postgresql_exec_t;

	')

	domtrans_pattern($1,postgresql_exec_t,postgresql_t)

')

########################################

## <summary>

##	Allow the specified domain to read postgresql's etc.

## </summary>

## <param name="domain">

##	<summary>

##	Domain allowed access.

##	</summary>

## </param>

## <rolecap/>

#

interface(`postgresql_read_config',`

	gen_require(`

		type postgresql_etc_t;

	')

	files_search_etc($1)

	allow $1 postgresql_etc_t:dir { getattr read search };

	allow $1 postgresql_etc_t:file { read getattr };

	allow $1 postgresql_etc_t:lnk_file { getattr read };

')

########################################

## <summary>

##	Allow the specified domain to connect to postgresql with a tcp socket.

## </summary>

## <param name="domain">

##	<summary>

##	Domain allowed access.

##	</summary>

## </param>

#

interface(`postgresql_tcp_connect',`

	gen_require(`

		type postgresql_t;

	')

	corenet_tcp_recvfrom_labeled($1,postgresql_t)

	corenet_tcp_sendrecv_postgresql_port($1)

	corenet_tcp_connect_postgresql_port($1)

	corenet_sendrecv_postgresql_client_packets($1)

')

########################################

## <summary>

##	Allow the specified domain to connect to postgresql with a unix socket.

## </summary>

## <param name="domain">

##	<summary>

##	Domain allowed access.

##	</summary>

## </param>

## <rolecap/>

#

interface(`postgresql_stream_connect',`

	gen_require(`

		type postgresql_t, postgresql_var_run_t, postgresql_tmp_t;

	')

	files_search_pids($1)

	allow $1 postgresql_t:unix_stream_socket connectto;

	allow $1 postgresql_var_run_t:sock_file write;

        # Some versions of postgresql put the sock file in /tmp

	allow $1 postgresql_tmp_t:sock_file write;

')