| From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Locking Tables & Backup Inquiry |
| Date: | 2011-12-14 18:54:20 |
| Message-ID: | CAAQLLO5C9T9QxsYiX8-g-9peAyyaECfkbiMMO_e=MtYif9=7LQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2011-12-14 19:00:18 | Re: Locking Tables & Backup Inquiry |
| Previous Message | Andy Colson | 2011-12-14 18:38:19 | Re: Locking Tables & Backup Inquiry |