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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers