Re: Log-shipping replication in one machine

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@aklaver.com