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

Re: multiple site/db central backup with pitr using

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: openmacnews(at)gmail(dot)com
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: multiple site/db central backup with pitr using
Date: 2005-11-15 16:26:28
Message-ID: 437A0C34.1090606@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-hackers
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

In response to

pgadmin-hackers by date

Next:From: svnDate: 2005-11-16 21:57:28
Subject: SVN Commit by dpage: r4744 - in trunk/pgadmin3/src: ctl include/ctl
Previous:From: OpenMacNewsDate: 2005-11-15 08:16:49
Subject: multiple site/db central backup with pitr using pgadmin3?

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