iredmail / iRedMail / conf / postgresql

#!/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_ROOT_USER='postgres'

export PGSQL_SYS_USER_HOME='/var/lib/postgresql'
export PGSQL_DOT_PGPASS="${PGSQL_SYS_USER_HOME}/.pgpass"

export PGSQL_VERSION='9.1'
export PGSQL_INIT_SCRIPT="${DIR_RC_SCRIPTS}/postgresql"
[ X"${DISTRO}" == X"GENTOO" ] && \
    export PGSQL_INIT_SCRIPT="${DIR_RC_SCRIPTS}/postgresql-${PGSQL_VERSION}"
export PGSQL_VMAIL_STRUCTURE_SAMPLE="${SAMPLE_DIR}/iredmail.pgsql"
export PGSQL_INIT_SQL_SAMPLE="${CONF_DIR}/pgsql_init.pgsql"

if [ 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"
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

# 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" ]; 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
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.