Re: [GENERAL] Native DB replication for PG

2010-05-03 Thread Gauthier, Dave
...@commandprompt.com; Gauthier, Dave; r...@iol.ie; pgsql-general@postgresql.org Subject: Re: [GENERAL] Native DB replication for PG On Sat, May 1, 2010 at 9:27 AM, Tom Lane t...@sss.pgh.pa.us wrote: I'm curious to get to the bottom of Scott's report.  It's possible that he hit one of the two or three 8.4

Re: [GENERAL] Native DB replication for PG

2010-05-03 Thread Raymond O'Donnell
On 30/04/2010 21:30, Scott Marlowe wrote: On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave dave.gauth...@intel.com wrote: I believe v9 will have native DB master/slave DB replication (correct if wrong). If so, what’s the best guess on when will v9 be released? If I had to plan server

Re: [GENERAL] Native DB replication for PG

2010-05-03 Thread Merlin Moncure
On Mon, May 3, 2010 at 9:29 AM, Gauthier, Dave dave.gauth...@intel.com wrote: So, back to the base note, as far as native replication support, I should wait for v9 whic'll probably be out by the end of the summer? for 'native' replication waiting for 9.0 is your only option, because all of the

Re: [GENERAL] Native DB replication for PG

2010-05-03 Thread Scott Marlowe
On Mon, May 3, 2010 at 7:29 AM, Gauthier, Dave dave.gauth...@intel.com wrote: So, back to the base note, as far as native replication support, I should wait for v9 whic'll probably be out by the end of the summer? Yep. You should really start testing now though if you're gonna use it. --

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Greg Smith
Scott Marlowe wrote: I tested 8.4 what I thought was fairly hardly last year only to have 8.4.1 die under the same load that 8.3 handled without a problem, and reverted to the known working version putting testing 8.4.1 on hold. So to ME, the choice is a fully functional 8.3 installation that

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Scott Marlowe
On Sat, May 1, 2010 at 12:59 AM, Greg Smith g...@2ndquadrant.com wrote: Scott Marlowe wrote: I tested 8.4 what I thought was fairly hardly last year only to have 8.4.1 die under the same load that 8.3 handled without a problem, and reverted to the known working version putting testing 8.4.1

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Devrim GÜNDÜZ
On Sat, 2010-05-01 at 02:59 -0400, Greg Smith wrote: FYI, since December of 2009 (release of 8.4.2) there have been 10 bugs fixed with the word crash in their description, as well as 7 memory leaks that could potentially lead to crash. Even six months ago I was still hesitant to push 8.4

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Scott Marlowe
2010/5/1 Devrim GÜNDÜZ dev...@gunduz.org: On Sat, 2010-05-01 at 02:59 -0400, Greg Smith wrote: FYI, since December of 2009 (release of 8.4.2) there have been 10 bugs fixed with the word crash in their description, as well as 7 memory leaks that could potentially lead to crash.  Even six months

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Scott Marlowe
On Fri, Apr 30, 2010 at 9:02 PM, Greg Smith g...@2ndquadrant.com wrote: Joshua D. Drake wrote: On Fri, 2010-04-30 at 13:42 -0700, Gauthier, Dave wrote: If I had to plan server deployments for the next year (and I do) I'd be sticking with pg 8.3 and a proven replication engine.  Next summer

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Scott Marlowe
On Fri, Apr 30, 2010 at 11:33 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Fri, Apr 30, 2010 at 9:02 PM, Greg Smith g...@2ndquadrant.com wrote: Joshua D. Drake wrote: On Fri, 2010-04-30 at 13:42 -0700, Gauthier, Dave wrote: If I had to plan server deployments for the next year (and I

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Tom Lane
Greg Smith g...@2ndquadrant.com writes: Scott Marlowe wrote: I tested 8.4 what I thought was fairly hardly last year only to have 8.4.1 die under the same load that 8.3 handled without a problem, and reverted to the known working version putting testing 8.4.1 on hold. FYI, since December of

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Scott Marlowe
On Sat, May 1, 2010 at 9:27 AM, Tom Lane t...@sss.pgh.pa.us wrote: I'm curious to get to the bottom of Scott's report.  It's possible that he hit one of the two or three 8.4-only crashes we fixed since 8.4.1; or the bug may still be lurking. I'll definitely be testing it this summer to see if

Re: [GENERAL] Native DB replication for PG

2010-05-01 Thread Greg Smith
Tom Lane wrote: Greg Smith g...@2ndquadrant.com writes: FYI, since December of 2009 (release of 8.4.2) there have been 10 bugs fixed with the word crash in their description, as well as 7 memory leaks that could potentially lead to crash. Are we reading the same CVS log? I find quite a

[GENERAL] Native DB replication for PG

2010-04-30 Thread Gauthier, Dave
I believe v9 will have native DB master/slave DB replication (correct if wrong). If so, what's the best guess on when will v9 be released? Thanks!

Re: [GENERAL] Native DB replication for PG

2010-04-30 Thread Merlin Moncure
On Fri, Apr 30, 2010 at 2:17 PM, Gauthier, Dave dave.gauth...@intel.com wrote: I believe v9 will have native DB master/slave DB replication (correct if wrong).  If so, what’s the best guess on when will v9 be released? well, depends on how you define replication, but yes. my _guess_ on

Re: [GENERAL] Native DB replication for PG

2010-04-30 Thread Scott Marlowe
On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave dave.gauth...@intel.com wrote: I believe v9 will have native DB master/slave DB replication (correct if wrong).  If so, what’s the best guess on when will v9 be released? If I had to plan server deployments for the next year (and I do) I'd be

Re: [GENERAL] Native DB replication for PG

2010-04-30 Thread Gauthier, Dave
[mailto:r...@iol.ie] Sent: Friday, April 30, 2010 4:39 PM To: Scott Marlowe Cc: Gauthier, Dave; pgsql-general@postgresql.org Subject: Re: [GENERAL] Native DB replication for PG On 30/04/2010 21:30, Scott Marlowe wrote: On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave dave.gauth...@intel.com wrote

Re: [GENERAL] Native DB replication for PG

2010-04-30 Thread Joshua D. Drake
On Fri, 2010-04-30 at 13:42 -0700, Gauthier, Dave wrote: On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave dave.gauth...@intel.com wrote: I believe v9 will have native DB master/slave DB replication (correct if wrong). If so, what's the best guess on when will v9 be released? If I had

Re: [GENERAL] Native DB replication for PG

2010-04-30 Thread Scott Marlowe
On Fri, Apr 30, 2010 at 2:38 PM, Raymond O'Donnell r...@iol.ie wrote: On 30/04/2010 21:30, Scott Marlowe wrote: On Fri, Apr 30, 2010 at 12:17 PM, Gauthier, Dave dave.gauth...@intel.com wrote: I believe v9 will have native DB master/slave DB replication (correct if wrong).  If so, what’s the

Re: [GENERAL] Native DB replication for PG

2010-04-30 Thread Greg Smith
Joshua D. Drake wrote: On Fri, 2010-04-30 at 13:42 -0700, Gauthier, Dave wrote: If I had to plan server deployments for the next year (and I do) I'd be sticking with pg 8.3 and a proven replication engine. Next summer Surely you mean 8.4? :-) No, I would buy the 8.3