Changeset View
Changeset View
Standalone View
Standalone View
databases/postgresql14-server/files/502.pgsql.in
| Context not available. | |||||
| now=`date "+%Y-%m-%dT%H:%M:%S"` | now=`date "+%Y-%m-%dT%H:%M:%S"` | ||||
| file=${daily_pgsql_backupdir}/pgglobals_${now} | file=${daily_pgsql_backupdir}/pgglobals_${now} | ||||
| su -l ${daily_pgsql_user} -c \ | su -l ${daily_pgsql_user} -c \ | ||||
| "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz" | "umask 077; pg_dumpall-%%PG_VERS%% -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz" | ||||
| db=$1 | db=$1 | ||||
| while shift; do | while shift; do | ||||
| echo -n " $db" | echo -n " $db" | ||||
| file=${backupdir}/pgdump_${db}_${now} | file=${backupdir}/pgdump_${db}_${now} | ||||
| su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" | su -l ${daily_pgsql_user} -c "umask 077; pg_dump-%%PG_VERS%% ${daily_pgsql_pgdump_args} -f ${file} ${db}" | ||||
| [ $? -gt 0 ] && rc=3 | [ $? -gt 0 ] && rc=3 | ||||
| db=$1 | db=$1 | ||||
| done | done | ||||
| Context not available. | |||||
| echo | echo | ||||
| echo "PostgreSQL vacuum" | echo "PostgreSQL vacuum" | ||||
| su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}" | su -l ${daily_pgsql_user} -c "vacuumdb-%%PG_VERS%% ${daily_pgsql_vacuum_args}" | ||||
| if [ $? -gt 0 ] | if [ $? -gt 0 ] | ||||
| then | then | ||||
| echo | echo | ||||
| Context not available. | |||||