Re: [HACKERS] Hot Standby Design

2008-09-24 Thread Simon Riggs
On Wed, 2008-09-24 at 12:35 -0400, Robert Treat wrote: > On Wednesday 24 September 2008 03:27:44 Simon Riggs wrote: > > On Wed, 2008-09-24 at 00:30 -0400, Robert Treat wrote: > > > * "However, some WAL redo actions will be for DDL actions. These DDL > > > actions are repeating actions that have al

Re: [HACKERS] Hot Standby Design

2008-09-24 Thread Robert Treat
On Wednesday 24 September 2008 03:27:44 Simon Riggs wrote: > On Wed, 2008-09-24 at 00:30 -0400, Robert Treat wrote: > > here are some scattered thoughts i had while reading it : > > Thanks for your comments. > > It is very detailed, so further feedback is going to be very beneficial > in making thi

Re: [HACKERS] Hot Standby Design

2008-09-24 Thread Simon Riggs
On Wed, 2008-09-24 at 08:28 +0100, Dave Page wrote: > On Wed, Sep 24, 2008 at 5:30 AM, Robert Treat > <[EMAIL PROTECTED]> wrote: > > > I presume this means the backend kill function would work? Also, can you go > > into why pgAgent would not work? (I presume it's because you can't update > > inf

Re: [HACKERS] Hot Standby Design

2008-09-24 Thread Dave Page
On Wed, Sep 24, 2008 at 5:30 AM, Robert Treat <[EMAIL PROTECTED]> wrote: > I presume this means the backend kill function would work? Also, can you go > into why pgAgent would not work? (I presume it's because you can't update > information that needs to be changed when jobs run, if thats the cas

Re: [HACKERS] Hot Standby Design

2008-09-24 Thread Simon Riggs
On Wed, 2008-09-24 at 00:30 -0400, Robert Treat wrote: > here are some scattered thoughts i had while reading it : Thanks for your comments. It is very detailed, so further feedback is going to be very beneficial in making this all work in the way we hope and expect. > * "However, some WAL red

Re: [HACKERS] Hot Standby Design

2008-09-23 Thread Robert Treat
On Tuesday 23 September 2008 14:15:34 Simon Riggs wrote: > Hot Standby design has been growing on the PostgreSQL Wiki for some > weeks now. > > I've updated the design to reflect all feedback received so far on > various topics. > > http://wiki.postgresql.org/wiki/Hot_Standby > > It's not hugely de

[HACKERS] Hot Standby Design

2008-09-23 Thread Simon Riggs
Hot Standby design has been growing on the PostgreSQL Wiki for some weeks now. I've updated the design to reflect all feedback received so far on various topics. http://wiki.postgresql.org/wiki/Hot_Standby It's not hugely detailed in every area, but it gives a flavour of the topics and issues re