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

On 20/07/06, Dave Page <dpage(at)vale-housing(dot)co(dot)uk> wrote:
> 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.

I imagine he is talking about scheduled jobs à la Oracle Enterprise
Manager. I have to admit it would make postgres admin à lot more
attractive for bosses like mine - they want point and click... I have
set up a postgres database which (apart from stupid design and
implementation mistakes) runs damn well. The only problem is that
there aren't any open source tools that perform the same range of
functions as any of the big three Enterprise Managers.
Would it be that hard to integrate a ssh client and a basic gui
interface to cron/postgres? Sure *nix only (I'm sure a windows module
could be developped also) but who would run postgres on a windows
machine anyway!?!
I know that is one of the major reasons that is stopping our company
from using postgres for most of our internal projects - I am basically
the only one with a real knowledge (and even that is stretching the
truth somewhat!) of the *nix command line and no one at all knows
about cron and whatnot.
Just some thoughts,
Cheers
Antoine

--
This is where I should put some witty comment.