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's say I shutdown one slave to create a second slave by copying all the files to that new slave. If I want to guarantee that the original slave is able to reestablish replication, I just need to make sure that the master keeps enough pg_xlog files (defined by the setting "checkpoint_segments") around in order for that to happen (especially in the event that the database is large). Thanks, Scott -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general