hestiacp/web/edit/server/postgresql/index.php

<?php

error_reporting(null);
$TAB = 'SERVER';

// Main include
include($_SERVER['DOCUMENT_ROOT']."/inc/main.php");

// Check user
if ($_SESSION['userContext'] != 'admin') {
    header("Location: /list/user");
    exit;
}

// Check POST request
if (!empty($_POST['save'])) {

    // Check token
    verify_csrf($_POST);

    // Set restart flag
    $v_restart = 'yes';
    if (empty($_POST['v_restart'])) {
        $v_restart = 'no';
    }

    // Update option
    if (!empty($_POST['v_options'])) {
        exec('mktemp', $mktemp_output, $return_var);
        $new_conf = $mktemp_output[0];
        $fp = fopen($new_conf, 'w');
        fwrite($fp, str_replace("\r\n", "\n", $_POST['v_options']));
        fclose($fp);
        exec(HESTIA_CMD."v-change-sys-service-config ".$new_conf." postgresql-hba ".$v_restart, $output, $return_var);
        check_return_code($return_var, $output);
        unset($output);
        unlink($new_conf);
    }

    // Update config
    if ((empty($_SESSION['error_msg'])) && (!empty($_POST['v_config']))) {
        exec('mktemp', $mktemp_output, $return_var);
        $new_conf = $mktemp_output[0];
        $fp = fopen($new_conf, 'w');
        fwrite($fp, str_replace("\r\n", "\n", $_POST['v_config']));
        fclose($new_conf);
        exec(HESTIA_CMD."v-change-sys-service-config ".$new_conf." postgresql " .$v_restart, $output, $return_var);
        check_return_code($return_var, $output);
        unset($output);
        unlink($new_conf);
    }

    // Set success message
    if (empty($_SESSION['error_msg'])) {
        $_SESSION['ok_msg'] = _('Changes has been saved.');
    }
}

// List config
exec(HESTIA_CMD."v-list-sys-pgsql-config json", $output, $return_var);
$data = json_decode(implode('', $output), true);
unset($output);

$v_options_path = $data['CONFIG']['pg_hba_path'];
$v_config_path = $data['CONFIG']['config_path'];
$v_service_name = strtoupper('postgresql');

// Read config
$v_options = shell_exec(HESTIA_CMD."v-open-fs-config ".$v_options_path);
$v_config = shell_exec(HESTIA_CMD."v-open-fs-config ".$v_config_path);

// Render page
render_page($user, $TAB, 'edit_server_pgsql');

// Flush session messages
unset($_SESSION['error_msg']);
unset($_SESSION['ok_msg']);