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