Re: Hot standby documentation

Markus Wanner wrote:
> Bruce,
>
> Bruce Momjian wrote:
> > Ah, I now realize it only mentions "warm" standby, not "hot", so I just
> > updated the documentation to reflect that; you can see it here:
>
> Maybe the table below also needs an update, because unlike "Warm Standby
> using PITR", a hot standby accepts read-only queries and can be
> configured to not loose data on master failure.

Ahh, good point. I had not considered the table would change. What I
did was to mark "Slaves accept read-only queries" as "Hot only". You
can see the result here:

http://momjian.us/tmp/pgsql/high-availability.html

I did not change "Master failure will never lose data" because the 9.0
streaming implementation is not sychronous (see wal_sender_delay in
postgresql.conf), and I don't think even setting that to zero makes the
operation synchronous. I think we will have to wait for PG 9.1 for
_synchronous_ streaming replication.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +