summaryrefslogtreecommitdiff
path: root/databases/postgresql91-server/files
diff options
context:
space:
mode:
Diffstat (limited to 'databases/postgresql91-server/files')
-rw-r--r--databases/postgresql91-server/files/502.pgsql.in19
-rw-r--r--databases/postgresql91-server/files/pkg-install-server.in42
-rw-r--r--databases/postgresql91-server/files/postgresql.in2
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"