1. Zhang Huangbin
  2. iredmail

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 72ad0fa 

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






Zhang Huangbin 4b87d19 




Zhang Huangbin 19c4a5d 
Zhang Huangbin d5249ab 






Zhang Huangbin 3755fba 
Zhang Huangbin 85bce8a 



Zhang Huangbin d5249ab 


Zhang Huangbin 12efb11 





Zhang Huangbin d5249ab 


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_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 ships PostgreSQL-8.4
    export PGSQL_SYS_USER_HOME='/var/lib/pgsql'
    export PGSQL_DATA_DIR="${PGSQL_SYS_USER_HOME}/data"

    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_POSTGRESQL="${PGSQL_DATA_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_DATA_DIR}/pg_hba.conf"

elif [ X"${DISTRO}" == X'DEBIAN' -o X"${DISTRO}" == X'UBUNTU' ]; then
    export PGSQL_VERSION='9.1'
    export PGSQL_DATA_DIR="/var/lib/postgresql/${PGSQL_VERSION}/main"
    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"

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_DATA_DIR="${PGSQL_SYS_USER_HOME}/data"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_DATA_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_DATA_DIR}/pg_hba.conf"

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_DATA_DIR="${PGSQL_SYS_USER_HOME}/data"
    export PGSQL_CONF_POSTGRESQL="${PGSQL_DATA_DIR}/postgresql.conf"
    export PGSQL_CONF_PG_HBA="${PGSQL_DATA_DIR}/pg_hba.conf"
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