Re: CRON Jobs and Backups

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

Don't know about that... read up on /bin/sh to see how it handles things
like that.

If cpanel let's you upload files, you could put all of the above in a
'backup-pgsql.sh" file on your server then in your cron job put:

/bin/sh backup-pgsql.sh

> will databasename.bak.gz be stored in the same file as
> my database?

probably not.  If I were you, I'd put the full path of where you want the
file to be stored.

> how can i store the file on my local computer?

Mail it to yourself, or download it via FTP/HTTP...

-philip