diff options
| author | Palle Girgensohn <girgen@FreeBSD.org> | 2008-06-12 23:46:07 +0000 |
|---|---|---|
| committer | Palle Girgensohn <girgen@FreeBSD.org> | 2008-06-12 23:46:07 +0000 |
| commit | 89025407ac8aa413884e5a33322957c188ca0a40 (patch) | |
| tree | 02f0c0fbc1b0c6f9cdb6cd06fbdc74eb75df3d0c /databases/postgresql81-server/files | |
| parent | - Fix QT4 modules dependency list (diff) | |
Updates of the PostgreSQL ports
Updates for all maintained versions of PostgreSQL are available today:
8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. These releases fix more than
two dozen minor issues reported and patched over the last few months.
All PostgreSQL users should plan to update at their earliest
convenience. People in affected time zones, in particular, should
upgrade as soon as possible.
Release Notes:
http://www.postgresql.org/docs/8.3/static/release.html
Also, fix umask error in periodic script [1].
PR: ports/124457 [1]
Submitted by: Alexandre Perrin
Diffstat (limited to 'databases/postgresql81-server/files')
| -rw-r--r-- | databases/postgresql81-server/files/502.pgsql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/databases/postgresql81-server/files/502.pgsql b/databases/postgresql81-server/files/502.pgsql index 09591559c317..acc1afe431cf 100644 --- a/databases/postgresql81-server/files/502.pgsql +++ b/databases/postgresql81-server/files/502.pgsql @@ -56,15 +56,15 @@ case "$daily_pgsql_backup_enable" in # Protect the data umask 077 - dbnames=`su -l pgsql -c "psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} - su -l pgsql -c "pg_dumpall -g | gzip -9 > ${file}.gz" + su -l pgsql -c "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz" for db in ${dbnames}; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} - su -l pgsql -c "pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" + su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 done |
