Thread: multiple site/db central backup with pitr using pgadmin3?
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 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? thoughts/comments? thx! richard - -- /"\ \ / ASCII Ribbon Campaign X against HTML email, vCards / \ & micro$oft attachments [GPG] OpenMacNews at gmail dot com fingerprint: 50C9 1C46 2F8F DE42 2EDB D460 95F7 DDBD 3671 08C6 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (Darwin) iEYEAREDAAYFAkN5mXEACgkQlffdvTZxCMY6wwCfQPHO3N32kTozSaHlU6WEwVPE FOgAni2xtTqiy2c8QpDi9bRzflCsN7ze =vo4+ -----END PGP SIGNATURE-----
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