multiple site/db central backup with pitr using pgadmin3?
От | OpenMacNews |
---|---|
Тема | multiple site/db central backup with pitr using pgadmin3? |
Дата | |
Msg-id | 43799971.5060505@gmail.com обсуждение исходный текст |
Ответы |
Re: multiple site/db central backup with pitr using
|
Список | pgadmin-hackers |
-----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-----
В списке pgadmin-hackers по дате отправления: