Re: CRON Jobs and Backups

Depends.  If you have only one database, I suppose tar/zip everything
together might be tempting.  I host several domains, each with their own
databases.  I use pg_dump for data backup; use the original install package
as backup to binaries; and make copies of config/startup.

Frank


At 10:11 AM 6/8/05, Todd Lewis wrote:

>I've started looking at backup options myself. Which is better, tar
>zipping the binaries and data files together, separately, or just running
>pg_dump.
>
>Aarni Ruuhimäki wrote:
>
>>Hi,
>>
>>Here's simple instructions and sample for sftp and cron (linux), which
>>should give you an idea how it works. You can then create your own
>>scripts for the actual job.
>>
>>http://tennis.ecs.umass.edu/~czou/linux/backupSSH.html
>>
>>BR,
>>
>>Aarni
>>
>>
>>On Monday 06 June 2005 20:07, you wrote:
>>
>>
>>>hi all,
>>>
>>>i've googled and searche dmy pgsql books and i can't
>>>quite get a confident grasp on cron jobs.
>>>
>>>as i understand it...  the following should enable me
>>>to backup via cron:
>>>
>>>PGUSER=postgres
>>>PGPASSWORD=password
>>>export PGUSER PGPASSWORD
>>>pg_dump databasename | gzip > databasename.bak.gz
>>>
>>>my interfaces is cpanel and it only gives me one line
>>>to type this in...  can i replace the returns with a
>>>space and will this still work?
>>>
>>>eg, PGUSER=postgres PGPASSWORD=password export...
>>>
>>>will databasename.bak.gz be stored in the same file as
>>>my database?
>>>
>>>how can i store the file on my local computer?
>>>
>>>i finally have some data in my db and i scared of
>>>losing it.  *real* scared!
>>>
>>>tia...
>>>
>>>
>>>
>>>__________________________________
>>>Discover Yahoo!
>>>Have fun online with music videos, cool games, IM and more. Check it out!
>>>http://discover.yahoo.com/online.html
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 5: Have you checked our extensive FAQ?
>>>
>>>               http://www.postgresql.org/docs/faq
>>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq