From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump shell script with ~/.pgpass |
Date: | 2005-01-27 17:06:54 |
Message-ID: | 200501271206.54866.terry@esc1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 27 January 2005 11:47 am, MargaretGillon(at)chromalloy(dot)com saith:
>
> My other question... Is cron.daily is being run by root? If so would I need
> to put the .pgpass file in root's home directory?
>
--
I don't know about .pgpass, so I can't help you with that. Root does run
cron.daily. You can setup your own personal crontab entries by issuing the
following command:
crontab -e
Do this with your personal account, not root. You will get a vi session when
you execute this command and then you can setup you backup to occur as you
desire.
Here is what mine looks like:
# min hour dom mon doy command
# --- ---- ---- ---- ----- ---------------
30 7,12,22 * * * /esc/source.bkp
0 22 * * * cd /esc/pgrnd/prog;
./dbDump.sh rnd
Word wrap has screwed up the alignment, but you get the idea.
From | Date | Subject | |
---|---|---|---|
Next Message | Eric E | 2005-01-27 17:09:47 | View definition truncated in information_schema |
Previous Message | Shawn Harrison | 2005-01-27 17:01:17 | Re: Extended unit |