Re: Locking Tables & Backup Inquiry

On 12/14/2011 12:54 PM, Carlos Mennens wrote:
> On Wed, Dec 14, 2011 at 1:38 PM, Andy Colson<andy(at)squeakycode(dot)net> wrote:
>> this'll run every hour.
>>
>>> 0 * * * * /usr/bin/pg_dumpall> pg_dumpall.$DATE.sql
>
> Thank you!
>
>> try:
>>
>> 0 4 * * * /usr/bin/pg_dumpall> pg_dumpall.$DATE.sql
>>
>> that'll run at 4am every day.
>
> When I run the command in my shell (not in Cron), I'm prompted for my
> login password. Should I change the permissions in pg_hba.conf and
> enable INHERIT grants on my user? Should I place this in who's Cron
> line? Postgres? Carlos? or Root?
>>
>> Watch the path's, who know's what directory is current:
>>
>> 0 4 * * * /usr/bin/pg_dumpall> /backup/pg_dumpall.$DATE.sql
>
> Yes, I always check my paths and use full paths rather than symbolic links.
>

That's up to you I guess. Assuming the crontab is running as root, you
could add a .pgpass to root's home, which should be secure enough.

-Andy