On 10/26/2014 09:46 PM, nurul [via PostgreSQL] wrote:
Thank you for your response. May i know what is the difference between log shipping and streaming replication actually? I'm sorry i am very new in postgreSQL and still confused with these two
For an overview see: http://www.postgresql.org/docs/9.3/interactive/warm-standby.html Short version: 1) Both deal with WAL files. 2) Log shipping ships the entire file (16MB by default) at a time. 3) Streaming ships records within the WAL file, so it works incrementally. -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
