Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup and failover process - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Backup and failover process
Date
Msg-id 487C9741.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Backup and failover process  ("Campbell, Lance" <lance@illinois.edu>)
Responses Re: Backup and failover process  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
Tree view 
>>> "Campbell, Lance" <lance@illinois.edu> wrote:
> PostgreSQL: 8.2
> I am about to change my backup and failover procedure from dumping a
full
> file SQL dump of our data every so many minutes

You're currently running pg_dump every so many minutes?

> to using WAL files.

Be sure you have read (and understand) this section of the docs:

http://www.postgresql.org/docs/8.2/interactive/backup.html

-Kevin

pgsql-admin by date:

Previous
From: Fernando Ike de Oliveira
Date:
Subject: Re: best starting points....
Next
From: Ivo Rossacher
Date:
Subject: Re: Changing encoding