Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

Please post support request to the list, and don't hi-jack
innappropriate subjects!

> -----Original Message-----
> From: Christian Hozee [mailto:Christian(dot)Hozee(at)rivm(dot)nl] 
> Sent: 20 July 2006 10:55
> To: Dave Page
> Subject: Re: [pgadmin-support] pgAdmin III v1.4.3 released
> 
> Dear Dave,
> 
> Thanks for your reply. I have downloaded and installed 
> Pgadmin 1.4.3 but I
> can't figure out how to schedule a backup job once a week. I 
> have searched
> Pgadmin.org but I can't figure it out. I hope you can help me out.

On Unix? Simply create a job with an appropriate schedule, and add a
batch/shell step to do the work. You can either just call an external
script, or write the script into the step itself, e.g.

#!/bin/sh

/usr/local/pgsql/bin/pg_dumpall -h 127.0.0.1 -U postgres -p 5432 >
/var/backups/mydbdump.sql

On Windows, just use batch syntax instead of shell, and in either case,
specify the complete set of options the pg_dumpall (or pg_dump) requires
to dump the required cluster.

Regards, Dave.