Search Postgresql Archives

archive_command and streaming replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux