Re: CRON Jobs and Backups

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
>>
>>
>
>
>