Tweeted twitter.com/#!/StackDBAs/status/243046107494625280
2 improved formatting and corrected grammar.
source | link

timelines and history files postgresqlPostgreSQL 9.1

Can someone explain meWhat is the purpose of timelines and, history files, and the setting 'recovery_target_timeline' in recovery.conf.recovery.conf?

The vague understanding I gothave from the postgresqlPostgreSQL 9.1 documentation is that when the slave completes recovery it switches to a new timeline to prevent overwriting of the WALs of a previous timeline. 

I am not clear how this is used in a recovery scenario, and the purpose of the .history file and the 'recovery_target_timeline' setting to 'latest'.

Thanks much.

timelines and history files postgresql 9.1

Can someone explain me the purpose of timelines and history files and the setting 'recovery_target_timeline' in recovery.conf.

The vague understanding I got from the postgresql 9.1 documentation is that when the slave completes recovery it switches to a new timeline to prevent overwriting of WALs of a previous timeline. I am not clear how this is used in a recovery scenario and the purpose of the .history file and the 'recovery_target_timeline' setting to 'latest'.

Thanks much.

timelines and history files PostgreSQL 9.1

What is the purpose of timelines, history files, and the setting 'recovery_target_timeline' in recovery.conf?

The vague understanding I have from the PostgreSQL 9.1 documentation is when the slave completes recovery it switches to a new timeline to prevent overwriting of the WALs of a previous timeline. 

I am not clear how this is used in a recovery scenario, and the purpose of the .history file and the 'recovery_target_timeline' setting to 'latest'.

1
source | link

timelines and history files postgresql 9.1

Can someone explain me the purpose of timelines and history files and the setting 'recovery_target_timeline' in recovery.conf.

The vague understanding I got from the postgresql 9.1 documentation is that when the slave completes recovery it switches to a new timeline to prevent overwriting of WALs of a previous timeline. I am not clear how this is used in a recovery scenario and the purpose of the .history file and the 'recovery_target_timeline' setting to 'latest'.

Thanks much.