Re: Synchronous Log Shipping Replication - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Synchronous Log Shipping Replication
Date
Msg-id 1221249981.12685.5.camel@huvostro
Whole thread Raw
In response to Re: Synchronous Log Shipping Replication  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Synchronous Log Shipping Replication  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Fri, 2008-09-12 at 17:45 +0100, Simon Riggs wrote:
> On Fri, 2008-09-12 at 17:11 +0200, Csaba Nagy wrote:
> 
> > Why not have a design where the slave is in control for it's own data ?
> > I mean the slave...
> 
> The slave only exists because it is a copy of the master. If you try to
> "startup" a slave without first having taken a copy, how would you
> bootstrap the slave? With what? To what? 

As I understand it, Csaba meant that slave would "bootstrap itself" by
connecting to master in some early phase of startup, requesting a
physical filesystem level copy of data, then commencing the startup in
Hot Standby mode.

If done that way, all the slave needs is a superuser level connection to
master database.

Of course this can also be done using little hot standby startup script
from slave, if shell access to master is provided,.
------------------
Hannu




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [Review] Tests citext casts by David Wheeler.
Next
From: Alvaro Herrera
Date:
Subject: Re: Synchronous Log Shipping Replication