On Fri, Feb 26, 2010 at 8:30 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> How's it going to do that, when it has no queries at the instant
> of startup?
>

Why shouldn't it have any queries at walreceiver startup? It has any
xlog segments that were copied from the master and any it can find in
the archive, it could easily reach a consistent point long before it
needs to connect to the master. If you really want to protect your
master from any additional overhead you don't currently need to
configure a streaming connection at all, you can just use the file
shipping interface.

-- 
greg

In response to

• Re: Hot Standby query cancellation and Streaming Replication integration at 2010-02-26 20:30:01 from Tom Lane

Responses

• Re: Hot Standby query cancellation and Streaming Replication integration at 2010-02-26 21:19:39 from Tom Lane

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2010-02-26 21:19:39
	Subject: Re: Hot Standby query cancellation and Streaming Replication integration
Previous:	From: Josh Berkus	Date: 2010-02-26 21:06:10
	Subject: Re: Hot Standby query cancellation and Streaming Replication integration