I use cron for make a hourly backup of a postgresql database:

pg_dump -C -d -U user database | bzip2 -tz9 /anydir/backup.sql.bz2

the problem is that the file permisions are rw-r-r, how i can change it to be only rw for owner with that command? Thanks.

Will the following do what you want?

Isn't that the umask setting? As in "umask 077; pg_dump etc; etc"?

dam!!! i'm so newbie... I was thinking about change permisions on stdout or something like that but K.I.S.S. always is the answer... thanks guys . By the way... umask does not affect the creation of new files??? sample:

umask 077; touch myfile1;
touch my file2; (my file2 is 077 too, isn't?)
does i have to do: umask077; touch myfile1; umask 022; touch file2 for turn back permissions?, i use the backup line at crontab.

The umask setting will last until your shell exits. If your umask statement is in a script, it will only take effect for the shell that script runs in and does not effect the calling shell. If you type it at a shell prompt, it will last until that shell exits.

You can test this by checking your umask value prior to running the script, running the script (with the umask statement in it) and checking your umask value again after the script. Any files created in the script will have the new umask value, but your umask at the shell prompt at the end is the same as before running the script.

At least, that's what happened in my bash shell just now...

thanks guys... be well.