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
In response to
sfpug by date
|Next:||From: David Alban||Date: 2003-08-14 20:47:17|
|Subject: SIG-BEER-WEST this Saturday 8/16 in San Francisco|
|Previous:||From: David Fetter||Date: 2003-08-13 21:19:53|
|Subject: Re: Backup suggestions|