Source

iredmail / iRedMail / conf / postgresql

Zhang Huangbin 2d4d9fb 

Zhang Huangbin 69f2f69 
Zhang Huangbin 2d4d9fb 



















Zhang Huangbin f7a73ea 

Zhang Huangbin 2d4d9fb 
Zhang Huangbin 1de8d83 

Zhang Huangbin 2ebbddd 


Zhang Huangbin c57c299 
Zhang Huangbin 72ad0fa 

Zhang Huangbin 1de8d83 
Zhang Huangbin 2ebbddd 
Zhang Huangbin 2d4d9fb 
Zhang Huangbin 19c4a5d 
Zhang Huangbin f5a0d22 

Zhang Huangbin 19c4a5d 







Zhang Huangbin 4b87d19 





Zhang Huangbin 19c4a5d 

Zhang Huangbin 58a1263 



Zhang Huangbin 3755fba 
Zhang Huangbin 19c4a5d 

Zhang Huangbin 3755fba 
Zhang Huangbin 85bce8a 




Zhang Huangbin 3755fba 


Zhang Huangbin 12efb11 









Zhang Huangbin 58a1263 





Zhang Huangbin 2ebbddd 
Zhang Huangbin d166249 
Zhang Huangbin 19c4a5d 

Zhang Huangbin c57c299 


Zhang Huangbin 2ebbddd 



Zhang Huangbin c39af05 


Zhang Huangbin 12efb11 
Zhang Huangbin c39af05 



Zhang Huangbin 2ebbddd 


Zhang Huangbin 2d4d9fb 
#!/usr/bin/env bash

# Author:   Zhang Huangbin (zhb _at_ iredmail.org)

#---------------------------------------------------------------------
# This file is part of iRedMail, which is an open source mail server
# solution for Red Hat(R) Enterprise Linux, CentOS, Debian and Ubuntu.
#
# iRedMail is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# iRedMail is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with iRedMail.  If not, see <http://www.gnu.org/licenses/>.
#---------------------------------------------------------------------

# Variables for PostgreSQL database server and related.
# PGSQL_SERVER and PGSQL_SERVER_PORT are defined in conf/global.
# SQL_SERVER and SQL_SERVER_PORT are defined in dialog/config_via_dialog.sh.

export PGSQL_SYS_USER='postgres'
export PGSQL_SYS_GROUP='postgres'

export PGSQL_SYS_USER_HOME='/var/lib/postgresql'

export PGSQL_VERSION='9.1'  # Required on Gentoo
export PGSQL_RC_SCRIPT_NAME='postgresql'

export PGSQL_VMAIL_STRUCTURE_SAMPLE="${SAMPLE_DIR}/iredmail.pgsql"
export PGSQL_INIT_SQL_SAMPLE="${CONF_DIR}/pgsql_init.pgsql"

if [ X"${DISTRO}" == X'RHEL' ]; then
    # RHEL/CENTOS 6
    export PGSQL_VERSION='8.4'
    export PGSQL_SYS_USER_HOME='/var/lib/pgsql'
    export PGSQL_DATA_DIR="${PGSQL_SYS_USER_HOME}/data"

    export PGSQL_CONF_DIR="${PGSQL_DATA_DIR}"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_DATA_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_DATA_DIR}/pg_hba.conf"

elif [ X"${DISTRO}" == X'SUSE' ]; then
    export PGSQL_SYS_USER_HOME='/var/lib/pgsql'
    export PGSQL_DATA_DIR="${PGSQL_SYS_USER_HOME}/data"

    export PGSQL_CONF_DIR="${PGSQL_DATA_DIR}"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_DATA_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_DATA_DIR}/pg_hba.conf"

elif [ X"${DISTRO}" == X'GENTOO' ]; then
    export PGSQL_CONF_DIR="/etc/postgresql-${PGSQL_VERSION}"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_CONF_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_CONF_DIR}/pg_hba.conf"
    export PGSQL_DATA_DIR="/var/lib/postgresql/${PGSQL_VERSION}/data"

    export PGSQL_RC_SCRIPT_NAME="postgresql-${PGSQL_VERSION}"

elif [ X"${DISTRO}" == X'FREEBSD' ]; then
    export PGSQL_SYS_USER='pgsql'
    export PGSQL_SYS_GROUP='pgsql'
    export PGSQL_SYS_USER_HOME='/usr/local/pgsql'

    export PGSQL_CONF_DIR="${PGSQL_SYS_USER_HOME}/data"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_CONF_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_CONF_DIR}/pg_hba.conf"
    export PGSQL_DATA_DIR="${PGSQL_CONF_DIR}"

elif [ X"${DISTRO}" == X'OPENBSD' ]; then
    export PGSQL_SYS_USER='_postgresql'
    export PGSQL_SYS_GROUP='_postgresql'
    export PGSQL_SYS_USER_HOME='/var/postgresql'

    export PGSQL_CONF_DIR="${PGSQL_SYS_USER_HOME}/data"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_CONF_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_CONF_DIR}/pg_hba.conf"
    export PGSQL_DATA_DIR="${PGSQL_CONF_DIR}"
else
    export PGSQL_CONF_DIR="/etc/postgresql/${PGSQL_VERSION}/main"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_CONF_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_CONF_DIR}/pg_hba.conf"
    export PGSQL_DATA_DIR="/var/lib/postgresql/${PGSQL_VERSION}/main"
fi

export PGSQL_ROOT_USER="${PGSQL_SYS_USER}"
export PGSQL_RC_SCRIPT="${DIR_RC_SCRIPTS}/${PGSQL_RC_SCRIPT_NAME}"

# ~/.pgpass
export PGSQL_DOT_PGPASS="${PGSQL_SYS_USER_HOME}/.pgpass"

# SSL cert/key
export PGSQL_SSL_CERT="${SSL_CERT_DIR}/iRedMail_CA_PostgreSQL.pem"
export PGSQL_SSL_KEY="${SSL_KEY_DIR}/iRedMail_PostgreSQL.key"

# Commands
export PGSQL_BIN_PG_DUMP='/usr/bin/pg_dump'
export PGSQL_BIN_PG_DUMPALL='/usr/bin/pg_dumpall'
if [ X"${DISTRO}" == X"FREEBSD" -o X"${DISTRO}" == X'OPENBSD' ]; then
    export PGSQL_BIN_PG_DUMP='/usr/local/bin/pg_dump'
    export PGSQL_BIN_PG_DUMPALL='/usr/local/bin/pg_dumpall'
fi

export PGSQL_BACKUP_DATABASES="${PGSQL_BACKUP_DATABASES}"
if [ X"${BACKEND}" == X"PGSQL" ]; then
    export PGSQL_BACKUP_DATABASES="${PGSQL_BACKUP_DATABASES} ${VMAIL_DB}"
fi