| Server IP : 85.214.239.14 / Your IP : 18.221.97.20 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/2/root/proc/3/root/proc/2/task/2/cwd/proc/2/cwd/usr/share/postgresql/9.6/contrib/ |
Upload File : |
-- -- contrib/sepgsql/sepgsql.sql -- -- [Step to install] -- -- 1. Run initdb -- to set up a new database cluster. -- -- 2. Edit $PGDATA/postgresql.conf -- to add '$libdir/sepgsql' to shared_preload_libraries. -- -- Example) -- shared_preload_libraries = '$libdir/sepgsql' -- -- 3. Run this script for each databases -- This script installs corresponding functions, and assigns initial -- security labels on target database objects. -- It can be run both single-user mode and multi-user mode, according -- to your preference. -- -- Example) -- $ for DBNAME in template0 template1 postgres; \ -- do \ -- postgres --single -F -c exit_on_error=true -D $PGDATA $DBNAME \ -- < /path/to/script/sepgsql.sql > /dev/null \ -- done -- -- 4. Start postmaster, -- if you initialized the database in single-user mode. -- LOAD '$libdir/sepgsql'; CREATE OR REPLACE FUNCTION pg_catalog.sepgsql_getcon() RETURNS text AS '$libdir/sepgsql', 'sepgsql_getcon' LANGUAGE C; CREATE OR REPLACE FUNCTION pg_catalog.sepgsql_setcon(text) RETURNS bool AS '$libdir/sepgsql', 'sepgsql_setcon' LANGUAGE C; CREATE OR REPLACE FUNCTION pg_catalog.sepgsql_mcstrans_in(text) RETURNS text AS '$libdir/sepgsql', 'sepgsql_mcstrans_in' LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION pg_catalog.sepgsql_mcstrans_out(text) RETURNS text AS '$libdir/sepgsql', 'sepgsql_mcstrans_out' LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION pg_catalog.sepgsql_restorecon(text) RETURNS bool AS '$libdir/sepgsql', 'sepgsql_restorecon' LANGUAGE C; SELECT sepgsql_restorecon(NULL);