Re: [GENERAL] Standby servers and incrementally updated backups

2007-07-01 Thread Robert Treat
On Friday 29 June 2007 13:47, Erik Jones wrote: > On Jun 29, 2007, at 10:15 AM, Jim Nasby wrote: > > On Jun 25, 2007, at 4:54 PM, Erik Jones wrote: > >> On Jun 25, 2007, at 4:40 PM, Simon Riggs wrote: > >>> On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote: > On Jun 25, 2007, at 3:40 PM, Sim

Re: [GENERAL] Standby servers and incrementally updated backups

2007-06-29 Thread Erik Jones
On Jun 29, 2007, at 10:15 AM, Jim Nasby wrote: On Jun 25, 2007, at 4:54 PM, Erik Jones wrote: On Jun 25, 2007, at 4:40 PM, Simon Riggs wrote: On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote: On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote: If I'm correct, then for large databases wherei

Re: [GENERAL] Standby servers and incrementally updated backups

2007-06-29 Thread Jim Nasby
On Jun 25, 2007, at 4:54 PM, Erik Jones wrote: On Jun 25, 2007, at 4:40 PM, Simon Riggs wrote: On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote: On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote: If I'm correct, then for large databases wherein it can take hours to take a base backup, is ther

Re: [GENERAL] Standby servers and incrementally updated backups

2007-06-25 Thread Erik Jones
On Jun 25, 2007, at 4:40 PM, Simon Riggs wrote: On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote: On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote: If I'm correct, then for large databases wherein it can take hours to take a base backup, is there anything to be gained by using incrementally

Re: [GENERAL] Standby servers and incrementally updated backups

2007-06-25 Thread Simon Riggs
On Mon, 2007-06-25 at 16:00 -0500, Erik Jones wrote: > On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote: > >> If I'm correct, then for large databases wherein it can > >> take hours to take a base backup, is there anything to be gained by > >> using incrementally updated backups? > > > > If you are

Re: [GENERAL] Standby servers and incrementally updated backups

2007-06-25 Thread Erik Jones
On Jun 25, 2007, at 3:40 PM, Simon Riggs wrote: On Mon, 2007-06-25 at 13:42 -0500, Erik Jones wrote: It is my understanding that once a standby server has reached the point where it is often waiting for wal files to replay, it is pretty much caught up to the primary server, with the differenc

Re: [GENERAL] Standby servers and incrementally updated backups

2007-06-25 Thread Simon Riggs
On Mon, 2007-06-25 at 13:42 -0500, Erik Jones wrote: > It is my understanding that once a standby server has reached the > point where it is often waiting for wal files to replay, it is pretty > much caught up to the primary server, with the differences being in > whatever wal files are curr