Attachment 87791 Details for Bug 124457 – file.diff

[patch] file.diff

file.diff (text/plain), 1.11 KB, created by Alexandre Perrin on 2008-06-10 20:30:01 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alexandre Perrin

Created: 2008-06-10 20:30:01 UTC

Size: 1.11 KB

patch

obsolete

>--- 502.pgsql.bak       2008-06-10 19:53:55.000000000 +0200
>+++ 502.pgsql   2008-06-10 19:56:38.000000000 +0200
>@@ -55,16 +55,16 @@
>         echo "PostgreSQL maintenance"
> 
>         # 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\'"`
>+        with_good_umask="umask 077;"
>+        dbnames=`su -l pgsql -c "$with_good_umask 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 "$with_good_umask 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 "$with_good_umask pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
>             [ $? -gt 0 ] && rc=3
>         done

Actions: View | Diff

Attachments on bug 124457: 87791