Re: Planning hot/live backups? - Mailing list pgsql-performance

From Matthew T. O'Connor
Subject Re: Planning hot/live backups?
Date
Msg-id 47E884A1.3010407@zeut.net
Whole thread Raw
In response to Re: Planning hot/live backups?  (Miguel Arroz <arroz@guiamac.com>)
List pgsql-performance
Miguel Arroz wrote:
> Going a bit off topic, but one quick question: to avoid storing GB of
> WAL files that will probably take a lot of time to reload, how can the
> backup be "reset"? I suspect that it's something like stopping the WAL
> archiving, doing a new base backup, and restart archiving, but I've
> never done it (have been using SQL dumps), so...

Basically, you only need WAL logs from the last time you made a back-up
of your data directory.  We do  nightly re-rsync of our data directory
and then purge old WAL files that are no longer needed.

pgsql-performance by date:

Previous
From: Chris
Date:
Subject: Re: slow pg_connect()
Next
From: "sathiya psql"
Date:
Subject: postgresql is slow with larger table even it is in RAM