Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released) - Mailing list pgadmin-support

From Dave Page
Subject Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40154C0D4@ratbert.vale-housing.co.uk
Whole thread Raw
Responses Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)
List pgadmin-support
Please post support request to the list, and don't hi-jack
innappropriate subjects!

> -----Original Message-----
> From: Christian Hozee [mailto:Christian.Hozee@rivm.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.


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: pgAdmin III v1.4.3 released
Next
From: Antoine
Date:
Subject: Re: Scheduling a backup job (was: pgAdmin III v1.4.3 released)