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

Re: Backup suggestions

From: Aditya <aditya(at)grot(dot)org>
To: chulat(at)mail(dot)com
Cc: sfpug(at)postgresql(dot)org
Subject: Re: Backup suggestions
Date: 2003-08-13 22:07:40
Message-ID: 20030813220740.GB39274@mighty.grot.org (view raw or flat)
Thread:
Lists: sfpug
On Wed, Aug 13, 2003 at 02:16:35PM -0700, LN Cisneros wrote:
> 
> Does anyone have recommendations for backing up a postgresql database on a nightly basis.
> 
> My system:
> 
> AMD XP 1800+
> Two IDE HDs (80GB ea.)
> 
> Is there a good tape drive out there or some other recommendation?
> 
> Size of database could be in gigabytes once all the different year's data is loaded.

use pg_dump and dump a table at a time to a file (or are you tables
multi-gigabytes big?) and then use rsync to copy it across the network to
another drive.

Aditya

In response to

sfpug by date

Next:From: David AlbanDate: 2003-08-14 20:47:17
Subject: SIG-BEER-WEST this Saturday 8/16 in San Francisco
Previous:From: David FetterDate: 2003-08-13 21:19:53
Subject: Re: Backup suggestions

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