Hi: Will V9.0.1 streaming replication replicate the effects of
"alter database foo rename to fee" ? Will it replicate "analyze" (I do this after a big
DB load to give the query optimizer good stats to work with)? If I kill a user on the master (using "pg_ctl kill ABRT
procpid"), will that goof up replication if that user was in the middle of
a write transation? I've read in http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#5_Minutes_to_Simple_Replication
... What Can't You Do With Binary Replication?
Replicate a specific table, schema, or
database. Binary replication is the entire Postgres instance (or
"cluster").
Multi-master replication. Multi-master binary
replication is probably technically impossible.
Replicate between different versions of
PostgreSQL, or between different platforms.
Set up replication without administration
rights on the server. Sorry, working on it. Replicate
data synchronously, guaranteeing zero data loss. But ... this is coming in
PostgreSQL 9.1. Beside the last one, are any of the other 4 going to be
addressed in 9.1 ? Thanks in advance. |