On Fri, 2007-10-12 at 19:59 +0100, Richard Huxton wrote: > You could use WAL archiving, but you'll want a fairly regular > full-backup of PG's files otherwise the recovery could take a long time. > See Ch 23 of the manuals for details. Restartable recovery avoids the need to re-sync from the primary as often as was the case with 8.1 and prior. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
