Re: [GENERAL] archive_command and streaming replication

2012-05-18 Thread Albe Laurenz
Scott Briggs wrote: > So if you do need to use wal files to catch up a slave, what would > that process be? If you caught up with wal files, how would streaming > replication know what positon to start at? And how would you tell > streaming replication the new position after catching up with wal >

Re: [GENERAL] archive_command and streaming replication

2012-05-16 Thread Scott Briggs
Thanks Laurenz for the response. So if you do need to use wal files to catch up a slave, what would that process be? If you caught up with wal files, how would streaming replication know what positon to start at? And how would you tell streaming replication the new position after catching up with

Re: [GENERAL] archive_command and streaming replication

2012-05-16 Thread Albe Laurenz
Scott Briggs wrote: > Hi, can someone please explain the purpose of archive_command on both > the master and slave when it comes to streaming replication? From > what I understand so far, what really matters is how many pg_xlog > files are kept when it comes to reestablishing replication when it >

[GENERAL] archive_command and streaming replication

2012-05-15 Thread Scott Briggs
Hi, can someone please explain the purpose of archive_command on both the master and slave when it comes to streaming replication? From what I understand so far, what really matters is how many pg_xlog files are kept when it comes to reestablishing replication when it breaks for some reason. Let'