Re: multiple site/db central backup with pitr using

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

OpenMacNews wrote:
> hi all.
>
> just coming up to speed on the idea-basics, but thought i'd ask (*while* i rtfm ...) if "it" can
> be done in/with pgadmin3.
>
> i've numerous boxes with pgsql instances, and the usual assortment of DBs/box.
>
> backing up, til now, has been script-driven, each box being backed up separately ... but, now,
> getting to be tedious/messy.
>
> i'd like to back up to a central server, with version control.
>
> from irc chat, sounds like the right way to do this is connect from local to remote, pg_dump
> remote db to local disk over network, and implement "point in time recovery" (cref:
> http://www.postgresql.org/docs/current/static/backup-online.html).
>
> in principle, all doable via shell script ...
>
> doable/automated via pgadmin3?

PITR and pg_dump are two different concepts, both allowing online 
backup. You could run the backup processes using the pgAgent scheduler, 
which would provide handling integrated in other db related tasks, i.e. 
in pgAdmin.

Regards,
Andreas