Quick Links

scheduled backup

From:	Apu Islam <apuislam(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	scheduled backup
Date:	2005-10-21 17:22:28
Message-ID:	d70f8db90510211022s79304bf0pd44451839c34f407@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

I need suggestion to backup my postgresql server. The database is growing
1/2 Gb a day and I am looking for a solution that would push the data off to
the backup server periodically with minimal amount of load to the server (I
am trying to avoid table locking). I am thinking to use rsync to sync the
data directories periodically. will that allow me to retrieve the data in
case of a disaster ? what is the best practise ?

Responses

Re: scheduled backup at 2005-10-21 17:58:53 from Stephen Frost
Re: scheduled backup at 2005-10-21 18:02:35 from Douglas McNaught
Re: scheduled backup at 2005-10-21 18:10:57 from Tino Wildenhain
Re: scheduled backup at 2005-10-21 18:38:13 from Scott Marlowe

Browse pgsql-general by date

	From	Date	Subject
Next Message	Jerry LeVan	2005-10-21 17:23:42	Ann: PgBrowser-1.1
Previous Message	Andrew Sullivan	2005-10-21 17:18:11	Re: How to cluster Postgresql