Skip site navigation (1) Skip section navigation (2)

multiple site/db central backup with pitr using pgadmin3?

From: OpenMacNews <openmacnews(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: multiple site/db central backup with pitr using pgadmin3?
Date: 2005-11-15 08:16:49
Message-ID: 43799971.5060505@gmail.com (view raw or flat)
Thread:
Lists: 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-----


Responses

pgadmin-hackers by date

Next:From: Andreas PflugDate: 2005-11-15 16:26:28
Subject: Re: multiple site/db central backup with pitr using
Previous:From: Dave PageDate: 2005-11-15 08:04:02
Subject: Re: pgAdmin3-1.4.0/FreeBSD package.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group