I inherited a 9.1 replication environment Few basic questions that I can't find clear answers / clarifications for if possible:
3 types of replication in 9.1 I've read about from the offical docs: 1) warm standby 2) hot standby 3) streaming replication I'm using streaming replication I believe, the only indication I have is that there is the primary_conninfo on the standby. Is this the only indication? Is it possible to get if using streaming replication under normal operations? *cp: cannot stat `/opt/postgres/9.1/archive/000000070000000F00000057': No such file or directory* *cp: cannot stat `/opt/postgres/9.1/archive/000000070000000F00000057': No such file or directory* *LOG: streaming replication successfully connected to primary* *FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 000000070000000F00000057 has already been removed* My understanding is that warm standby and hot standby do log shipping and there is a greater window for transactions not to be send to the standby because WAL XLOG must be filled. Whereas Streaming replication basically sends at the transaction level? I'm sure this is somewhat misinformed! Thanks, Will
