diff options
Diffstat (limited to 'databases/postgresql91-server/files')
| -rw-r--r-- | databases/postgresql91-server/files/502.pgsql.in | 19 | ||||
| -rw-r--r-- | databases/postgresql91-server/files/pkg-install-server.in | 42 | ||||
| -rw-r--r-- | databases/postgresql91-server/files/postgresql.in | 2 |
3 files changed, 13 insertions, 50 deletions
diff --git a/databases/postgresql91-server/files/502.pgsql.in b/databases/postgresql91-server/files/502.pgsql.in index caa2f90a58c0..e577f83467f4 100644 --- a/databases/postgresql91-server/files/502.pgsql.in +++ b/databases/postgresql91-server/files/502.pgsql.in @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql91-server/files/502.pgsql.in,v 1.2 2011-04-20 15:30:33 girgen Exp $ +# $FreeBSD: /tmp/pcvs/ports/databases/postgresql91-server/files/502.pgsql.in,v 1.3 2011-06-11 23:14:30 girgen Exp $ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run @@ -19,10 +19,12 @@ # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum -daily_pgsql_vacuum_args="-z" -daily_pgsql_pgdump_args="-b -F c" +daily_pgsql_user=%%PG_USER%% +daily_pgsql_vacuum_args="-U ${daily_pgsql_user} -qaz" +daily_pgsql_pgdump_args="-U ${daily_pgsql_user} -bF c" +daily_pgsql_pgdumpall_globals_args="-U ${daily_pgsql_user}" # backupdir is relative to ~pgsql home directory unless it begins with a slash: -daily_pgsql_backupdir="~%%PG_USER%%/backups" +daily_pgsql_backupdir="~${daily_pgsql_user}/backups" daily_pgsql_savedays="7" # If there is a global system configuration file, suck it in. @@ -44,7 +46,7 @@ pgsql_backup() { # but this might not be where you want the backups... if [ ! -d ${backupdir} ] ; then echo Creating ${backupdir} - mkdir -m 700 ${backupdir}; chown %%PG_USER%% ${backupdir} + mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir} fi echo @@ -55,13 +57,14 @@ pgsql_backup() { rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} - su -l %%PG_USER%% -c "umask 077; pg_dumpall -g -U %%PG_USER%% | gzip -9 > ${file}.gz" + su -l ${daily_pgsql_user} -c \ + "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals__args} | gzip -9 > ${file}.gz" db=$1 while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} - su -l %%PG_USER%% -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -U %%PG_USER%% -f ${file} ${db}" + su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 db=$1 done @@ -99,7 +102,7 @@ case "$daily_pgsql_vacuum_enable" in echo echo "PostgreSQL vacuum" - su -l %%PG_USER%% -c "vacuumdb -a -q -U %%PG_USER%% ${daily_pgsql_vacuum_args}" + su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}" if [ $? -gt 0 ] then echo diff --git a/databases/postgresql91-server/files/pkg-install-server.in b/databases/postgresql91-server/files/pkg-install-server.in index efa9b14c2788..66298484c23b 100644 --- a/databases/postgresql91-server/files/pkg-install-server.in +++ b/databases/postgresql91-server/files/pkg-install-server.in @@ -1,11 +1,8 @@ #! /bin/sh -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql91-server/files/Attic/pkg-install-server.in,v 1.1 2011-04-18 23:34:27 girgen Exp $ +# $FreeBSD: /tmp/pcvs/ports/databases/postgresql91-server/files/Attic/pkg-install-server.in,v 1.2 2011-06-11 23:14:30 girgen Exp $ PATH=/bin:/usr/bin:/usr/sbin -PG_USER=%%PG_USER%% -PG_GROUP=%%PG_GROUP%% -PG_UID=%%PG_UID%% backupwarning() { echo " @@ -23,43 +20,6 @@ backupwarning() { echo " } case $2 in -PRE-INSTALL) - backupwarning - PGUSER=${PGUSER:-${PG_USER}} - PGGROUP=${PGGROUP:-${PG_GROUP}} - DB_DIR=${PKG_PREFIX}/${PGUSER} - UID=${PG_UID} - GID=${PG_UID} - - if pw group show "${PGGROUP}" 2>/dev/null; then - echo "You already have a group \"${PGGROUP}\", so I will use it." - else - if pw groupadd ${PGGROUP} -g ${GID}; then - echo "Added group \"${PGGROUP}\"." - else - echo "Adding group \"${PGGROUP}\" failed..." - exit 1 - fi - fi - - if pw user show "${PGUSER}" 2>/dev/null; then - echo "You already have a user \"${PGUSER}\", so I will use it." - else - if pw useradd ${PGUSER} -u ${UID} -g ${PGGROUP} -h - \ - -d ${DB_DIR} -c "PostgreSQL Daemon" - then - echo "Added user \"${PGUSER}\"." - else - echo "Adding user \"${PGUSER}\" failed..." - exit 1 - fi - fi - - if ! [ -x ~${PGUSER} ] ; then - install -m 755 -o ${PGUSER} -g ${PGGROUP} -d ${DB_DIR} - fi - ;; - BACKUPWARNING) backupwarning ;; diff --git a/databases/postgresql91-server/files/postgresql.in b/databases/postgresql91-server/files/postgresql.in index d1e3c763f8da..1d89451644ce 100644 --- a/databases/postgresql91-server/files/postgresql.in +++ b/databases/postgresql91-server/files/postgresql.in @@ -10,7 +10,7 @@ # # postgresql_enable="YES" # # optional -# postgresql_data="%%PREFIX%%/pgsql/data" +# postgresql_data="%%PREFIX%%/%%PG_USER%%/data" # postgresql_flags="-w -s -m fast" # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C" # postgresql_class="default" |