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.
In response to
pgsql-performance by date
|Next:||From: sathiya psql||Date: 2008-03-25 08:35:20|
|Subject: postgresql is slow with larger table even it is in RAM|
|Previous:||From: Chris||Date: 2008-03-25 04:18:00|
|Subject: Re: slow pg_connect()|