3 ms·
This used to be the case, but it's not anymore. You can run long-living queries, run pg_dump, etc on slaves.
by joevandyk 14y ago
This used to be the case, but it's not anymore. You can run long-living queries, run pg_dump, etc on slaves.
- moe 14y agoDo you have a reference in which pg version this got fixed? We still pg_xlog_replay_pause() our slaves, it would be nice to drop that.
- bbromhead 14y agohttp://www.postgresql.org/docs/9.2/static/runtime-config-replication.html#GUC-MAX-STANDBY-ARCHIVE-DELAY http://www.postgresql.org/docs/9.2/static/runtime-config-rep...
- drdaeman 14y agoAh, that's really good news to hear. Seems it's time to upgrade. :) Could you, please, provide a reference to a documentation or a changelog? Maybe I'm looking for a wrong keywords, but I can't find any mentions of such changes by myself.