-----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/curre...p-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)

iEYEAREDAAYFAkN5mXEACgkQlffdvTZxCMY6wwCfQPHO3N32kT ozSaHlU6WEwVPE
FOgAni2xtTqiy2c8QpDi9bRzflCsN7ze
=vo4+
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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/curre...p-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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster