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

[GENERAL] Standby servers and incrementally updated backups

2007-06-25 Thread Erik Jones
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 currently in queue to be archived by the primary. If I'm correc