Re: Understanding PG9.0 streaming replication feature

Thanks for the responses all, I have this working now. I had to create a
base backup before copying to the standby for replication to start, but the
main sticking point was actually understanding the terms and concepts
involved..

I think the Binary Replication Tutorial page on the wiki basically explains
everything. Unfortunately the actual pg manual is still about as clear as
mud even though I now have a vague idea of how this all works. I think this
is worth mentioning given the majority of the pg manual is actually of an
unusually high standard - probably among the best technical manuals I have
read in terms of being both comprehensive and concise, so it's a shame that
this section doesn't meet that standard (IMO). Hopefully this will get a
rewrite at some point!

cheers,

Ben