Re: backup-strategies for large databases

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: MirrorX <mirrorx(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: backup-strategies for large databases
Date: 2011-08-14 05:29:45
Message-ID: CAOR=d=1_VSAZy64Ho7Jrk2LGN3DdAqOkrM0PgHT_B6tOfohumw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One possible answer to your issues is data partitioning. By
partitioning your data by date or primary key or some other field, you
can backup individual partitions for incremental backups. I run a
stats database that partitions by day daily and we can just backup
yesterday's partition each night. Each partition is in the 10 to 20
meg size range.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2011-08-14 07:06:04 INSERT-colision/MERGE in postgresql
Previous Message Greg Williamson 2011-08-13 23:45:51 Re: Using Postgresql as application server